UFN_EVENTGLMAPPING_GETMAPPING

            CREATE function dbo.UFN_EVENTGLMAPPING_GETMAPPING(@CURRENTAPPUSERID uniqueidentifier = null) 
            returns table
            as return
                select 
                    row_number() over (order by EVENT.NAME) as ROWNUMBER,
                    EVENT.ID,
                    EVENT.NAME as Event,
                    MAP.ACCOUNTNUMBER,
                    MAP.PROJECTCODE
                from 
                    dbo.EVENT
                    left join dbo.EVENTGLMAPPING as MAP on EVENT.ID = MAP.ID
                where(
                        select count(*) 
                        from dbo.UFN_SITEID_MAPFROM_EVENTID(EVENT.ID) as EVENTSITE 
                        where dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, EVENTSITE.SITEID) = 1
                    ) > 0
                     and EVENT.PROGRAMID is null;