Operation Details
Description: Reads details about the hearing representative.
Sterotype: ns
SQL 
SELECT
  HearingRepresentative.hearingRepresentativeID,
  HearingRepresentative.hearingID,
  HearingRepresentative.typeCode,
  HearingRepresentative.feeAmount,
  HearingRepresentative.feeApprovedCode,
  HearingRepresentative.participatedCode,
  HearingRepresentative.behalfOfCode,
  HearingRepresentative.comments,
  HearingRepresentative.versionNo,
  ConcernRole.concernRoleName,
  HearingRepresentative.caseParticipantRoleID,
  CaseParticipantRole.versionNo,
  CaseParticipantRole.recordStatus
INTO
  :hearingRepresentativeID,
  :hearingID,
  :typeCode,
  :feeAmount,
  :feeApprovedCode,
  :participatedCode,
  :behalfOfCode,
  :comments,
  :versionNo,
  :name,
  :caseParticipantRoleID,
  :caseParticipantRoleVersionNo,
  :recordStatusCode 
FROM
  HearingRepresentative,
  CaseParticipantRole,
  ConcernRole 
WHERE HearingRepresentative.hearingRepresentativeID = :hearingRepresentativeID 
  AND HearingRepresentative.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID 
  AND CaseParticipantRole.participantRoleID = ConcernRole.concernRoleID