Operation Details
Description: This method will take the input parameters to determine if there is an overlapping assessment configuration.
Sterotype: ns
SQL 
SELECT
  assessmentConfigurationID
INTO
  :assessmentConfigurationID 
FROM
  AssessmentConfiguration 
WHERE name = :name 
  AND assessmentType = :assessmentType 
  AND status = :status 
  AND 
  (
    
    (
      :endDate >= startDate 
      OR :endDate IS NULL 
    ) 
    AND 
    (
      :startDate <= endDate 
      OR endDate IS NULL 
    ) 
  )