Operation Details
Description: Method to search active Allegation Details list which are not assigned to Action by case id.
Sterotype: nsmulti
SQL 
SELECT
  allegationID,
  type,
  allegationDateTime,
  location,
  recordStatus
INTO
  :allegationID,
  :type,
  :allegationDateTime,
  :location,
  :recordStatus 
FROM
  Allegation 
WHERE caseID = :caseID 
  AND recordStatus = :recordStatus 
  AND allegationID NOT IN 
  ( 
  SELECT
    childLinkID 
  FROM
    ActionChildLink 
  WHERE relatedID = :caseID 
    AND childType = :childType 
    AND recordStatus = :recordStatus 
  )