USP_SIMPLEDATALIST_MEMBERSHIPPROGRAMPROMOTION

CREATE procedure dbo.USP_SIMPLEDATALIST_MEMBERSHIPPROGRAMPROMOTION
(
    @MEMBERSHIPPROGRAMID uniqueidentifier,
    @TRANSACTIONCURRENCYID uniqueidentifier
)
as
    set nocount on;

    if @TRANSACTIONCURRENCYID is null
        set @TRANSACTIONCURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();

    select
        MP.ID as VALUE,
        MP.NAME as LABEL
    from dbo.MEMBERSHIPPROMO MP
    inner join dbo.MEMBERSHIPPROMOAVAILABILITY MPA 
        on MP.ID = MPA.MEMBERSHIPPROMOID
    where MPA.MEMBERSHIPPROGRAMID = @MEMBERSHIPPROGRAMID
        and MP.ISACTIVE = 1
        and (MP.BASECURRENCYID = @TRANSACTIONCURRENCYID or PROMOTIONTYPECODE = 1 or (PROMOTIONTYPECODE = 0 and DISCOUNTCALCULATIONTYPECODE = 1))
    order by MP.NAME;