Operation Details
Description: Searches for planItems associated with a sub goal.
Sterotype: nsmulti
SQL 
SELECT
  PlanItem.planItemID,
  PlanItem.name,
  PlanItem.typeCode,
  PlanItem.dateCreated
INTO
  :planItemID,
  :name,
  :typeCode,
  :dateCreated 
FROM
  SubGoalPlanItemLink,
  PlanItem 
WHERE SubGoalPlanItemLink.subGoalID = :subGoalID 
  AND PlanItem.planItemID = SubGoalPlanItemLink.planItemID