USP_DATALIST_MEMBERSHIPPROGRAMLIFETIMEPAYMENTOPTIONS

CREATE procedure dbo.USP_DATALIST_MEMBERSHIPPROGRAMLIFETIMEPAYMENTOPTIONS(@CONTEXTID uniqueidentifier)
as
    set nocount on;

    select distinct
      ML.MEMBERSHIPPROGRAMID,
        MLT.LIFETIMEPAYMENTOPTION,
        case when MLT.LIFETIMEPAYMENTOPTIONCODE = 0 then 1 else MLT.LIFETIMENUMBEROFPAYMENTS end as LIFETIMENUMBEROFPAYMENTS
    from 
        MEMBERSHIPLEVELTERM MLT
        inner join MEMBERSHIPLEVEL ML on MLT.LEVELID = ML.ID
    where ML.MEMBERSHIPPROGRAMID = @CONTEXTID and MLT.ISACTIVE = 1