Operation Details
Description: returns a list of slot allocations which exist with a number of work units greater than zero for a schedule
Sterotype: nsmulti
SQL 
SELECT
  SlotAllocation.slotAllocationID,
  SlotAllocation.slotID,
  SlotAllocation.slotAllocationDate,
  SlotAllocation.numberWorkUnits,
  SlotAllocation.versionNo
INTO
  :slotAllocationID,
  :slotID,
  :slotAllocationDate,
  :numberWorkUnits,
  :versionNo 
FROM
  SlotAllocation,
  Slot 
WHERE Slot.scheduleID = :scheduleID 
  AND SlotAllocation.slotID = Slot.slotID 
  AND SlotAllocation.numberWorkUnits > 0