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