UFN_MEMBERSHIPRG_INSTALLMENTSPLITSBALANCE

            create function dbo.UFN_MEMBERSHIPRG_INSTALLMENTSPLITSBALANCE
            (
                @REVENUEID uniqueidentifier
            )
            returns bit
            with execute as caller
            as 
            begin
                declare @r as int;

                select @r = count(*) 
                    from 
                        (select sum(FINANCIALTRANSACTIONLINEITEM.TRANSACTIONAMOUNT) AMOUNT, FINANCIALTRANSACTIONLINEITEM.ID as REVENUESPLITID
                        from FINANCIALTRANSACTIONLINEITEM
                        inner join REVENUESPLIT_EXT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLIT_EXT.ID
                        where FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = @REVENUEID
                            and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null
                            and FINANCIALTRANSACTIONLINEITEM.TYPECODE <> 1
                        group by FINANCIALTRANSACTIONLINEITEM.ID) a
                    full join 
                        (select sum(INSTALLMENTSPLIT.TRANSACTIONAMOUNT) AMOUNT, INSTALLMENTSPLIT.REVENUESPLITID
                        from INSTALLMENTSPLIT
                        where INSTALLMENTSPLIT.PLEDGEID = @REVENUEID
                        group by INSTALLMENTSPLIT.REVENUESPLITID) b
                            on a.REVENUESPLITID = b.REVENUESPLITID
                    where coalesce(a.AMOUNT, 0.00) <> coalesce(b.AMOUNT, 0.00)

                if @r = 0 --No others

                    return 1

                return 0
            end