UFN_REVENUE_HASPOSTEDPAYMENTS

create function dbo.UFN_REVENUE_HASPOSTEDPAYMENTS(@REVENUEID uniqueidentifier)
returns bit
with execute as caller
as begin

    if Exists(SELECT FINANCIALTRANSACTIONID 
              from dbo.INSTALLMENTSPLITPAYMENT  t1 
              inner join dbo.FINANCIALTRANSACTIONLINEITEM t2 on t1.PAYMENTID=t2.ID 
              inner join dbo.FINANCIALTRANSACTION ON t2.FINANCIALTRANSACTIONID = FINANCIALTRANSACTION.ID
              where PLEDGEID = @REVENUEID 
        and FINANCIALTRANSACTION.POSTSTATUSCODE = 2
        and t2.DELETEDON is null)
        return 1

    return 0

end