UFN_REVENUE_GETNEXTINSTALLMENT_BULK

            CREATE function dbo.UFN_REVENUE_GETNEXTINSTALLMENT_BULK()
            returns table
            as return
            (
                select
                    FINANCIALTRANSACTION.ID as REVENUEID,
                    NEXTINSTALLMENT.ID as INSTALLMENTID,
                    NEXTINSTALLMENT.DATE as INSTALLMENTDATE
                from
                    dbo.FINANCIALTRANSACTION
                    outer apply (
                        select top 1 INSTALLMENT.ID, INSTALLMENT.DATE
                        from dbo.UFN_INSTALLMENT_GETINSTALLMENTBALANCE_BULK() as INSTALLMENT
                        where FINANCIALTRANSACTION.ID = INSTALLMENT.REVENUEID
                        and INSTALLMENT.BALANCE <> 0
                        order by INSTALLMENT.DATE asc
                    ) as NEXTINSTALLMENT
                    where FINANCIALTRANSACTION.DELETEDON is null
            )