Operation Details |
Description: | Reads the list of slots based on record status and schedule id. |
Sterotype: | nsmulti |
SQL |
SELECT Slot.slotID, Slot.scheduleID, Slot.name, Slot.startTime, Slot.endTime, Slot.recordStatus, Slot.comments, Slot.maxWorkUnits, Slot.versionNo INTO :slotID, :scheduleID, :name, :startTime, :endTime, :recordStatus, :comments, :maxWorkUnits, :versionNo FROM Slot WHERE Slot.scheduleID = :scheduleID AND Slot.recordStatus = :recordStatus |