UFN_REVENUEBATCH_GETINSTALLMENTS

            CREATE function dbo.UFN_REVENUEBATCH_GETINSTALLMENTS
            (
                @BATCHREVENUEID uniqueidentifier
            )
            returns table as  
    return (  
    select  
     BATCHREVENUEINSTALLMENT.ID,  
     BATCHREVENUEINSTALLMENT.AMOUNT,  
     BATCHREVENUEINSTALLMENT.DATE,  
     BATCHREVENUEINSTALLMENT.SEQUENCE,  
     BATCHREVENUEINSTALLMENT.RECEIPTAMOUNT,  
     (select   
       BATCHREVENUEINSTALLMENTSPLIT.ID,   
       BATCHREVENUEINSTALLMENTSPLIT.INSTALLMENTSPLITID,   
       BATCHREVENUEINSTALLMENTSPLIT.DESIGNATIONID,   
       BATCHREVENUEINSTALLMENTSPLIT.AMOUNT,  
       INSTALLMENTSPLIT.REVENUESPLITID
      from dbo.BATCHREVENUEINSTALLMENTSPLIT  
      left join dbo.DESIGNATION on DESIGNATION.ID = BATCHREVENUEINSTALLMENTSPLIT.DESIGNATIONID  
      left join dbo.UFN_INSTALLMENT_GETINSTALLMENTSPLITINFO_BULK() INSTALLMENTSPLIT on INSTALLMENTSPLIT.ID = BATCHREVENUEINSTALLMENTSPLIT.INSTALLMENTSPLITID  
      where BATCHREVENUEINSTALLMENTSPLIT.BATCHREVENUEINSTALLMENTID = BATCHREVENUEINSTALLMENT.ID  
      order by DESIGNATION.VANITYNAME  
      for xml raw('ITEM'),type,elements,BINARY BASE64  
     ) INSTALLMENTSPLITS
    from   
     dbo.BATCHREVENUEINSTALLMENT  
    where   
     BATCHREVENUEID = @BATCHREVENUEID  
        );