SELECT
  CaseHeader.caseID
INTO
  :caseID 
FROM
  CaseHeader,
  AppealRelationship 
WHERE appealCaseID = :appealCaseID 
  AND caseTypeCode = :caseTypeCode 
  AND AppealRelationship.caseID =CaseHeader.caseID