Operation Details
Description: Checks to see if a rule set has a simulation of the same name existing already.
Sterotype: ns
SQL
SELECT
  COUNT(*)
INTO
  :numberOfRecords 
FROM
  RulesSimulation 
WHERE 
  (
    upper(name) = :name 
  ) 
  AND ruleSetID = :ruleSetID 
  AND 
  (
    rulesSimulationID <> :rulesSimulationID 
    OR :rulesSimulationIDIsNull <> '0' 
  )