SELECT
  conditionID,
  name
INTO
  :conditionID,
  :conditionName 
FROM
  Condition 
WHERE conditionID NOT IN 
  ( 
  SELECT
    conditionID 
  FROM
    ConditionDCLink 
  WHERE determinationConfigID = :determinationConfigID 
  ) 
  AND conditionID in 
  ( 
  SELECT
    conditionID 
  FROM
    Condition 
  WHERE recordStatus = :recordStatus 
  )