SELECT
MilestoneConfiguration.type,
MilestoneConfiguration.name,
PlanTemplateMilestone.milestoneConfigurationID,
PlanTemplateMilestone.planTemplateID,
PlanTemplateMilestone.planTemplatePlanGroupID,
PlanTemplateMilestone.planTemplateSubGoalID,
PlanTemplateMilestone.startAfter,
PlanTemplateMilestone.duration,
PlanTemplateMilestone.comments,
PlanTemplateMilestone.versionNo
INTO
:milestoneType,
:milestoneName,
:milestoneConfigurationID,
:planTemplateID,
:planTemplatePlanGroupID,
:planTemplateSubGoalID,
:startAfter,
:duration,
:comments,
:versionNo
FROM
MilestoneConfiguration,
PlanTemplateMilestone
WHERE PlanTemplateMilestone.planTemplateMilestoneID = :planTemplateMilestoneID
AND MilestoneConfiguration.milestoneConfigurationID = PlanTemplateMilestone.milestoneConfigurationID
|