Operation Details
Description: Returns all Case Participant Roles that match the caseID.
Sterotype: nsmulti
SQL 
SELECT
  caseParticipantRoleID,
  participantRoleID,
  caseID,
  fromDate,
  toDate,
  endReason,
  typeCode,
  recordStatus,
  translationRequiredInd,
  comments
INTO
  :caseParticipantRoleID,
  :participantRoleID,
  :caseID,
  :fromDate,
  :toDate,
  :endReason,
  :typeCode,
  :recordStatus,
  :translationRequiredInd,
  :comments 
FROM
  CaseParticipantRole 
WHERE caseID = :caseID 
ORDER BY fromDate DESC,
  toDate DESC