Operation Details
Description: returns a list of position slot availability records based on position slot and status.
Sterotype: nsmulti
SQL 
SELECT
  PositionSlotAvailability.positionSlotAvailabilityID,
  PositionSlotAvailability.slotID,
  PositionSlotAvailability.positionID,
  PositionSlotAvailability.comments,
  PositionSlotAvailability.fromDate,
  PositionSlotAvailability.frequencyPattern,
  PositionSlotAvailability.toDate,
  PositionSlotAvailability.recordStatus,
  Position.name,
  PositionSlotAvailability.organisationStructureID
INTO
  :positionSlotAvailabilityID,
  :slotID,
  :positionID,
  :comments,
  :fromDate,
  :frequencyPattern,
  :toDate,
  :recordStatus,
  :positionName,
  :organisationStructureID 
FROM
  Position,
  PositionSlotAvailability 
WHERE PositionSlotAvailability.slotID = :slotID 
  AND PositionSlotAvailability.positionID = :positionID 
  AND PositionSlotAvailability.recordStatus = :recordStatus
  AND Position.positionID = PositionSlotAvailability.positionID