USP_R68_GETPROCESSPARAMETERS

Returns the parameters for a given parameter set instance of the R68 business process.

Parameters

Parameter Parameter Type Mode Description
@R68ID uniqueidentifier IN

Definition

Copy


            CREATE procedure dbo.USP_R68_GETPROCESSPARAMETERS
            (
                @R68ID uniqueidentifier
            )
            as 
            set nocount on;

            select 
                R68.NAME,
                R68.DESCRIPTION,
                R68.IDSETREGISTERID,
                R68.STARTDATE,
                R68.ENDDATE,
                R68.UPDATEGIFTAIDSTATUS,
                R68.TAXCLAIMNUMBER,
                R68.REFERENCENUMBER,
                dbo.UFN_IDSET_GETNAME(R68.IDSETREGISTERID) as FILTERNAME,
        R68.RUNGIFTAIDSPONSORSHIPSONLY
            from dbo.R68
            where R68.ID = @R68ID;