Operation Details
Description: Lists all plan template planItems assigned to a plan template sub goal.
Sterotype: nsmulti
SQL 
SELECT
  PlanTemplatePlanItem.planTemplatePlanItemID,
  PlanItem.name,
  PlanTemplatePlanItem.startDay,
  PlanTemplatePlanItem.duration
INTO
  :planTemplatePlanItemID,
  :name,
  :startDay,
  :duration 
FROM
  PlanItem,
  PlanTemplatePlanItem 
WHERE PlanTemplatePlanItem.planTemplateSubGoalID = :planTemplateSubGoalID 
  AND PlanItem.planItemID = PlanTemplatePlanItem.planItemID 
ORDER BY PlanTemplatePlanItem.LastWritten