USP_DATALIST_R68

Returns a list of R68 process parameter sets.
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_R68
                (
                    @CURRENTAPPUSERID uniqueidentifier = null
                )
                as
                    set nocount on;

                    select distinct
                        R68.ID,
                        R68.NAME,
                        R68.DESCRIPTION,
                        R68.REFERENCENUMBER,
                        R68.TAXCLAIMNUMBER,
                        (select top 1 BPS.STATUS from dbo.BUSINESSPROCESSSTATUS BPS WHERE BPS.BUSINESSPROCESSPARAMETERSETID = R68.ID order by BPS.STARTEDON desc) as STATUS,
                        BPI.OWNERID as OWNERID                            
                    from
                        dbo.R68
                        left join dbo.BUSINESSPROCESSINSTANCE BPI on R68.ID = BPI.BUSINESSPROCESSPARAMETERSETID
                        left join dbo.CHARITYCLAIMREFERENCENUMBER on R68.REFERENCENUMBER = CHARITYCLAIMREFERENCENUMBER.REFERENCENUMBER
                        left join dbo.CHARITYCLAIMREFERENCENUMBERSITE on CHARITYCLAIMREFERENCENUMBER.ID = CHARITYCLAIMREFERENCENUMBERSITE.CHARITYCLAIMREFERENCENUMBERID
                    where 
                        dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, R68.ID) = 1 and
                        exists( select 1 from dbo.UFN_APPUSER_HASPERMISSIONFORDECLARATION(@CURRENTAPPUSERID, CHARITYCLAIMREFERENCENUMBER.ID))
                    order by R68.NAME