SELECT
  PlanItem.planItemID,
  PlanItem.name
INTO
  :planItemID,
  :name 
FROM
  PlanTemplateSubGoal,
  SubGoalPlanItemLink,
  PlanItem 
WHERE PlanTemplateSubGoal.planTemplateSubGoalID = :planTemplateSubGoalID 
  AND PlanTemplateSubGoal.subGoalID = SubGoalPlanItemLink.subGoalID 
  AND SubGoalPlanItemLink.planItemID = PlanItem.planItemID 
  AND PlanItem.recordStatus = :recordStatus 
  AND PlanItem.planItemID NOT in 
  ( 
  SELECT
    planItemID 
  FROM
    PlanTemplatePlanItem 
  WHERE planTemplateSubGoalID = :planTemplateSubGoalID 
    AND planItemID NOT in 
    ( 
    SELECT
      planItemID 
    FROM
      PlanTemplatePlanItem 
    WHERE planItemID = :planItemID 
    ) 
  )