SELECT
  count(*)
INTO
  :numberOfRecords 
FROM
  AppealRelationship,
  CaseHeader 
WHERE AppealRelationship.appealCaseID = :appealCaseID 
  AND AppealRelationship.caseID =CaseHeader.caseID 
  AND caseTypeCode = :caseTypeCode 
  AND AppealRelationship.recordStatus = :recordStatus