SELECT
PlanTemplatePlanItem.outcomeRequiredInd,
PlanTemplatePlanItem.versionNo,
PlanTemplatePlanItem.planTemplateSubGoalID,
PlanTemplatePlanItem.startDay,
PlanTemplatePlanItem.duration,
PlanItem.name,
Outcome.name,
PlanTemplatePlanItem.description,
PlanTemplatePlanItem.authorizedUnits,
PlanTemplatePlanItem.maximumUnits,
PlanTemplatePlanItem.expectedOutcomeID,
PlanTemplatePlanItem.planItemID
INTO
:outcomeRequiredInd,
:versionNo,
:planTemplateSubGoalID,
:startDay,
:duration,
:name,
:expectedOutcomeName,
:description,
:authorizedUnits,
:maximumUnits,
:expectedOutcomeID,
:planItemID
FROM
PlanTemplatePlanItem,
PlanItem,
Outcome
WHERE PlanTemplatePlanItem.planTemplatePlanItemID = :planTemplatePlanItemID
AND PlanItem.planItemID = PlanTemplatePlanItem.planItemID
AND Outcome.outcomeID = PlanTemplatePlanItem.expectedOutcomeID
|