UFN_PLEDGEHASPOSTEDPAYMENTS

CREATE function dbo.UFN_PLEDGEHASPOSTEDPAYMENTS(@PLEDGEID 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 = @PLEDGEID 
        and FINANCIALTRANSACTION.POSTSTATUSCODE = 2
        and t2.DELETEDON is null)
        return 1


    if Exists(SELECT t0.ID  
         from dbo.FINANCIALTRANSACTION t0
               inner join dbo.INSTALLMENTSPLITWRITEOFF t1 on t0.ID = t1.WRITEOFFID 
               inner join dbo.INSTALLMENTSPLIT t2 on t1.INSTALLMENTSPLITID = t2.ID 
               where PLEDGEID = @PLEDGEID 
         and t0.POSTSTATUSCODE = 2
         and t0.DELETEDON is null
         and t0.TYPECODE = 20) 
        return 1

    return 0

end