Operation Details
Description: Lists the Particiapant Hearing Officials for a Hearing.
Sterotype: nsmulti
SQL 
SELECT DISTINCT
  ConcernRole.concernRoleName,
  ConcernRole.concernRoleID,
  ConcernRole.concernRoleType

INTO
:concernRoleName,
:concernRoleID,
:concernRoleType

FROM
  HearingParticipation,
  CaseParticipantRole,
  ConcernRole 
  
WHERE 
HearingParticipation.hearingID = :hearingID AND 
CaseParticipantRole.recordStatus = :normalRecordStatus AND 
HearingParticipation.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID AND 
CaseParticipantRole.participantRoleID = ConcernRole.concernRoleID AND
CaseParticipantRole.typeCode = :hearingOfficialRoleType