Operation Details
Description: Return the active hearing representatives and their full names for a hearing.
Sterotype: nsmulti
SQL 
SELECT
  HearingRepresentative.hearingRepresentativeID,
  HearingRepresentative.caseParticipantRoleID,
  CaseParticipantRole.participantRoleID,
  HearingRepresentative.versionNo,
  ConcernRole.concernRoleName,
  HearingRepresentative.participatedCode
INTO
  :hearingRepresentativeID,
  :caseParticipantRoleID,
  :participantRoleID,
  :versionNo,
  :fullName,
  :participatedCode 
FROM
  HearingRepresentative,
  CaseParticipantRole,
  ConcernRole 
WHERE HearingRepresentative.hearingID = :hearingID 
  AND CaseParticipantRole.recordStatus = :recordStatus 
  AND HearingRepresentative.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID 
  AND CaseParticipantRole.participantRoleID = ConcernRole.concernRoleID