Operation Details
Description: Returns a list of planned items for a specified subgoal whose sensitivity is less than the users sensitivity,
Sterotype: nsmulti
SQL 
SELECT
  PlannedItem.plannedItemID,
  PlannedItem.name,
  PlanItem.typeCode,
  PlannedItem.expectedStartDate,
  PlannedItem.expectedEndDate,
  PlannedItem.actualStartDate,
  PlannedItem.actualEndDate,
  PlannedItem.authorizedUnits
INTO
  :plannedItemID,
  :name,
  :typeCode,
  :expectedStartDate,
  :expectedEndDate,
  :actualStartDate,
  :actualEndDate,
  :authorizedUnits 
FROM
  PlannedItem,
  PlanItem 
WHERE PlannedItem.plannedSubGoalID = :plannedSubGoalID 
  AND PlannedItem.sensitivityCode <= :sensitivityCode 
  AND PlanItem.planItemID = PlannedItem.planItemID