Operation Details
Description: Returns the number of active hearing representatives for a specified hearing and participation.
Sterotype: ns
SQL 
SELECT
  COUNT(hearingRepresentativeID)
INTO
  :numberOfRecords 
FROM
  HearingRepresentative,
  CaseParticipantRole 
WHERE HearingRepresentative.hearingID = :hearingID 
  AND HearingRepresentative.participatedCode = :participatedCode 
  AND HearingRepresentative.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID 
  AND CaseParticipantRole.recordStatus = :recordStatus