USP_SIMPLEDATALIST_DAILYSALEITEMMEMBERSHIPPROGRAM

                CREATE procedure dbo.USP_SIMPLEDATALIST_DAILYSALEITEMMEMBERSHIPPROGRAM (
                    @CURRENTAPPUSERID uniqueidentifier)
                as
                    select 
                        MEMBERSHIPPROGRAM.ID as VALUE, 
                        MEMBERSHIPPROGRAM.NAME as LABEL
                    from 
                        dbo.MEMBERSHIPPROGRAM
                    where
                        MEMBERSHIPPROGRAM.ISACTIVE = 1    and 
                        MEMBERSHIPPROGRAM.PROGRAMTYPECODE = 0 and 
                        MEMBERSHIPPROGRAM.PROGRAMBASEDONCODE = 0 and
                        MEMBERSHIPPROGRAM.ONEPAYMENTEACHTERM = 1
                    order by LABEL