SELECT
  COUNT(*)
INTO
  :numberOfRecords 
FROM
  PDAssessmentConfiguration 
WHERE productID = :productID 
  AND assessmentConfigurationID = :assessmentConfigurationID 
  AND recordStatus = :recordStatus 
  AND 
  (
    :pdAssessmentConfigurationIDNullInd = '1' 
    OR pdAssessmentConfigurationID <> :pdAssessmentConfigurationID 
  ) 
  AND 
  (
    
    (
      endDate >= :startDate 
      OR endDate IS NULL 
    ) 
    AND 
    (
      startDate <= :endDate 
      OR :endDate IS NULL 
    ) 
  )