SELECT
  PlannedGroup.plannedGroupID,
  parentGroupID,
  PlannedGroup.name,
  PlannedSubGoal.plannedSubGoalID,
  SubGoal.name,
  PlannedSubGoal.status,
  PlannedSubGoal.sensitivityCode,
  PlannedSubGoal.plannedGroupID,
  PlannedItem.plannedItemID,
  PlannedItem.name,
  PlannedItem.status,
  PlannedItem.sensitivityCode,
  PlannedItem.estimatedCost,
  PlannedItem.actualCost
INTO
  :plannedGroupID,
  :parentGroupID,
  :plannedGroupName,
  :plannedSubGoalID,
  :subGoalName,
  :plannedSubGoalStatus,
  :plannedSubGoalSensitivity,
  :plannedSubGoalPlannedGroupID,
  :plannedItemID,
  :plannedItemName,
  :plannedItemStatus,
  :plannedItemSensitivity,
  :plannedItemEstimatedCost,
  :plannedItemActualCost 
FROM
  PlannedGoal,
  PlannedGroup 
  
  FULL OUTER JOIN
  
  PlannedSubGoal 
  ON ( (PlannedGroup.plannedGoalID = PlannedSubGoal.plannedGoalID) 
  AND 
  (
    PlannedSubGoal.plannedGroupID = PlannedGroup.plannedGroupID 
  )) 
  
  LEFT OUTER JOIN
  
  SubGoal 
  ON SubGoal.subGoalID = PlannedSubGoal.subGoalID 
  
  LEFT OUTER JOIN
  
  PlannedItem 
  ON PlannedSubGoal.plannedSubGoalID = PlannedItem.plannedSubGoalID 
WHERE 
  (
    PlannedGoal.caseID = :caseID 
  ) 
  AND 
  (
    PlannedGoal.plannedGoalID = PlannedGroup.plannedGoalID 
  ) 
ORDER BY PlannedGroup.plannedGroupID,
  plannedSubGoalID,
  plannedItemID