APPS.OTA_AME_ATTRIBUTES dependencies on OTA_ACTIVITY_VERSIONS_TL

Line 365: c_course_name ota_activity_versions_tl.version_name%type;

361: function get_course_name
362: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
363: return varchar2 is
364:
365: c_course_name ota_activity_versions_tl.version_name%type;
366: c_event_id ota_events.event_id%type;
367: c_item_type varchar2(50);
368: c_item_key varchar2(100);
369:

Line 373: ota_activity_versions_tl oav

369:
370: cursor c_get_course_name is
371: Select oav.version_name
372: From ota_events oev,
373: ota_activity_versions_tl oav
374: Where oev.activity_version_id = oav.activity_version_id
375: And oav.language = USERENV ('LANG')
376: And oev.event_id = c_event_id;
377: begin