Operation Details
Description: Returns the list of 'active' participants, including their display names, for the caseID and typeCode provided.
Sterotype: nsmulti
SQL 
SELECT
  CaseParticipantRole.caseParticipantRoleID,
  CaseParticipantRole.participantRoleID,
  ConcernRole.concernRoleName
INTO
  :caseParticipantRoleID,
  :participantRoleID,
  :concernRoleName 
FROM
  CaseParticipantRole,
  ConcernRole 
WHERE CaseParticipantRole.participantRoleID = ConcernRole.concernRoleID 
  AND CaseParticipantRole.caseID = :caseID 
  AND CaseParticipantRole.typeCode = :typeCode 
  AND CaseParticipantRole.recordStatus = :recordStatus