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;