APPS.OTA_LEARNER_ENROLL_REVIEW_SS dependencies on OTA_BKNG_JUSTIFICATIONS_B

Line 514: l_booking_justification_id ota_bkng_justifications_b.booking_justification_id%TYPE;

510: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
511: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
512: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
513: l_offering_id ota_offerings.offering_id%TYPE;
514: l_booking_justification_id ota_bkng_justifications_b.booking_justification_id%TYPE;
515: l_booking_justification ota_bkng_justifications_tl.justification_text%TYPE;
516: begin
517:
518:

Line 777: l_booking_justification_id ota_bkng_justifications_b.booking_justification_id%TYPE;

773: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
774: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
775: l_trnorgnames varchar2(2000);
776: l_offering_id ota_offerings.offering_id%TYPE;
777: l_booking_justification_id ota_bkng_justifications_b.booking_justification_id%TYPE;
778: l_booking_justification ota_bkng_justifications_tl.justification_text%TYPE;
779:
780: begin
781:

Line 1046: l_booking_justification_id ota_bkng_justifications_b.booking_justification_id%TYPE;

1042: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
1043: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
1044: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
1045:
1046: l_booking_justification_id ota_bkng_justifications_b.booking_justification_id%TYPE;
1047: l_priority_level ota_delegate_bookings.booking_priority%TYPE;
1048:
1049: l_timezone fnd_timezones_tl.name%TYPE;
1050: l_course_end_time ota_events.course_start_time%type;

Line 1134: from ota_bkng_justifications_b

1130:
1131:
1132: CURSOR csr_get_priority_level(p_booking_justification_id IN VARCHAR2) IS
1133: select priority_level
1134: from ota_bkng_justifications_b
1135: where booking_justification_id = p_booking_justification_id;
1136:
1137: BEGIN
1138: