APPS.OTA_DELEGATE_BOOKING_SWI dependencies on OTA_DELEGATE_BOOKINGS

Line 393: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;

389: l_object_version_number number;
390: l_tfl_object_version_number number;
391: l_finance_line_id number;
392: --
393: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
394: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
395:
396: --Bug6768247:ANY CHANGE BY ADMIN TO ENROLLMENT CAUSED DATE_STATUS_CHANGED UPDATE
397: CURSOR booking_csr

Line 394: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

390: l_tfl_object_version_number number;
391: l_finance_line_id number;
392: --
393: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
394: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
395:
396: --Bug6768247:ANY CHANGE BY ADMIN TO ENROLLMENT CAUSED DATE_STATUS_CHANGED UPDATE
397: CURSOR booking_csr
398: IS

Line 400: FROM ota_delegate_bookings b

396: --Bug6768247:ANY CHANGE BY ADMIN TO ENROLLMENT CAUSED DATE_STATUS_CHANGED UPDATE
397: CURSOR booking_csr
398: IS
399: SELECT b.date_booking_placed,b.date_status_changed
400: FROM ota_delegate_bookings b
401: WHERE b.booking_id = p_booking_id;
402: --
403:
404: -- Other variables