Operation Details
Description: Retrieve a list of caseParticipants of a certain type for a given case and status
Sterotype: nsmulti
SQL 
SELECT
  concernRoleName,
  caseParticipantRoleID,
  primaryAlternateID
INTO
  :name,
  :caseParticipantRoleID,
  :alternateID 
FROM
  ConcernRole,
  CaseParticipantRole 
WHERE CaseParticipantRole.caseID = :caseID 
  AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID 
  AND CaseParticipantRole.typeCode = :typeCode 
  AND CaseParticipantRole.recordStatus = :recordStatus