USP_DATALIST_EVENTGLMAPPING

                CREATE procedure dbo.USP_DATALIST_EVENTGLMAPPING(
                    @CURRENTAPPUSERID uniqueidentifier = null
                )
                as                 
                    set nocount on;

                    select 
                        EVENT.ID, 
                        EVENT.[NAME] as EVENTNAME,
                        MAP.ACCOUNTNUMBER,
                        MAP.PROJECTCODE,
                        'IMAGEKEY' = case when (MAP.ACCOUNTNUMBER is null or MAP.ACCOUNTNUMBER = '' 
                                        or MAP.PROJECTCODE is null or MAP.PROJECTCODE = '') then 'RES:warning' else '' end
                    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
                    order by 
                        EVENT.NAME;