Operation Details
Description: Returns a list of slot allocations with the number with work units greater than zero for a particular location after an effective date.
Sterotype: nsmulti
SQL 
SELECT
  SlotAllocation.slotAllocationID,
  SlotAllocation.slotID,
  SlotAllocation.slotAllocationDate,
  SlotAllocation.numberWorkUnits,
  SlotAllocation.versionNo
INTO
  :slotAllocationID,
  :slotID,
  :slotAllocationDate,
  :numberWorkUnits,
  :versionNo 
FROM
  SlotAllocation,
  DailySchedule,
  Slot 
WHERE DailySchedule.locationID = :locationID 
  AND DailySchedule.effectiveDate >= :effectiveDate 
  AND Slot.scheduleID = DailySchedule.scheduleID 
  AND SlotAllocation.slotID = Slot.slotID 
  AND SlotAllocation.numberWorkUnits > 0 
  AND Dailyschedule.type = :locationScheduleType