Operation Details
Description: Method for retrieving Participants List for a planned Item given plannedItemID.
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT cr.concernRoleID,
  cr.concernRoleName,
  cpr.caseParticipantRoleID,
  cpr.caseID,
  cpr.typeCode,
  cpr.recordStatus
INTO
  :concernRoleID,
  :concernRoleName,
  :caseParticipantRoleID,
  :caseID,
  :typeCode,
  :recordStatus 
FROM
  CaseParticipantRole cpr,
  ConcernRole cr,
  PlannedItem pi,
  PlannedSubGoal psg,
  PlannedGoal pg 
WHERE pi.plannedItemID = :plannedItemID 
  AND pi.plannedSubGoalID = psg.plannedSubGoalID 
  AND psg.plannedGoalID = pg.plannedGoalID 
  AND pg.caseID = cpr.caseID 
  AND cpr.participantRoleID = cr.concernRoleID 
ORDER BY cr.concernRoleName