USP_SIMPLEDATALIST_BBPS_VENDOR

CREATE procedure dbo.USP_SIMPLEDATALIST_BBPS_VENDOR
(
    @CURRENTAPPUSERID uniqueidentifier
) as
    declare @APPUSERISSYSADMIN bit = dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID);
    declare @FEATUREID uniqueidentifier = '9151decb-5734-4fd9-8884-7d18aba1e2ed';

    declare @SITESFORUSERONFEATURE table (SITEID uniqueidentifier);
    insert into @SITESFORUSERONFEATURE
    select * from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@FEATUREID,2);

    select distinct CCD.VENDORID
    from dbo.CREDITCARDPAYMENTMETHODDETAIL CCD
    inner join dbo.REVENUEPAYMENTMETHOD RPM on CCD.ID = RPM.ID
    left join FINANCIALTRANSACTIONLINEITEM FTLI on FTLI.FINANCIALTRANSACTIONID = RPM.REVENUEID
    where CCD.VENDORID != '' 
        and (FTLI.ID is null
        or (--Check site security  

                select 
                    count(*)   
                from dbo.UFN_SITEID_MAPFROM_REVENUEID(RPM.REVENUEID) as SITE  
                where (
                    @APPUSERISSYSADMIN = 1 or 
                    exists (
                        select 1 
                        from @SITESFORUSERONFEATURE
                        where SITEID=[SITE].[SITEID] or (SITEID is null and [SITE].[SITEID] is null)
                    )
                ) 
            ) > 0)

    union all

    select distinct T.VENDORID
    from dbo.UNSETTLEDCREDITCARDTRANSACTION T
    where T.VENDORID != '' 
        and T.VENDORID not in (select CCD.VENDORID from dbo.CREDITCARDPAYMENTMETHODDETAIL CCD);