Operation Details
Description: Searches a list of planned items that may be being cloned.
Sterotype: nsmulti
SQL 
SELECT
  PlannedItem.plannedItemID
INTO
  :plannedItemID 
FROM
  PlannedItem,
  PROVIDERPLANNEDITEMLINK 
WHERE PlannedItem.PLANNEDITEMID = PROVIDERPLANNEDITEMLINK.PLANNEDITEMID 
  AND PlannedItem.name = :name 
  AND PlannedItem.expectedStartDate = :expectedStartDate 
  AND PlannedItem.expectedEndDate = :expectedEndDate 
  AND PlannedItem.expectedOutcomeID = :expectedOutcomeID 
  AND PlannedItem.status = :status 
  AND PlannedItem.frequency = :frequency 
  AND PlannedItem.authorizedUnits = :authorizedUnits