UFN_PLEDGE_PAYMENTSEXIST

CREATE function dbo.UFN_PLEDGE_PAYMENTSEXIST
(
    @REVENUEID uniqueidentifier
)
returns bit
with execute as caller
as begin

    declare @EXISTS bit;

    if exists(
        select
            top 1 PAYMENTID
        from
            dbo.INSTALLMENT 
            inner join dbo.INSTALLMENTSPLIT on INSTALLMENT.ID = INSTALLMENTSPLIT.INSTALLMENTID
            inner join dbo.INSTALLMENTSPLITPAYMENT ON INSTALLMENTSPLIT.ID = INSTALLMENTSPLITPAYMENT.INSTALLMENTSPLITID
            --inner join dbo.INSTALLMENTPAYMENT on INSTALLMENT.ID = INSTALLMENTPAYMENT.INSTALLMENTID

        where
            INSTALLMENT.REVENUEID = @REVENUEID
    )
        set @EXISTS = 1
    else
        set @EXISTS = 0

    return @EXISTS;
end