UFN_INSTALLMENT_GETINSTALLMENTS_2

            CREATE function dbo.UFN_INSTALLMENT_GETINSTALLMENTS_2
            (
                @REVENUEID uniqueidentifier
            )
            returns table
            as
            return (
                select 
                    ID, 
                    DATE, 
                    AMOUNT,
                    dbo.UFN_INSTALLMENT_GETINSTALLMENTBALANCE(ID) as BALANCE,
                    dbo.UFN_INSTALLMENT_GETINSTALLMENTAMOUNTAPPLIED(ID) as APPLIED,
                    SEQUENCE,
                    (select INSTALLMENTSPLIT.ID, 
                            INSTALLMENTSPLIT.DESIGNATIONID, 
                            INSTALLMENTSPLIT.AMOUNT,
                            dbo.UFN_INSTALLMENT_GETINSTALLMENTSPLITAMOUNTAPPLIED(INSTALLMENTSPLIT.ID) APPLIED
                        from dbo.INSTALLMENTSPLIT
                            left join dbo.DESIGNATION on DESIGNATION.ID = INSTALLMENTSPLIT.DESIGNATIONID
                        where INSTALLMENTSPLIT.INSTALLMENTID = INSTALLMENT.ID
                        order by DESIGNATION.VANITYNAME
                        for xml raw('ITEM'),type,elements,BINARY BASE64
                    ) INSTALLMENTSPLITS,
                    BASECURRENCYID,
                    ORGANIZATIONAMOUNT,
                    ORGANIZATIONEXCHANGERATEID,
                    TRANSACTIONAMOUNT,
                    TRANSACTIONCURRENCYID,
                    BASEEXCHANGERATEID,
                    RECEIPTAMOUNT,
                    TRANSACTIONRECEIPTAMOUNT,
                    ORGANIZATIONRECEIPTAMOUNT
                from 
                    dbo.INSTALLMENT
                where 
                    REVENUEID = @REVENUEID);