UFN_PLEDGEWRITEOFFBATCH_GETINSTALLMENTS

            CREATE function dbo.UFN_PLEDGEWRITEOFFBATCH_GETINSTALLMENTS
            (
                @BATCHROWID uniqueidentifier,
        @REVENUEID uniqueidentifier
            )
            returns table
            as
            return (
select 
  BATCHPLEDGEWRITEOFFINSTALLMENT.ID,
  INSTALLMENT.ID as INSTALLMENTID,
    INSTALLMENT.date,
    INSTALLMENT.AMOUNT,
    A.BALANCE as BALANCE,
    COALESCE(BATCHPLEDGEWRITEOFFINSTALLMENT.AMOUNT, 0) as WRITEOFFAMOUNT,
    INSTALLMENT.SEQUENCE,
    INSTALLMENT.BASECURRENCYID,
    INSTALLMENT.ORGANIZATIONAMOUNT,
    INSTALLMENT.ORGANIZATIONEXCHANGERATEID,
    INSTALLMENT.TRANSACTIONAMOUNT,
    INSTALLMENT.TRANSACTIONCURRENCYID,
    INSTALLMENT.BASEEXCHANGERATEID
from dbo.INSTALLMENT
left join dbo.BATCHPLEDGEWRITEOFFINSTALLMENT on INSTALLMENT.ID = BATCHPLEDGEWRITEOFFINSTALLMENT.INSTALLMENTID and BATCHPLEDGEWRITEOFFINSTALLMENT.BATCHPLEDGEWRITEOFFID = @BATCHROWID
left join dbo.UFN_INSTALLMENT_GETINSTALLMENTBALANCE_BULK() A on A.ID = INSTALLMENT.ID
where INSTALLMENT.REVENUEID = @REVENUEID and coalesce(A.BALANCE, 0) > 0
            )