UFN_RECURRINGGIFTINSTALLMENT_GETWRITEOFFINSTALLMENTS_BULK

CREATE function dbo.UFN_RECURRINGGIFTINSTALLMENT_GETWRITEOFFINSTALLMENTS_BULK()
returns table            
as            
return (
    select 
        RECURRINGGIFTINSTALLMENTBALANCE.ID,
        RECURRINGGIFTINSTALLMENTBALANCE.REVENUEID,
        RECURRINGGIFTINSTALLMENTBALANCE.DATE,
        RECURRINGGIFTINSTALLMENT.TRANSACTIONAMOUNT,
        RECURRINGGIFTINSTALLMENTBALANCE.BALANCE,
        cast(0.0 as money) as WRITEOFFAMOUNT,
        RECURRINGGIFTINSTALLMENT.STATUSCODE
    from 
        dbo.UFN_RECURRINGGIFTINSTALLMENT_GETINSTALLMENTBALANCE_BULK() as RECURRINGGIFTINSTALLMENTBALANCE
        --TODO: Can we remove this by returning TRANSACTIONAMOUNT from UFN_RECURRINGGIFTINSTALLMENT_GETINSTALLMENTBALANCE_BULK?

        left join dbo.RECURRINGGIFTINSTALLMENT on RECURRINGGIFTINSTALLMENTBALANCE.ID = RECURRINGGIFTINSTALLMENT.ID
    where 
        RECURRINGGIFTINSTALLMENTBALANCE.BALANCE > 0

    union all

    select
        null,
        MISSINGINSTALLMENTS.REVENUEID,
        MISSINGINSTALLMENTS.DATE,
        REVENUE.TRANSACTIONAMOUNT,
        REVENUE.TRANSACTIONAMOUNT as BALANCE,
        cast(0.0 as money) as WRITEOFFAMOUNT,
        0 STATUSCODE
    from
        dbo.UFN_RECURRINGGIFT_GETMISSINGINSTALLMENTS_BULK() as MISSINGINSTALLMENTS
        left join dbo.REVENUE on MISSINGINSTALLMENTS.REVENUEID = REVENUE.ID
    )