UFN_INSTALLMENT_GETINSTALLMENTS

            CREATE function dbo.UFN_INSTALLMENT_GETINSTALLMENTS
            (
                @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
                            inner 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
                from 
                    dbo.INSTALLMENT 
                where 
                    REVENUEID = @REVENUEID);