Operation Details
Description: @deprecated since Curam v6, replaced with {@link searchPlanItemByPlanTemplateSubGoalID}.The new method reads plan template plan item and plan item details for all PlanTemplateAndPlanItem records created for the PlanTemplateSubGoal along with mandatory and approval indicators..
Sterotype: nsmulti
SQL
SELECT
  PlanTemplatePlanItem.planItemID,
  PlanTemplatePlanItem.expectedOutcomeID,
  PlanTemplatePlanItem.startDay,
  PlanTemplatePlanItem.duration,
  PlanItem.sensitivityCode,
  PlanItem.cost,
  PlanTemplatePlanItem.authorizedUnits,
  PlanTemplatePlanItem.maximumUnits
INTO
  :planItemID,
  :expectedOutcomeID,
  :startDay,
  :duration,
  :sensitivityCode,
  :cost,
  :authorizedUnits,
  :maximumUnits
FROM
  PlanTemplatePlanItem,
  PlanItem 
WHERE PlanTemplatePlanItem.planTemplateSubGoalID = :planTemplateSubGoalID 
  AND PlanItem.planItemID = PlanTemplatePlanItem.planItemID