Operation Details
Description: Searches for planItems associated with a sub goal, returns the planItemID, planItemName, planItemTypeCode and the description.
Sterotype: nsmulti
SQL 
SELECT
  PlanItem.planItemID,
  PlanItem.name,
  PlanItem.typeCode,
  PlanItem.description,
  PlanItem.descriptionTextID
INTO
  :planItemID,
  :planItemName,
  :typeCode,
  :description,
  :descriptionTextID 
FROM
  SubGoalPlanItemLink,
  PlanItem 
WHERE SubGoalPlanItemLink.subGoalID = :subGoalID 
  AND PlanItem.planItemID = SubGoalPlanItemLink.planItemID