SELECT
  pi.plannedItemID,
  pi.name
INTO
  :plannedItemID,
  :name 
FROM
  PlannedItem pi,
  PlannedSubGoal psg,
  PlannedGoal pg 
WHERE 
  (
    concerningID = :concernRoleID 
    OR responsibilityID = :concernRoleID 
  ) 
  AND pg.caseID = :caseID 
  AND psg.plannedGoalID = pg.plannedGoalID 
  AND pi.plannedSubGoalID = psg.plannedSubGoalID