Operation Details
Description: This methods retrieves the appellants for a particular hearing.
Sterotype: ns
SQL 
SELECT
  count(*)
INTO
  :numberOfRecords 
FROM
  HearingParticipation,
  Appellant 
WHERE Appellant.caseParticipantRoleID IN 
  ( 
  SELECT
    caseParticipantRoleID 
  FROM
    HearingParticipation 
  ) 
  AND Appellant.caseParticipantRoleID = :caseParticipantRoleID 
  AND Appellant.caseParticipantRoleID = HearingParticipation.caseParticipantRoleID 
  AND HearingParticipation.hearingID = :hearingID