USP_DATALIST_GIFTAIDREFRESHPROCESS

CREATE procedure dbo.USP_DATALIST_GIFTAIDREFRESHPROCESS
(
    @CURRENTAPPUSERID uniqueidentifier = null,
    @SITEFILTERMODE tinyint = 0,
    @SITESSELECTED xml = null,
    @SECURITYFEATUREID uniqueidentifier = null,
    @SECURITYFEATURETYPE tinyint = null
)
as
begin
    set nocount on;

    select
        GIFTAIDREFRESHPROCESS.ID,
        GIFTAIDREFRESHPROCESS.NAME,
        GIFTAIDREFRESHPROCESS.DESCRIPTION,
        coalesce(IDSETREGISTER.NAME, '') as SELECTION,
        BUSINESSPROCESSINSTANCE.OWNERID as OWNERID,
        coalesce(SITE.NAME,'All Sites') SITES
    from 
        dbo.GIFTAIDREFRESHPROCESS
        left join dbo.IDSETREGISTER on IDSETREGISTER.ID = GIFTAIDREFRESHPROCESS.IDSETREGISTERID
        left join dbo.BUSINESSPROCESSINSTANCE on GIFTAIDREFRESHPROCESS.ID = BUSINESSPROCESSINSTANCE.BUSINESSPROCESSPARAMETERSETID
        left join dbo.SITE on SITE.ID = BUSINESSPROCESSINSTANCE.SITEID
    where 
        dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, GIFTAIDREFRESHPROCESS.ID) = 1
        and (
                (
                    (--Check site security

                        select count(*) 
                        from dbo.UFN_SITEID_MAPFROM_GIFTAIDREFRESHPROCESSID(GIFTAIDREFRESHPROCESS.ID) as GIFTAIDPROCESSSITE 
                        where (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[GIFTAIDPROCESSSITE].[SITEID] or (SITEID is null and [GIFTAIDPROCESSSITE].[SITEID] is null)))
                    ) > 0
                )
                and (--Apply site filter

                    @SITEFILTERMODE = 0
                        or BUSINESSPROCESSINSTANCE.SITEID in (
                            select SITEID
                            from dbo.UFN_SITE_BUILDDATALISTSITEFILTER (@CURRENTAPPUSERID, @SITEFILTERMODE, @SITESSELECTED) 
                        )
                )
        )
    order by 
        GIFTAIDREFRESHPROCESS.NAME;
end