Operation Details
Description: @Deprecated Since curam 6.0 replaced with {@link MilestoneConfiguration#countMilestoneDuplicatePeriods()} as part of implementing localization of MilestoneConfiguration attributes . See release note: CR00233651. This method checks for overlapping periods with other records of the same milestone type.
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :numberOfRecords 
FROM
  MilestoneConfiguration MC,
  TextTranslation TT
WHERE TT.shortText  = :name 
  AND recordStatus = :recordStatus 
  AND 
  (
    
    (
      endDate IS NULL 
      AND 
      (
        :startDate >= startDate 
      ) 
    ) 
    OR 
    (
      :startDate >= startDate 
      AND :startDate <= endDate 
    ) 
    OR 
    (
      :endDate >= startDate 
      AND :endDate <= endDate 
    ) 
    OR 
    (
      :endDate IS NULL 
      AND :startDate <= endDate 
    ) 
  )