Operation Details
Description:  
Sterotype: ns
SQL 
SELECT
  Position.name,
  PositionSlotAvailability.positionSlotAvailabilityID,
  PositionSlotAvailability.slotID,
  PositionSlotAvailability.positionID,
  PositionSlotAvailability.comments,
  PositionSlotAvailability.fromDate,
  PositionSlotAvailability.frequencyPattern,
  PositionSlotAvailability.toDate,
  PositionSlotAvailability.recordStatus,
  PositionSlotAvailability.versionNo,
  PositionSlotAvailability.organisationStructureID
INTO
  :positionName,
  :positionSlotAvailabilityID,
  :slotID,
  :positionID,
  :comments,
  :fromDate,
  :frequencyPattern,
  :toDate,
  :recordStatus,
  :versionNo,
  :organisationStructureID 
FROM
  PositionSlotAvailability,
  Position 
WHERE PositionSlotAvailability.positionSlotAvailabilityID = :positionSlotAvailabilityID 
  AND PositionSlotAvailability.positionID = Position.positionID