APPS.OTA_AME_ATTRIBUTES dependencies on OTA_OFFERINGS_TL

Line 414: c_offering_name ota_offerings_tl.name%type;

410: function get_offering_name
411: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
412: return varchar2 is
413:
414: c_offering_name ota_offerings_tl.name%type;
415: c_event_id ota_events.event_id%type;
416: c_item_type varchar2(50);
417: c_item_key varchar2(100);
418:

Line 422: ota_offerings_tl ofr

418:
419: cursor c_get_offering_name is
420: Select ofr.name
421: From ota_events oev,
422: ota_offerings_tl ofr
423: Where oev.parent_offering_id = ofr.offering_id
424: And ofr.language = USERENV ('LANG')
425: And oev.event_id = c_event_id;
426: begin