USP_SIMPLEDATALIST_MEMBERSHIPPROGRAMWITHLEVEL

                CREATE procedure dbo.USP_SIMPLEDATALIST_MEMBERSHIPPROGRAMWITHLEVEL
                (
                    @CURRENTAPPUSERID uniqueidentifier
                )
                as
                    select distinct
                        MP.ID as VALUE, 
                        MP.NAME as LABEL
                    from 
                        dbo.MEMBERSHIPPROGRAM as MP
                    inner join
                        dbo.MEMBERSHIPLEVEL ML on ML.MEMBERSHIPPROGRAMID = MP.ID
                    where
                        MP.ISACTIVE = 1 
                        and dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, MP.SITEID) = 1
                    order by
                        LABEL