UFN_MEMBERSHIPGLMAPPING_GETMAPPING

            create function dbo.UFN_MEMBERSHIPGLMAPPING_GETMAPPING(@CURRENTAPPUSERID uniqueidentifier = null) 
            returns table
            as return
                select 
                    row_number() over (order by MP.NAME) as ROWNUMBER,
                    ML.ID,
                    MP.NAME + ' - ' + ML.NAME as MEMBERSHIPLEVEL,
                    MAP.ACCOUNTNUMBER,
                    MAP.PROJECTCODE
                from dbo.MEMBERSHIPLEVEL ML
                inner join dbo.MEMBERSHIPPROGRAM MP on ML.MEMBERSHIPPROGRAMID = MP.ID
                left join dbo.MEMBERSHIPGLMAPPING as MAP on ML.ID = MAP.ID
                where dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, MP.SITEID)=1;