USP_R68_GETARCHIVEDPROCESSPARAMETERS

Returns the archived parameters for a given business process status id of an R68 business process.

Parameters

Parameter	Parameter Type	Mode	Description
@BUSINESSPROCESSSTATUSID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_R68_GETARCHIVEDPROCESSPARAMETERS
(
    @BUSINESSPROCESSSTATUSID uniqueidentifier
)
as 
    set nocount on;

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