Operation Details
Description: Returns the details of all the hearing representative for a given hearing case, including the name, which is stored in the concernRole table.
Sterotype: nsmulti
SQL 
SELECT
  HearingRepresentative.hearingRepresentativeID,
  HearingRepresentative.hearingID,
  HearingRepresentative.typeCode,
  CaseParticipantRole.recordStatus,
  HearingRepresentative.feeAmount,
  HearingRepresentative.feeApprovedCode,
  HearingRepresentative.participatedCode,
  HearingRepresentative.behalfOfCode,
  ConcernRole.concernRoleName,
  HearingRepresentative.caseParticipantRoleID
INTO
  :hearingRepresentativeID,
  :hearingID,
  :typeCode,
  :recordStatus,
  :feeAmount,
  :feeApprovedCode,
  :participatedCode,
  :behalfOfCode,
  :name,
  :caseParticipantRoleID 
FROM
  HearingRepresentative,
  CaseParticipantRole,
  ConcernRole 
WHERE HearingRepresentative.hearingID = :hearingID 
  AND HearingRepresentative.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID 
  AND CaseParticipantRole.participantRoleID = ConcernRole.concernRoleID