UFN_CONSTITUENT_GETPLEDGEBALANCE

            CREATE function dbo.UFN_CONSTITUENT_GETPLEDGEBALANCE(@CONSTITUENTID uniqueidentifier) 
            returns money
            with execute as caller
            as begin
                declare @RESULT money;

                select 
                    @RESULT = coalesce(sum(dbo.UFN_PLEDGE_GETBALANCE(REVENUE.ID)), 0)
                from dbo.REVENUE                
                where REVENUE.TRANSACTIONTYPECODE = 1 and REVENUE.CONSTITUENTID = @CONSTITUENTID;

                return @RESULT;
            end