Operation Details
Description: Reads the plan item details for a contract by planned sub goal id.
Sterotype: nsmulti
SQL 
SELECT
  PlannedItem.name,
  PlannedItem.expectedStartDate,
  PlannedItem.expectedEndDate,
  PlannedItem.actualStartDate,
  PlannedItem.actualEndDate,
  PlannedItem.comments,
  PlannedItem.authorizedUnits,
  PlannedItem.totalUnitsAuthorized,
  PlannedItem.rateAuthorized,
  PlannedItem.frequency
INTO
  :plannedItemName,
  :plannedItemExpectedStartDate,
  :plannedItemExpectedEndDate,
  :plannedItemActualStartDate,
  :plannedItemActualEndDate,
  :comments,
  :authorizedUnits,
  :totalUnitsAuthorized,
  :rateAuthorized,
  :frequency 
FROM
  PlannedItem 
WHERE PlannedItem.plannedSubGoalID = :plannedSubGoalID