Operation Details
Description: Returns the name and participant details for the active interpreters for a hearing.
Sterotype: nsmulti
SQL 
SELECT
  HearingServiceSupplier.hearingServiceSupplierID,
  CaseParticipantRole.caseParticipantRoleID,
  CaseParticipantRole.participantRoleID,
  HearingServiceSupplier.versionNo,
  ConcernRole.concernRoleName,
  HearingServiceSupplier.participatedCode
INTO
  :hearingServiceSupplierID,
  :caseParticipantRoleID,
  :participantRoleID,
  :versionNo,
  :fullName,
  :participatedCode 
FROM
  HearingServiceSupplier,
  CaseParticipantRole,
  ConcernRole 
WHERE HearingServiceSupplier.supplierLinkID = CaseParticipantRole.caseParticipantRoleID 
  AND CaseParticipantRole.participantRoleID = ConcernRole.concernRoleID 
  AND HearingServiceSupplier.hearingID = :hearingID 
  AND CaseParticipantRole.recordStatus = :recordStatus 
  AND CaseParticipantRole.typeCode = :typeCode