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