UFN_RECURRINGGIFTINSTALLMENT_GETINSTALLMENTBALANCE

            CREATE function dbo.UFN_RECURRINGGIFTINSTALLMENT_GETINSTALLMENTBALANCE
            (
                @INSTALLMENTID uniqueidentifier
            ) 
            returns money
            with execute as caller
            as begin
                declare @BALANCE money;

                select @BALANCE = INSTALLMENT.BALANCE
                from dbo.UFN_RECURRINGGIFTINSTALLMENT_GETINSTALLMENTBALANCE_BY_RECURRINGGIFTINSTALLMENTID(@INSTALLMENTID) as INSTALLMENT
                where INSTALLMENT.ID = @INSTALLMENTID;

                return @BALANCE;
            end