Operation Details
Description: Lists all service plan delivery participants.
Sterotype: nsmulti
SQL 
SELECT
  CaseParticipantRole.caseParticipantRoleID,
  CaseParticipantRole.participantRoleID,
  CaseParticipantRole.fromDate,
  CaseParticipantRole.toDate,
  CaseParticipantRole.typeCode,
  CaseParticipantRole.recordStatus,
  ConcernRole.concernRoleName,
  CaseParticipantRole.versionNo
INTO
  :caseParticipantRoleID,
  :participantRoleID,
  :fromDate,
  :toDate,
  :typeCode,
  :recordStatus,
  :fullName, 
  :versionNo
FROM
  CaseParticipantRole,
  ConcernRole 
WHERE CaseParticipantRole.caseID = :caseID 
  AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID