Operation Details
Description: @deprecated since curam 6.0, replace by {@Link SubGoal#searchPlanItemsForSubGoal1()}. See release note : CR00247170 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
INTO
  :planItemID,
  :planItemName,
  :typeCode,
  :description 
FROM
  SubGoalPlanItemLink,
  PlanItem 
WHERE SubGoalPlanItemLink.subGoalID = :subGoalID 
  AND PlanItem.planItemID = SubGoalPlanItemLink.planItemID