Operation Details
Description: Method to return a list of milestones added at the template level.
Sterotype: nsmulti
SQL 
SELECT
 PlanTemplateMilestone.planTemplateMilestoneID, 
 MilestoneConfiguration.name,
 PlanTemplateMilestone.planTemplateID,
 PlanTemplateMilestone.planTemplatePlanGroupID,
 PlanTemplateMilestone.planTemplateSubGoalID
INTO
 :planTemplateMilestoneID, 
 :name,
 :planTemplateID,
 :planTemplatePlanGroupID,
 :planTemplateSubGoalID
FROM 
 PlanTemplateMilestone, 
 MilestoneConfiguration
WHERE PlanTemplateMilestone.planTemplateID = :planTemplateID
AND PlanTemplateMilestone.planTemplatePlanGroupID is null
AND PlanTemplateMilestone.planTemplateSubGoalID is null
AND PlanTemplateMilestone.milestoneConfigurationID = MilestoneConfiguration.milestoneConfigurationID
ORDER BY PlanTemplateMilestone.LastWritten