Operation Details |
Description: | Reads the minimum start date and maximum end date from a list of positions associated with a slot. |
Sterotype: | ns |
SQL |
SELECT MIN(fromDate) , MAX(toDate) INTO :fromDate, :toDate FROM PositionSlotAvailability WHERE slotID = :slotID AND recordStatus = :recordStatus |