APPS.OT_WORKFLOW_SS dependencies on OTA_ACT_CAT_INCLUSIONS

Line 188: c_activity_category ota_act_cat_inclusions.activity_category%type;

184: function get_act_pm_category
185: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
186: return varchar2 is
187:
188: c_activity_category ota_act_cat_inclusions.activity_category%type;
189: c_event_id ota_events.event_id%type;
190: c_item_type varchar2(50);
191: c_item_key varchar2(100);
192:

Line 198: ota_act_cat_inclusions oac,

194: select
195: hl.meaning
196: from
197: ota_events evt,
198: ota_act_cat_inclusions oac,
199: ota_category_usages ocu,
200: hr_lookups hl
201: where evt.event_id = c_event_id and
202: evt.activity_version_id = oac.activity_version_id and

Line 248: c_delivery_method ota_act_cat_inclusions.activity_category%type;

244: function get_act_pm_delivery_method
245: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
246: return varchar2 is
247:
248: c_delivery_method ota_act_cat_inclusions.activity_category%type;
249: c_event_id ota_events.event_id%type;
250: c_item_type varchar2(50);
251: c_item_key varchar2(100);
252:

Line 258: ota_act_cat_inclusions oac,

254: select
255: hl.meaning
256: from
257: ota_events evt,
258: ota_act_cat_inclusions oac,
259: ota_category_usages ocu,
260: hr_lookups hl
261: where evt.event_id = c_event_id and
262: evt.activity_version_id = oac.activity_version_id and