USP_SPONSORSHIPLOCATIONCLOSE_GETPARAMETERS

Retrieves parameters from the sponsorship location close process table

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



      create procedure dbo.USP_SPONSORSHIPLOCATIONCLOSE_GETPARAMETERS
       (
         @ID uniqueidentifier
          )        
        as begin
          select
          ID,
          NAME,
          SPONSORSHIPREASONID,
          PROGRAMMAPPINGS,
          CREATEOUTPUTIDSET,
          OUTPUTIDSETTYPECODE,
          OUTPUTIDSETNAME,
          OVERWRITEOUTPUTIDSET
          from 
              dbo.SPONSORSHIPLOCATIONCLOSEPROCESS 
          where
              ID = @ID   
         end