UFN_REVENUE_GRANTEDBYSITE_FOR_APPUSER_QUERYVIEW

CREATE function dbo.[UFN_REVENUE_GRANTEDBYSITE_FOR_APPUSER_QUERYVIEW] (
    @APPUSERID uniqueidentifier,
    @QUERYVIEWCATALOGID uniqueidentifier
    )
returns table
as
return (
    select distinct FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID as ID
    from 
        dbo.FINANCIALTRANSACTIONLINEITEM
        cross apply dbo.UFN_SITEID_MAPFROM_REVENUESPLITID(FINANCIALTRANSACTIONLINEITEM.ID) SITES
        inner join dbo.[SITEPERMISSION]
            on [SITEPERMISSION].[SITEID] = SITES.SITEID
        inner join dbo.[V_SECURITY_SYSTEMROLEASSIGNMENT_USER_QUERYVIEW] as [SECURITYVIEW]
            on [SECURITYVIEW].[SYSTEMROLEID] = [SITEPERMISSION].[SYSTEMROLEID]
                and [SECURITYVIEW].[APPUSERID] = [SITEPERMISSION].[APPUSERID]
    where
        [SECURITYVIEW].[APPUSERID] = @APPUSERID
        and [SECURITYVIEW].[QUERYVIEWCATALOGID] = @QUERYVIEWCATALOGID
        and [SECURITYVIEW].[GRANTORDENY] = 1
        and [SECURITYVIEW].[SITESECURITYMODE] > 1
    );