Operation Details
Description: This method is used to read all the determinations which has the given status and not associated to the given Assessment Configuration
Sterotype: nsmulti
SQL 
SELECT
  determinationConfigID,
  name,
  standAlone
INTO
  :determinationConfigID,
  :name,
  :standAlone 
FROM
  DeterminationConfig DC
WHERE NOT EXISTS 
  ( 
  SELECT
    determinationConfigID 
  FROM
    DetAssessmentConfigLink 
  WHERE DC.determinationConfigID = DetAssessmentConfigLink.determinationConfigID 
    AND DetAssessmentConfigLink.assessmentConfigurationID = :assessmentConfigurationID 
    AND recordStatus = :recordStatus 
  ) 
ORDER BY name