SELECT
  COUNT(*)
INTO
  :recordCount 
FROM
  ICAssessmentConfiguration 
WHERE adminIntegratedCaseID = :adminIntegratedCaseID 
  AND assessmentConfigurationID = :assessmentConfigurationID 
  AND recordStatus = :recordStatus 
  AND 
  (
    icAssessmentConfigurationID <> :icAssessmentConfigurationID 
    OR :icAssessmentConfigurationIDIsNull <> '0' 
  ) 
  AND 
  (
    
    (
      endDate >= :startDate 
      OR endDate IS NULL 
    ) 
    AND 
    (
      startDate <= :endDate 
      OR :endDate IS NULL 
    ) 
  )