UFN_FAFPROGRAM_USERHASSITEACCESS

            create function dbo.UFN_FAFPROGRAM_USERHASSITEACCESS
            (
                @APPUSERID uniqueidentifier,
                @FAFPROGRAMID uniqueidentifier
            ) 
            returns bit with execute as caller
            as
            begin                

                if exists(select SITEID from dbo.UFN_SITEID_MAPFROM_FAFPROGRAMID(@FAFPROGRAMID) as FAFPROGRAMSITES where dbo.UFN_SITEALLOWEDFORUSER(@APPUSERID, FAFPROGRAMSITES.SITEID) = 1)                
                    return 1
                else
                    return 0

                return 0
            end