USP_SPONSORSHIPOPPORTUNITYINELIGIBLE_GETPARAMETERS

CREATE procedure dbo.USP_SPONSORSHIPOPPORTUNITYINELIGIBLE_GETPARAMETERS
 (
   @ID uniqueidentifier
    )        
  as begin
    select
    PROCESS.ID
   ,PROCESS.NEWSPONSORSHIPOPPORTUNITYID
   ,PROCESS.SPONSORSHIPREASONID
   ,PROCESS.CREATEOUTPUTIDSET
   ,PROCESS.OUTPUTIDSETTYPECODE
   ,PROCESS.OUTPUTIDSETNAME
   ,PROCESS.OVERWRITEOUTPUTIDSET
    from 
        dbo.SPONSORSHIPOPPORTUNITYTRANSFERPROCESS PROCESS
    where
        PROCESS.ID = @ID   
   end