UFN_PLEDGE_PAYMENTSVALID

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

                select @r = count(*) 
                from dbo.INSTALLMENTSPLITPAYMENT
                inner join dbo.INSTALLMENTSPLIT
                    on INSTALLMENTSPLITPAYMENT.INSTALLMENTSPLITID = INSTALLMENTSPLIT.ID
                inner join dbo.FINANCIALTRANSACTIONLINEITEM
                    on INSTALLMENTSPLITPAYMENT.PAYMENTID = FINANCIALTRANSACTIONLINEITEM.ID
                inner join dbo.REVENUESPLIT_EXT
                    on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLIT_EXT.ID
                where INSTALLMENTSPLITPAYMENT.PLEDGEID = @PLEDGEID and 
                    (INSTALLMENTSPLIT.DESIGNATIONID <> REVENUESPLIT_EXT.DESIGNATIONID
                        or INSTALLMENTSPLIT.DESIGNATIONID is null and REVENUESPLIT_EXT.DESIGNATIONID is not null
                        or INSTALLMENTSPLIT.DESIGNATIONID is not null and REVENUESPLIT_EXT.DESIGNATIONID is null)
                    and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null
                    and FINANCIALTRANSACTIONLINEITEM.TYPECODE <> 1

                if @r = 0 --No others

                    return 1

                return 0
            end