UFN_APPEAL_GRANTEDBYSITE_FOR_APPUSER_QUERYVIEW

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