APPS.OTA_AME_ATTRIBUTES dependencies on OTA_OFFERINGS

Line 199: ota_offerings ofr

195: Select ocu.Category
196: From ota_act_cat_inclusions oaci,
197: ota_category_usages_vl ocu,
198: ota_events oev,
199: ota_offerings ofr
200: Where oev.event_id = c_event_id
201: AND oev.parent_offering_id = ofr.offering_id
202: AND ofr.activity_version_id = oaci.activity_version_id
203: AND ocu.category_usage_id = oaci.category_usage_id

Line 304: c_offering_id ota_offerings.offering_id%type;

300: return varchar2 is
301:
302: c_delivery_mode ota_category_usages_tl.category%type;
303: c_event_id ota_events.event_id%type;
304: c_offering_id ota_offerings.offering_id%type;
305: c_item_type varchar2(50);
306: c_item_key varchar2(100);
307:
308: cursor c_get_ofr_dm is

Line 310: From ota_offerings ofr,

306: c_item_key varchar2(100);
307:
308: cursor c_get_ofr_dm is
309: Select ocu.Category
310: From ota_offerings ofr,
311: ota_category_usages_vl ocu
312: Where ofr.offering_id = c_offering_id
313: AND ofr.delivery_mode_id = ocu.category_usage_id
314: AND ocu.type = 'DM'

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