UFN_EVENTSPONSOR_GETBALANCE

create function dbo.UFN_EVENTSPONSOR_GETBALANCE
(
  @EVENTSPONSORID uniqueidentifier
)
returns money
as begin
  declare @BALANCE money

    select @BALANCE = (EST.FEESAMOUNT - RS.TRANSACTIONAMOUNT) from dbo.EVENTSPONSOR ES
  join dbo.EVENTSPONSORSHIPTYPE EST on ES.EVENTSPONSORSHIPTYPEID = EST.ID
  join dbo.[EVENT] E on ES.EVENTID = E.ID
  left join REVENUE R on ISNULL(ES.ORGANIZATIONCONSTITUENTID, ES.CONSTITUENTID) = R.CONSTITUENTID and R.APPEALID = E.APPEALID
  left join REVENUESPLIT RS ON R.ID = RS.REVENUEID AND RS.APPLICATIONCODE = 15
  where ES.ID = @EVENTSPONSORID

  return @BALANCE

end