Operation Details
Description: Provides the count of legal participants whose status is notHeld for a hearing
Sterotype: ns
SQL 
SELECT
  COUNT(hearingParticipationID)
INTO
  :numberOfRecords 
FROM
  HearingParticipation,
  CaseParticipantRole 
WHERE HearingParticipation.hearingID = :hearingID 
  AND HearingParticipation.participatedCode = :participatedCode 
  AND HearingParticipation.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID 
  AND CaseParticipantRole.recordStatus = :recordStatus