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