Database SQL Operation: SubGoal.searchPlanItemsForSubGoal
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 |
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
|