SELECT
  Outcome.outcomeID,
  Outcome.name,
  Outcome.dateCreated
INTO
  :outcomeID,
  :name,
  :dateCreated 
FROM
  PlanItemOutcomeLink,
  Outcome 
WHERE PlanItemOutcomeLink.planItemID = :planItemID 
  AND Outcome.outcomeID = PlanItemOutcomeLink.outcomeID