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