Operation Details
Description: Lists all plan template approval criteria assigned to a plan template plan item.
Sterotype: nsmulti
SQL 
SELECT
  ac.criteriaName,
  ptpiac.planTemplatePlanItemApprCritID
INTO
  :name,
  :planTemplatePlanItemApprCritID 
FROM
  ApprovalCriteria ac,
  PlanItemApprovalCriteriaLink piacl,
  PlanTemplatePlanItemApprCrit ptpiac 
WHERE ac.approvalCriteriaID = piacl.approvalCriteriaID 
  AND piacl.planItemApprovalCriteriaLinkID = ptpiac.planItemApprovalCriteriaLinkID 
  AND ptpiac.planTemplatePlanItemID = :planTemplatePlanItemID 
ORDER BY ptpiac.occursWhen,
  ptpiac.priority