Operation Details
Description: returns a list of assignments after the date specified
Sterotype: nsmulti
SQL 
SELECT
  Assignment.assignmentID,
  Assignment.positionSlotAvailabilityID,
  Assignment.assignmentDate,
  Assignment.numberAssignments
INTO
  :assignmentID,
  :positionSlotAvailabilityID,
  :assignmentDate,
  :numberAssignments 
FROM
  PositionSlotAvailability,
  Assignment 
WHERE PositionSlotAvailability.positionID = :positionID 
  AND PositionSlotAvailability.slotID = :slotID 
  AND Assignment.positionSlotAvailabilityID = PositionSlotAvailability.positionSlotAvailabilityID 
  AND Assignment.assignmentDate >= :assignmentDate 
  AND Assignment.numberAssignments > 0