SELECT
  COUNT(*)
INTO
  :count 
FROM
  ScreeningAssessmentConfig 
WHERE screeningConfigID = :screeningConfigID 
  AND assessmentConfigurationID = :assessmentConfigurationID 
  AND recordStatus <> :canceledStatus 
  AND 
  (
    scrAssConfigID <> :scrAssConfigID 
    OR :scrAssConfigIDIsNull <> '0' 
  ) 
  AND 
  (
    
    (
      endDate >= :startDate 
      OR endDate IS NULL 
    ) 
    AND 
    (
      startDate <= :endDate 
      OR :endDate IS NULL 
    ) 
  )