Operation Details
Description: Returns active Case Participant Roles that match the caseID.
Sterotype: nsmulti
SQL 
SELECT
  CaseParticipantRole.typeCode,
  ConcernRole.concernRoleName
INTO
  :typeCode,
  :concernRoleName
FROM
  CaseParticipantRole,
  ConcernRole
WHERE CaseParticipantRole.caseID = :caseID
  AND CaseParticipantRole.recordStatus = :recordStatus
  AND CaseParticipantRole.participantRoleID = ConcernRole.concernRoleID