USP_SPONSORSHIPTRANSFERPROCESS_GETPARAMETERS

CREATE procedure dbo.USP_SPONSORSHIPTRANSFERPROCESS_GETPARAMETERS
 (
   @ID uniqueidentifier
    )        
  as begin
    select
   ID,
   NAME,
   DESCRIPTION,
   IDSETREGISTERID, 
   SPONSORSHIPPROGRAMID,
   SPONSORSHIPLOCATIONID,          
   SPROPPAGERANGEID,
   GENDERCODE, 
   ISHIVPOSITIVECODE, 
   HASCONDITIONCODE,
   ISORPHANEDCODE,
   SPROPPPROJECTCATEGORYCODEID,
   SPONSORPREFERENCECODE,   
   SPONSORSHIPREASONID,
   MATCHINGRULECODE,
   TRANSFERTYPECODE,
      CREATESOURCESPONSORSHIPSIDSET,
   SOURCESELECTIONNAME, 
   OVERWRITESOURCESELECTION,
   CREATETARGETSPONSORSHIPSIDSET,
   TARGETSELECTIONNAME, 
   OVERWRITETARGETSELECTION,
   CREATEUNSUCCESSFULSPONSORSHIPSIDSET,
   UNSUCCESSFULSELECTIONNAME, 
   OVERWRITEUNSUCCESSFULSELECTION
    from 
        dbo.SPONSORSHIPTRANSFERPROCESS 
    where
        ID = @ID   
   end