Operation Details
Description: Method to read the template milestone details.
Sterotype: ns
SQL 
SELECT
  MilestoneConfiguration.type,
  MilestoneConfiguration.name,
  MilestoneConfiguration.nameTextID,
  PlanTemplateMilestone.milestoneConfigurationID,
  PlanTemplateMilestone.planTemplateID,
  PlanTemplateMilestone.planTemplatePlanGroupID,
  PlanTemplateMilestone.planTemplateSubGoalID,
  PlanTemplateMilestone.startAfter,
  PlanTemplateMilestone.duration,
  PlanTemplateMilestone.comments,
  PlanTemplateMilestone.commentsTextID,
  PlanTemplateMilestone.versionNo
INTO
  :milestoneType,
  :milestoneName,
  :milestoneNameTextID,
  :milestoneConfigurationID,
  :planTemplateID,
  :planTemplatePlanGroupID,
  :planTemplateSubGoalID,
  :startAfter,
  :duration,
  :comments,
  :commentsTextID,
  :versionNo
FROM
  MilestoneConfiguration,
  PlanTemplateMilestone 
WHERE PlanTemplateMilestone.planTemplateMilestoneID = :planTemplateMilestoneID 
  AND MilestoneConfiguration.milestoneConfigurationID = PlanTemplateMilestone.milestoneConfigurationID