UFN_PLEDGEPAYMENT_DESIGNATIONSBALANCE

            CREATE function dbo.UFN_PLEDGEPAYMENT_DESIGNATIONSBALANCE
            (
                @PLEDGEID uniqueidentifier
            )
            returns bit
            with execute as caller
            as 
            begin
                declare @r as int;

                select @r = count(*)
                from dbo.FINANCIALTRANSACTIONLINEITEM
                inner join dbo.REVENUESPLIT_EXT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLIT_EXT.ID
                where FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = @PLEDGEID and dbo.UFN_PLEDGE_GETSPLITBALANCE(FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID, REVENUESPLIT_EXT.ID) < 0
                    and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null
                    and FINANCIALTRANSACTIONLINEITEM.TYPECODE <> 1

                if @r = 0 -- no overpayments exist

                    return 1

                return 0
            end