USP_DATALIST_REVENUEBATCHDEFAULTAPPEAL

create procedure dbo.USP_DATALIST_REVENUEBATCHDEFAULTAPPEAL
(
    @COMMITMENTID uniqueidentifier
)
as
  set nocount on

  select APPEALID  from REVENUE_EXT where ID = @COMMITMENTID
  union 
  select EA.APPEALID from [EVENT] E
    inner join REGISTRANT R on R.EVENTID = E.ID
    inner join EVENTAPPEAL EA on ea.EVENTID = E.ID
    where R.ID = @COMMITMENTID