SELECT
  plannedItemID,
  name
INTO
  :plannedItemID,
  :name 
FROM
  CaseHeader,
  PlannedItem,
  PlannedSubGoal,
  PlannedGoal 
WHERE 
  (
    PlannedItem.plannedSubGoalID = PlannedSubGoal.plannedSubGoalID 
  ) 
  AND 
  (
    PlannedSubGoal.plannedGoalID = PlannedGoal.plannedGoalID 
  ) 
  AND 
  (
    PlannedGoal.caseID = :caseID 
  ) 
  AND 
  (
    CaseHeader.caseID = PlannedGoal.caseID 
  )