UFN_RECURRINGGIFTINSTALLMENT_GETWRITEOFFINSTALLMENTS

CREATE function dbo.UFN_RECURRINGGIFTINSTALLMENT_GETWRITEOFFINSTALLMENTS(@REVENUEID uniqueidentifier)
returns table            
as            
return (
    select 
        ID,
        DATE,
        TRANSACTIONAMOUNT as AMOUNT,
        BALANCE = dbo.UFN_RECURRINGGIFTINSTALLMENT_GETINSTALLMENTBALANCE(ID),
        WRITEOFFAMOUNT = cast(0.0 as money),
        STATUSCODE
    from 
        dbo.RECURRINGGIFTINSTALLMENT 
    where 
        REVENUEID = @REVENUEID
        and dbo.UFN_RECURRINGGIFTINSTALLMENT_GETINSTALLMENTBALANCE(ID) > 0
    union all
    select
        null,
        I.DATE,
        REVENUE.TRANSACTIONAMOUNT as AMOUNT,
        REVENUE.TRANSACTIONAMOUNT as AMOUNT,
        WRITEOFFAMOUNT = cast(0.0 as money),
        0 STATUSCODE
    from dbo.UFN_RECURRINGGIFT_GETMISSINGINSTALLMENTS(@REVENUEID) I
    inner join dbo.REVENUE on REVENUE.ID = @REVENUEID
    )