Operation Details
Description: Returns the name of each active case participant of the specified type for a hearing.
Sterotype: nsmulti
SQL 
SELECT
  concernRoleName
INTO
  :name 
FROM
  Hearing,
  CaseParticipantRole,
  ConcernRole 
WHERE Hearing.caseID = CaseParticipantRole.caseID 
  AND CaseParticipantRole.participantRoleID = ConcernRole.concernRoleID 
  AND hearingID = :hearingID 
  AND CaseParticipantRole.typeCode = :typeCode 
  AND CaseParticipantRole.recordStatus = :recordStatus