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
|