DBA Data[Home] [Help]

APPS.OTA_AME_ATTRIBUTES dependencies on OTA_DELEGATE_BOOKINGS

Line 249: c_booking_id ota_delegate_bookings.booking_id%type;

245: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
246: return varchar2 is
247:
248: c_enrollment_status ota_booking_status_types.name%type;
249: c_booking_id ota_delegate_bookings.booking_id%type;
250: c_item_type varchar2(50);
251: c_item_key varchar2(100);
252:
253: cursor c_get_enrollment_status is

Line 257: ota_delegate_bookings tdb,

253: cursor c_get_enrollment_status is
254: select
255: bst.name
256: from
257: ota_delegate_bookings tdb,
258: ota_booking_status_types_tl bst
259: where tdb.booking_id = c_booking_id and
260: bst.language=userenv('LANG') and
261: tdb.booking_status_type_id = bst.booking_status_type_id;