Operation Details
Description: Method to get a list of In Progress or Completed planItems for a Plan Participant.
Sterotype: nsmulti
SQL 
SELECT
  plannedItemID,
  name
INTO
  :plannedItemID,
  :name 
FROM
  CaseHeader,
  PlannedItem,
  PlannedSubGoal,
  PlannedGoal 
WHERE 
  (
    PlannedItem.plannedSubGoalID = PlannedSubGoal.plannedSubGoalID 
  ) 
  AND 
  (
    PlannedSubGoal.plannedGoalID = PlannedGoal.plannedGoalID 
  ) 
  AND 
  (
    PlannedGoal.caseID = :caseID 
  ) 
  AND 
  (
    CaseHeader.caseID = PlannedGoal.caseID 
  ) 
  AND 
  (
    PlannedItem.responsibilityID = CaseHeader.concernRoleID 
  ) 
  AND 
  (
    
    (
      PlannedItem.responsibilityType = :responsibilityType1 
    ) 
    OR 
    (
      PlannedItem.responsibilityType = :responsibilityType2 
    ) 
  ) 
  AND 
  (
    
    (
      PlannedItem.status = :status1 
    ) 
    OR 
    (
      PlannedItem.status = :status2 
    ) 
  )