Operation Details
Description: Reads the status and caseParticipantRoleID of the hearing representative.
Sterotype: ns
SQL 
SELECT
  CaseParticipantRole.recordStatus,
  CaseParticipantRole.caseParticipantRoleID
INTO
  :recordStatus,
  :caseParticipantRoleID 
FROM
  HearingRepresentative,
  CaseParticipantRole 
WHERE HearingRepresentative.hearingRepresentativeID = :hearingRepresentativeID 
  AND HearingRepresentative.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID