APPS.OT_WORKFLOW_SS dependencies on OTA_ACTIVITY_DEFINITIONS

Line 134: c_activity_name ota_activity_definitions.name%type;

130: function get_activity_type
131: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
132: return varchar2 is
133:
134: c_activity_name ota_activity_definitions.name%type;
135: c_event_id ota_events.event_id%type;
136: c_item_type varchar2(50);
137: c_item_key varchar2(100);
138:

Line 143: ota_activity_definitions_tl oad

139: cursor c_get_activity_name is
140: select oad.name
141: from ota_events evt,
142: ota_activity_versions oav,
143: ota_activity_definitions_tl oad
144: where evt.event_id = c_event_id and
145: oad.language=userenv('LANG') and
146: evt.activity_version_id = oav.activity_version_id and
147: oav.activity_id = oad.activity_id;