USP_ADDREQUESTSFORMULTIPLESTUDENTSPROCESS_GETPARAMETERS

CREATE procedure dbo.USP_ADDREQUESTSFORMULTIPLESTUDENTSPROCESS_GETPARAMETERS
 (
   @ID uniqueidentifier
    )        
  as begin

    select
        ID,
        NAME,
        DESCRIPTION,
        IDSETREGISTERID,
        CREATESTUDENTSIDSET,
        SELECTIONTYPEID,
        STUDENTSSELECTIONNAME, 
        OVERWRITESTUDENTSSELECTION,
        SCHOOLID,
        ACADEMICYEARID,
        SESSIONNAMECODEID,
        dbo.UFN_ADDREQUESTSFORMULTIPLESTUDENTS_GETCORE_TOITEMLISTXML(@ID) AS CORECURRICULA,
        dbo.UFN_ADDREQUESTSFORMULTIPLESTUDENTS_GETCOURSES_TOITEMLISTXML(@ID) AS COURSES
    from 
        dbo.ADDREQUESTSFORMULTIPLESTUDENTSPROCESS
    where
        ID = @ID   
   end