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