Operation Details
Description: Method to read the plan template plan item approval criteria details for populating the planned item approval details when planned item is created through template.
Sterotype: nsmulti
SQL 
SELECT
  ApprovalCriteria.criteriaName,
  ApprovalCriteria.workflowEvent,
  PlanTemplatePlanItemApprCrit.priority ,
  PlanTemplatePlanItemApprCrit.occursWhen
INTO
  :criteriaName,
  :eventName,
  :priority,
  :occursWhen 
FROM
  ApprovalCriteria ,
  PlanItemApprovalCriteriaLink ,
  PlanTemplatePlanItemApprCrit 
WHERE ApprovalCriteria.approvalCriteriaID = PlanItemApprovalCriteriaLink.approvalCriteriaID 
  AND PlanItemApprovalCriteriaLink.planItemApprovalCriteriaLinkID = PlanTemplatePlanItemApprCrit.planItemApprovalCriteriaLinkID 
  AND PlanTemplatePlanItemApprCrit.planTemplatePlanItemID = :planTemplatePlanItemID 
ORDER BY PlanTemplatePlanItemApprCrit.occursWhen,
  PlanTemplatePlanItemApprCrit.priority