UFN_REVENUE_GRANTEDBYCONSTITUENTSECURITY_FOR_APPUSER_QUERYVIEW

CREATE function dbo.[UFN_REVENUE_GRANTEDBYCONSTITUENTSECURITY_FOR_APPUSER_QUERYVIEW] (
    @APPUSERID uniqueidentifier,
    @QUERYVIEWCATALOGID uniqueidentifier
    )
returns table
as
return (
    select REVENUE.ID
    from 
        dbo.CONSTIT_SECURITY_ATTRIBUTE_ASSIGNMENT as CSAA
        inner join dbo.REVENUE
            on REVENUE.CONSTITUENTID = CSAA.CONSTITUENTID
    WHERE
        CSAA.CONSTIT_SECURITY_ATTRIBUTEID IN 
            (
                select 
                    SYSTEMROLEAPPUSERCONSTITUENTSECURITY.CONSTITUENTSECURITYATTRIBUTEID
                from 
                    dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_QUERYVIEW as SV
                    inner join dbo.SYSTEMROLEAPPUSER on SYSTEMROLEAPPUSER.APPUSERID = SV.APPUSERID and SYSTEMROLEAPPUSER.SYSTEMROLEID = SV.SYSTEMROLEID
                    inner join dbo.SYSTEMROLEAPPUSERCONSTITUENTSECURITY on SYSTEMROLEAPPUSERCONSTITUENTSECURITY.SYSTEMROLEAPPUSERID = SYSTEMROLEAPPUSER.ID
                where
                    SV.APPUSERID = @APPUSERID AND 
                    SV.QUERYVIEWCATALOGID = @QUERYVIEWCATALOGID AND 
                    SV.GRANTORDENY = 1 and
                    SYSTEMROLEAPPUSER.APPUSERID = @APPUSERID and
                    SYSTEMROLEAPPUSER.CONSTITUENTSECURITYMODECODE = 2 
            )
    );