Operation Details
Description: Returns a list of all active position slot availability for a slot.
Sterotype: nsmulti
SQL 
SELECT
  PositionSlotAvailability.positionSlotAvailabilityID,
  PositionSlotAvailability.slotID,
  PositionSlotAvailability.positionID,
  PositionSlotAvailability.comments,
  PositionSlotAvailability.fromDate,
  PositionSlotAvailability.frequencyPattern,
  PositionSlotAvailability.toDate,
  PositionSlotAvailability.recordStatus,
  Position.name,
  PositionSlotAvailability.organisationStructureID,
  PositionSlotAvailability.versionNo
INTO
  :positionSlotAvailabilityID,
  :slotID,
  :positionID,
  :comments,
  :fromDate,
  :frequencyPattern,
  :toDate,
  :recordStatus,
  :positionName,
  :organisationStructureID,
  :versionNo
FROM
  Position,
  PositionSlotAvailability 
WHERE PositionSlotAvailability.slotID = :slotID 
  AND Position.positionID = PositionSlotAvailability.positionID 
  AND PositionSlotAvailability.recordStatus = :recordStatus