SELECT
  Outcome.outcomeID,
  Outcome.name
INTO
  :outcomeID,
  :name 
FROM
  ProductDeliveryPlanItemLink,
  PlannedItem,
  PlanItem,
  PlanItemOutcomeLink,
  Outcome 
WHERE ProductDeliveryPlanItemLink.caseID = :caseID 
  AND PlannedItem.plannedItemID = ProductDeliveryPlanItemLink.plannedItemID 
  AND PlanItem.planItemID = PlannedItem.planItemID 
  AND PlanItemOutcomeLink.planItemID = PlanItem.planItemID 
  AND Outcome.outcomeID = PlanItemOutcomeLink.outcomeID