Operation Details
Description: Returns a nearest position slot availability record that already exist for this slot and position on this date.
Sterotype: ns
SQL 
SELECT 
MaxFromDateQuery.maxFromDate, 
PositionSlotAvailability.positionSlotAvailabilityID, 
slotID,
positionID,
comments,
frequencyPattern,
toDate,
recordStatus, 
versionNo

INTO 
:fromDate,
:positionSlotAvailabilityID,
:slotID,
:positionID,
:comments,
:frequencyPattern,
:toDate,
:recordStatus,
:versionNo

FROM PositionSlotAvailability

INNER JOIN ( 
SELECT   
  MAX(fromDate) as maxFromDate,   
  PositionSlotAvailability.positionSlotAvailabilityID 
  FROM   PositionSlotAvailability  
  WHERE 
	fromDate <= :effectiveDate AND
     (toDate >= :effectiveDate OR toDate IS NULL)  
  GROUP BY PositionSlotAvailability.positionSlotAvailabilityID
) MaxFromDateQuery ON 
(MaxFromDateQuery.positionSlotAvailabilityID = PositionSlotAvailability.positionSlotAvailabilityID)

WHERE slotID = :slotID AND
positionID = :positionID AND
recordStatus = :recordStatus