Operation Details
Description: Method to return a list of milestones created at sub goal 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.planTemplateSubGoalID = :planTemplateSubGoalID
AND PlanTemplateMilestone.milestoneConfigurationID = MilestoneConfiguration.milestoneConfigurationID
ORDER BY PlanTemplateMilestone.LastWritten