UFN_MEMBERSHIPPROGRAM_INSTALLMENTS_HASOFPOSTSTATUSCODE

create function dbo.UFN_MEMBERSHIPPROGRAM_INSTALLMENTS_HASOFPOSTSTATUSCODE(
    @MEMBERSHIPPROGRAMID uniqueidentifier,
    @POSTSTATUSCODE tinyint
)
returns bit
with execute as caller
as begin
    if exists (
        select 1
        from dbo.MEMBERSHIP
        inner join dbo.MEMBERSHIPTRANSACTION on
            MEMBERSHIP.ID = MEMBERSHIPTRANSACTION.MEMBERSHIPID
        inner join dbo.FINANCIALTRANSACTIONLINEITEM on
            MEMBERSHIPTRANSACTION.REVENUESPLITID = FINANCIALTRANSACTIONLINEITEM.ID
        inner join dbo.FINANCIALTRANSACTION on
            FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = FINANCIALTRANSACTION.ID
        where 
            MEMBERSHIP.MEMBERSHIPPROGRAMID = @MEMBERSHIPPROGRAMID and
            FINANCIALTRANSACTION.TYPECODE = 15 and
            FINANCIALTRANSACTION.POSTSTATUSCODE = @POSTSTATUSCODE
    )
        return 1;

    return 0;
end