Operation Details
Description: Returns a position slot availability record that already exist for this slot and position and overlaps with this date range.
Sterotype: ns
SQL 
SELECT
  fromDate,
  positionSlotAvailabilityID,
  slotID,
  positionID,
  comments,
  frequencyPattern,
  toDate,
  recordStatus,
  versionNo
INTO
  :fromDate,
  :positionSlotAvailabilityID,
  :slotID,
  :positionID,
  :comments,
  :frequencyPattern,
  :toDate,
  :recordStatus,
  :versionNo 
FROM
  PositionSlotAvailability 
WHERE slotID = :slotID 
  AND positionID = :positionID 
  AND 
  (
    
    (
      fromDate <= :fromDate 
      AND toDate >= :fromDate 
    ) 
    OR 
    (
      fromDate <= :toDate 
      AND toDate >= :toDate 
    ) 
    OR 
    (
      fromDate > :fromDate 
      AND toDate < :toDate 
    ) 
  ) 
  AND recordStatus = :recordStatus