APPS.OTA_AME_ATTRIBUTES dependencies on OTA_BOOKING_STATUS_TYPES

Line 248: c_enrollment_status ota_booking_status_types.name%type;

244: function get_enrollment_status
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:

Line 258: ota_booking_status_types_tl bst

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;
262: