UFN_REGISTRANT_GETSELFPLEDGEBALANCE

create function dbo.UFN_REGISTRANT_GETSELFPLEDGEBALANCE(@ID uniqueidentifier)
returns money
with execute as caller
as begin
    declare @BALANCE money = 0;
    declare @EVENTID uniqueidentifier;
  declare @CONSTITUENTID uniqueidentifier;

    select @EVENTID = EVENTID, @CONSTITUENTID = CONSTITUENTID from REGISTRANT(nolock) where ID = @ID;

    select @BALANCE = isnull((sum(ER.[ORIGINAL AMOUNT]) - sum(ER.[APPLIED AMOUNT])), 0)
    from UFN_REVENUE_EVENT(@EVENTID) as ER  
    inner join REVENUERECOGNITION RR(nolock)
    on RR.REVENUESPLITID = ER.REVENUESPLITID
    where ER.CONSTITUENTID = @CONSTITUENTID and RR.CONSTITUENTID = @CONSTITUENTID;

    -- do work here and return a value

    return @BALANCE;
end