USP_SIMPLEDATALIST_DEPOSITABLE_OTHERPAYMENTMETOHD_WITHALL

create procedure dbo.USP_SIMPLEDATALIST_DEPOSITABLE_OTHERPAYMENTMETOHD_WITHALL as
    select VALUE, LABEL
    from
    (select 
        OTHERPAYMENTMETHODCODE.ID as VALUE, 
        DESCRIPTION as LABEL,
        SEQUENCE
    from dbo.OTHERPAYMENTMETHODCODE
    left join dbo.NONDEPOSITABLEPAYMENTMETHOD on NONDEPOSITABLEPAYMENTMETHOD.ID = OTHERPAYMENTMETHODCODE.ID
    where ACTIVE = 1 and NONDEPOSITABLEPAYMENTMETHOD.ID is null
    union all
    select '99999999-9999-9999-9999-999999999999', 'All other subtypes', 0) V1
    order by SEQUENCE