APPS.OT_WORKFLOW_SS dependencies on OTA_BOOKING_STATUS_TYPES

Line 309: c_enrollment_status ota_booking_status_types.name%type;

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

Line 319: ota_booking_status_types_tl bst

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