USP_DATALIST_MEMBERSHIPPROGRAMINFO

            CREATE procedure dbo.USP_DATALIST_MEMBERSHIPPROGRAMINFO
            (
                @MEMBERSHIPPROGRAMID uniqueidentifier
            )
            as
                set nocount on;

                select 
                    MEMBERSHIPPROGRAM.ID,
                    MEMBERSHIPPROGRAM.NAME,
                    MEMBERSHIPPROGRAM.ONEPAYMENTEACHTERM,
                    MEMBERSHIPPROGRAM.MULTIPLEPAYMENTSEACHTERM,
                    MEMBERSHIPPROGRAM.DUESTREATEDASCONTRIBUTION,
                    MEMBERSHIPPROGRAM.EXPIRESONCODE,
                    MEMBERSHIPPROGRAM.CUTOFFDAY,
                    MEMBERSHIPPROGRAM.CUTOFFDATEFORYEAR,
                    MEMBERSHIPPROGRAM.BASECURRENCYID,
                    MEMBERSHIPPROGRAM.PROGRAMTYPECODE,
                    MEMBERSHIPPROGRAM.DEDUCTIBILITYCODE,
                    MEMBERSHIPPROGRAM.RENEWALWINDOWREVENUETYPECODE,
                    coalesce(MEMBERSHIPPROGRAMCONTRIBUTION.WHATDATETOCALCULATEEXPIRATIONDATECODE, 0) as CONTRIBUTIONBASEDEXPIRESONCODE,
          MEMBERSHIPPROGRAM.WHEREISREVENUETRACKEDCODE
                from dbo.MEMBERSHIPPROGRAM
                left outer join dbo.MEMBERSHIPPROGRAMCONTRIBUTION
                        on MEMBERSHIPPROGRAMCONTRIBUTION.ID = MEMBERSHIPPROGRAM.ID
                where MEMBERSHIPPROGRAM.ID = @MEMBERSHIPPROGRAMID