DBA Data[Home] [Help]

APPS.OT_WORKFLOW_SS dependencies on OTA_DELEGATE_BOOKINGS

Line 310: c_booking_id ota_delegate_bookings.booking_id%type;

306: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
307: return varchar2 is
308:
309: c_enrollment_status ota_booking_status_types.name%type;
310: c_booking_id ota_delegate_bookings.booking_id%type;
311: c_item_type varchar2(50);
312: c_item_key varchar2(100);
313:
314: cursor c_get_enrollment_status is

Line 318: ota_delegate_bookings tdb,

314: cursor c_get_enrollment_status is
315: select
316: bst.name
317: from
318: ota_delegate_bookings tdb,
319: ota_booking_status_types_tl bst
320: where tdb.booking_id = c_booking_id and
321: bst.language=userenv('LANG') and
322: tdb.booking_status_type_id = bst.booking_status_type_id;