spLoadRecord_EmailProjectAppeal_EmailList

    CREATE PROCEDURE dbo.spLoadRecord_EmailProjectAppeal_EmailList
@PKID int

as

DECLARE @ListID int

SELECT [ID]
      ,[EmailProjectAppealID]
      ,[EmailListID]
      ,[AppealListType]
  FROM [dbo].EmailProjectAppeal_EmailList
  WHERE [ID] = @PKID

SET @ListID = (SELECT [EmailListID] FROM EmailProjectAppeal_EmailList WHERE [ID] = @PKID)

exec [spLoadRecord_EmailList] @ListID