Operation Details
Description: Searches for planItems not associated with a sub goal and having a specific status.
Sterotype: nsmulti
SQL 
SELECT
  planItemID,
  name,
  dateCreated
INTO
  :planItemID,
  :name,
  :dateCreated 
FROM
  PlanItem 
WHERE recordStatus = :planItemRecordStatus 
  AND planItemID NOT IN 
  ( 
  SELECT
    planItemID 
  FROM
    SubGoalPlanItemLink 
  WHERE subGoalID = :subGoalID 
  )