SELECT
  hearingID
INTO
  :hearingID 
FROM
  Appeal,
  Hearing 
WHERE appealID = :appealID 
  AND statusCode = :statusCode 
  AND Appeal.caseID = Hearing.caseID