Operation Details
Description: Retrieves a list the IDs of participantRole, concernRole and HearingRepresentative for a given hearing ID.
Sterotype: nsmulti
SQL 
SELECT
  HearingRepresentative.hearingRepresentativeID,
  HearingRepresentative.caseParticipantRoleID,
  CaseParticipantRole.participantRoleID,
  HearingRepresentative.versionNo
INTO
  :hearingRepresentativeID,
  :caseParticipantRoleID,
  :participantRoleID,
  :versionNo 
FROM
  HearingRepresentative,
  CaseParticipantRole 
WHERE HearingRepresentative.hearingID = :hearingID 
  AND CaseParticipantRole.recordStatus = :recordStatus 
  AND HearingRepresentative.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID