UFN_CONSTITUENT_GRANTEDBYCONSTITSECURITY_FOR_APPUSER_QUERYVIEW

create function BBDW.[UFN_CONSTITUENT_GRANTEDBYCONSTITSECURITY_FOR_APPUSER_QUERYVIEW] (
    @APPUSERID uniqueidentifier,
    @QUERYVIEWCATALOGID uniqueidentifier
    )
returns table
as
return (
    select CSAA.[CONSTITUENTSYSTEMID] as [ID]
    from 
        BBDW.[FACT_CONSTITUENTSECURITYGROUPASSIGNMENT] as CSAA
    WHERE
        CSAA.[CONSTITUENTSECURITYGROUPDIMID] IN 
            (
                select 
                    [FACT_SYSTEMROLEAPPUSERCONSTITUENTSECURITY].[CONSTITUENTSECURITYGROUPDIMID]
                from BBDW.[v_SECURITY_SYSTEMROLEASSIGNMENT_USER_QUERYVIEW] as SV
                inner join BBDW.[FACT_SYSTEMROLEAPPUSER] on [FACT_SYSTEMROLEAPPUSER].[SYSTEMROLEAPPUSERFACTID] = SV.[SYSTEMROLEAPPUSERFACTID]
                inner join BBDW.[FACT_SYSTEMROLEAPPUSERCONSTITUENTSECURITY] on SV.[SYSTEMROLEAPPUSERFACTID] = [FACT_SYSTEMROLEAPPUSERCONSTITUENTSECURITY].[SYSTEMROLEAPPUSERFACTID]
                where SV.[APPUSERID] = @APPUSERID and 
                SV.[QUERYVIEWCATALOGID] = @QUERYVIEWCATALOGID and 
                SV.[GRANTORDENY] = 1 and
                [FACT_SYSTEMROLEAPPUSER].[APPUSERSYSTEMID] = @APPUSERID and
                [FACT_SYSTEMROLEAPPUSER].[CONSTITUENTSECURITYMODE] = 2 
            )
    );