SELECT
  appellantID
INTO
  :appellantID 
FROM
  Appellant,
  Appeal,
  Hearing 
WHERE hearingID = :hearingID 
  AND Hearing.caseID = Appeal.caseID 
  AND Appellant.appealID = Appeal.appealID 
  AND Appellant.toDate IS NULL