APPS.OTA_CANCEL_TRAINING_SS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 67

SELECT user_name
FROM   fnd_user
WHERE  employee_id = p_person_id;

Line: 72

SELECT employee_id
FROM   fnd_user
WHERE  user_id = l_current_userid;

Line: 79

SELECT full_name
FROM   per_all_people_f p
WHERE  person_id = l_display_person_id
  --Modified for bug#4057241
  --AND  effective_start_date <= p_course_start_date
  --AND  effective_start_date <= nvl(p_course_start_date, SYSDATE)
  --AND  NVL(effective_end_date, SYSDATE) >= NVL(p_course_end_date, SYSDATE);

Line: 90

  SELECT asg.supervisor_id, per.full_name
    FROM per_all_assignments_f asg,
         per_all_people_f per
   WHERE asg.person_id = p_person_id
     AND per.person_id = asg.supervisor_id
     AND asg.primary_flag = 'Y'
     AND trunc(sysdate)
 BETWEEN asg.effective_start_date AND asg.effective_end_date
     AND trunc(sysdate)
 BETWEEN per.effective_start_date AND per.effective_end_date;

Line: 102

 SELECT user_name
   FROM fnd_user
  WHERE employee_id= l_supervisor_id;

Line: 384

SELECT a.version_name,
       e.title,
       e.event_status,
       e.course_start_date,
       e.course_start_time,
       e.course_end_date,
       e.owner_id
FROM   ota_events_vl e,
       ota_activity_versions_tl a
WHERE  a.activity_version_id = e.activity_version_id
AND    e.event_id = p_event_id
AND    language=userenv('LANG');

Line: 400

SELECT b.date_booking_placed, b.content_player_status, b.object_version_number
FROM   ota_delegate_bookings b
WHERE  b.booking_id = p_booking_id;

Line: 406

SELECT fln.finance_line_id finance_line_id,
	 fln.finance_header_id finance_header_id,
	 fln.transfer_status transfer_status,
	 fln.booking_id booking_id,
	 fln.object_version_number object_version_number,
	 fln.sequence_number sequence_number,
	 fln.Cancelled_flag cancelled_flag
FROM   ota_finance_lines fln
WHERE  fln.booking_id = p_booking_id;

Line: 418

SELECT COUNT(*)
FROM	 ota_finance_lines fln
WHERE	 fln.finance_header_id = p_finance_header_id;

Line: 424

SELECT flh.finance_header_id finance_header_id,
	 flh.cancelled_flag cancelled_flag,
	 flh.transfer_status transfer_status,
	 flh.object_version_number object_version_number
FROM   ota_finance_headers flh,
       ota_finance_lines fln
WHERE  flh.finance_header_id =  fln.finance_header_id
   AND fln.booking_id = p_booking_id;

Line: 435

SELECT  USER_NAME
  FROM  FND_USER
 WHERE  Employee_id = p_owner_id;

Line: 580

   ota_tdb_api_upd2.update_enrollment
            (p_booking_id                 => p_booking_id,
             p_booking_status_type_id     => p_booking_status_type_id,
             p_object_version_number      => l_object_version_number,
             p_event_id		          => p_event_id,
             p_status_change_comments     => p_cancel_reason,  --Bug 2332743
             p_tfl_object_version_number  => lf_object_version_number,
             p_finance_line_id            => l_finance_line_id,
             p_daemon_flag                => l_daemon_flag,
             p_daemon_type                => l_daemon_type,
             p_date_status_changed        => l_sysdate,
             p_date_booking_placed        => l_date_booking_placed,
	     p_tdb_information_category   => p_tdb_information_category,
             p_tdb_information1     	  => p_tdb_information1,
             p_tdb_information2     	  => p_tdb_information2,
             p_tdb_information3     	  => p_tdb_information3,
             p_tdb_information4     	  => p_tdb_information4,
             p_tdb_information5     	  => p_tdb_information5,
             p_tdb_information6     	  => p_tdb_information6,
             p_tdb_information7     	  => p_tdb_information7,
             p_tdb_information8     	  => p_tdb_information8,
             p_tdb_information9     	  => p_tdb_information9,
             p_tdb_information10     	  => p_tdb_information10,
             p_tdb_information11     	  => p_tdb_information11,
             p_tdb_information12     	  => p_tdb_information12,
             p_tdb_information13     	  => p_tdb_information13,
             p_tdb_information14     	  => p_tdb_information14,
             p_tdb_information15     	  => p_tdb_information15,
             p_tdb_information16     	  => p_tdb_information16,
             p_tdb_information17     	  => p_tdb_information17,
             p_tdb_information18     	  => p_tdb_information18,
             p_tdb_information19     	  => p_tdb_information19,
             p_tdb_information20     	  => p_tdb_information20
	     );

Line: 682

SELECT bsh.comments
  FROM ota_booking_status_histories bsh
 WHERE bsh.booking_id = p_booking_id
   AND bsh.booking_status_type_id = p_booking_status_type_id
 ORDER BY bsh.start_date ASC;