Operation Details
Description: Returns a list of case participant roles by case ID, role type and status.
Sterotype: nsmulti
SQL 
SELECT
  caseParticipantRoleID,
  participantRoleID,
  concernRoleName
INTO
  :caseParticipantRoleID,
  :participantRoleID,
  :concernRoleName 
FROM
  CaseParticipantRole CPR,
  ConcernRole CR 
WHERE CPR.caseID = :caseID 
  AND CPR.typeCode = :typeCode 
  AND CPR.recordStatus = :recordStatus 
  AND CPR.participantRoleID = CR.concernRoleID