Operation Details
Description: Lists all plan template approval criteria not assigned to a plan template plan item.
Sterotype: nsmulti
SQL 
SELECT
  ac.criteriaName,
  piacl.planItemApprovalCriteriaLinkID
INTO
  :name,
  :planItemApprovalCriteriaLinkID 
FROM
  ApprovalCriteria ac,
  PlanItemApprovalCriteriaLink piacl,
  PlanTemplatePlanItem ptpi 
WHERE ac.approvalCriteriaID = piacl.approvalCriteriaID 
  AND ptpi.planItemID = piacl.planItemID 
  AND ptpi.planTemplatePlanItemID = :planTemplatePlanItemID 
  AND piacl.recordStatus ='RST1' 
  AND piacl.planItemApprovalCriteriaLinkID NOT IN 
  ( 
  SELECT
    planItemApprovalCriteriaLinkID 
  FROM
    PlanTemplatePlanItemApprCrit 
  WHERE planTemplatePlanItemID = :planTemplatePlanItemID 
  )