USP_DATALIST_MEMBERSHIPGLMAPPING

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

                    select 
                        MEMBERSHIPLEVEL.ID, 
                        MEMBERSHIPPROGRAM.NAME + ' - ' + MEMBERSHIPLEVEL.NAME as LEVELNAME,
                        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.MEMBERSHIPLEVEL
                    inner join dbo.MEMBERSHIPPROGRAM on MEMBERSHIPLEVEL.MEMBERSHIPPROGRAMID = MEMBERSHIPPROGRAM.ID
                    left join dbo.MEMBERSHIPGLMAPPING as MAP on MEMBERSHIPLEVEL.ID = MAP.ID
                    where dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, MEMBERSHIPPROGRAM.SITEID)=1                                   
                    order by MEMBERSHIPPROGRAM.NAME, MEMBERSHIPLEVEL.SEQUENCE;