UFN_RECURRINGGIFT_GETPASTDUEAMOUNT_BULK_2

            CREATE function dbo.UFN_RECURRINGGIFT_GETPASTDUEAMOUNT_BULK_2
            (
                @ASOFDATE date,
                @IGNORESTATUS bit = 0
            )
            returns table
            as
            return
            (
                select 
                    REVENUESCHEDULE.ID,
                    sum(INSTALLMENT.BALANCE) as AMOUNT
                from dbo.REVENUESCHEDULE
                inner join
                (
                    select
                        REVENUEID, 
                        BALANCE
                    from dbo.UFN_RECURRINGGIFTINSTALLMENT_GETINSTALLMENTBALANCE_BULK()
                    where [DATE] <= @ASOFDATE and (@IGNORESTATUS = 1 or [STATUSCODE] = 1)

                    union all

                    select 
                        FINANCIALTRANSACTION.ID as REVENUEID,
                        FINANCIALTRANSACTION.TRANSACTIONAMOUNT as BALANCE
                    from dbo.FINANCIALTRANSACTION
                    cross apply dbo.UFN_RECURRINGGIFT_GETMISSINGINSTALLMENTS(FINANCIALTRANSACTION.ID) I
                    where 
                        I.DATE <= @ASOFDATE
                    and @IGNORESTATUS = 1
                ) as INSTALLMENT on REVENUESCHEDULE.ID = INSTALLMENT.REVENUEID
                where 
                    REVENUESCHEDULE.STATUSCODE in (0, 1, 5)
                group by 
                    REVENUESCHEDULE.ID
            )