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