SELECT
  activityID,
  subject,
  startDateTime,
  endDateTime,
  Activity.locationID,
  locationName,
  priorityCode,
  allDayInd,
  timeStatusCode,
  notes,
  recordStatusCode
INTO
  :activityID,
  :subject,
  :startDateTime,
  :endDateTime,
  :locationID,
  :locationName,
  :priorityCode,
  :allDayInd,
  :timeStatusCode,
  :notes,
  :recordStatusCode 
FROM
  Users,
  Activity 
WHERE 
  (
    Activity.organisationID = :organisationID 
    AND Users.userName = :userName 
    AND startDateTime < :endDateTime 
    AND endDateTime >= :startDateTime 
  )