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