Operation Details
Description: Reads planned item comparison details by case ID and sensitivity.
Sterotype: nsmulti
SQL 
SELECT
  PlannedItem.plannedItemID,
  PlanItem.name,
  PlanItem.typeCode,
  PlannedItem.expectedStartDate,
  PlannedItem.expectedEndDate
INTO
  :plannedItemID,
  :name,
  :typeCode,
  :expectedStartDate,
  :expectedEndDate 
FROM
  PlannedGoal,
  PlannedSubGoal,
  PlannedItem,
  PlanItem 
WHERE PlannedGoal.caseID = :caseID 
  AND PlannedSubGoal.plannedGoalID = PlannedGoal.plannedGoalID 
  AND PlannedItem.plannedSubGoalID = PlannedSubGoal.plannedSubGoalID 
  AND PlannedItem.sensitivityCode <= :sensitivityCode 
  AND PlanItem.planItemID = PlannedItem.planItemID