USP_DATAFORMTEMPLATE_VIEW_INSTALLMENT

                create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_INSTALLMENT
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @INSTALLMENTS xml = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    set @INSTALLMENTS = 
                    (
                        select
                            INSTALLMENT.ID,
                            INSTALLMENT.SEQUENCE,
                            (
                                select PAYMENTID as ID, AMOUNT
                                from dbo.INSTALLMENTPAYMENT
                                where PLEDGEID = @ID and INSTALLMENTID = INSTALLMENT.ID
                                for xml raw('ITEM'),type,elements,BINARY BASE64
                            ) SPLITS,
                            INSTALLMENT.TRANSACTIONAMOUNT as AMOUNT,
                            dbo.UFN_INSTALLMENT_GETINSTALLMENTAMOUNTAPPLIED(INSTALLMENT.ID) as APPLIED,
                            INSTALLMENT.TRANSACTIONRECEIPTAMOUNT as RECEIPTAMOUNT,
                            case
                                when INSTALLMENT.TRANSACTIONRECEIPTAMOUNT > dbo.UFN_INSTALLMENT_GETINSTALLMENTBALANCE(INSTALLMENT.ID)
                                    then INSTALLMENT.TRANSACTIONRECEIPTAMOUNT - dbo.UFN_INSTALLMENT_GETINSTALLMENTBALANCE(INSTALLMENT.ID)
                                else 0
                            end as RECEIPTAPPLIED
                        from dbo.INSTALLMENT
                        where INSTALLMENT.REVENUEID = @ID
                        order by SEQUENCE asc
                        for xml raw('ITEM'), type, elements, root('INSTALLMENTS'), BINARY BASE64
                    )

                    if @INSTALLMENTS is not null
                        set @DATALOADED = 1

                    return 0;