SELECT
  count(appellant.appealid)
INTO
  :numOfRecords 
FROM
  appeal,
  appellant,
  caseheader 
WHERE appeal.appealid = appellant.appealid 
  AND appeal.caseid = caseheader.caseid 
  AND caseheader.casereference = :caseReference