USP_DATALIST_CLEARMGCLAIMPROCESS

Returns a list of saved parameter sets for the Clear Matching Gift Claims process.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



                create procedure dbo.USP_DATALIST_CLEARMGCLAIMPROCESS
                (
                    @CURRENTAPPUSERID uniqueidentifier = null
                )
                as 
                set nocount on;

                select
                    [PROCESS].ID,
                    [PROCESS].NAME,
                    [PROCESS].DESCRIPTION,
                    case
                        when [PROCESS].SELECTIONID is null then N''
                        else (select NAME from dbo.IDSETREGISTER where IDSETREGISTER.ID = [PROCESS].SELECTIONID)
                    end,
                    [BPI].OWNERID
                from dbo.CLEARMATCHINGGIFTCLAIMSPROCESS as [PROCESS]
                left join dbo.BUSINESSPROCESSINSTANCE as [BPI] on [PROCESS].ID = [BPI].BUSINESSPROCESSPARAMETERSETID
                where (dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, [PROCESS].ID) = 1)
                order by [PROCESS].NAME