Database SQL Operation: PlanTemplateMilestone.searchServicePlanLevelMilestones
| Description: | Method to return template milestones configured at service plan level. |
| Sterotype: | nsmulti |
SELECT
PlanTemplateMilestone.milestoneConfigurationID,
PlanTemplateMilestone.startAfter,
PlanTemplateMilestone.duration
INTO
:milestoneConfigurationID,
:startAfter,
:duration
FROM
PlanTemplateMilestone
WHERE PlanTemplateMilestone.planTemplateID = :planTemplateID
AND PlanTemplateMilestone.planTemplatePlanGroupID is null
AND PlanTemplateMilestone.planTemplateSubGoalID is null
ORDER BY
lastWritten
|
