APPS.OT_WORKFLOW_SS dependencies on OTA_EVENTS

Line 84: c_event_standard_price ota_events.standard_price%type;

80:
81: function get_event_standard_price
82: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
83: return number is
84: c_event_standard_price ota_events.standard_price%type;
85: c_event_id ota_events.event_id%type;
86: c_item_type varchar2(50);
87: c_item_key varchar2(100);
88:

Line 85: c_event_id ota_events.event_id%type;

81: function get_event_standard_price
82: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
83: return number is
84: c_event_standard_price ota_events.standard_price%type;
85: c_event_id ota_events.event_id%type;
86: c_item_type varchar2(50);
87: c_item_key varchar2(100);
88:
89: cursor c_get_standard_price is

Line 91: from ota_events

87: c_item_key varchar2(100);
88:
89: cursor c_get_standard_price is
90: select standard_price
91: from ota_events
92: where event_id = c_event_id;
93:
94: begin
95:

Line 135: c_event_id ota_events.event_id%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:
139: cursor c_get_activity_name is

Line 141: from ota_events evt,

137: c_item_key varchar2(100);
138:
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

Line 189: c_event_id ota_events.event_id%type;

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:
193: cursor c_get_activity_category is

Line 197: ota_events evt,

193: cursor c_get_activity_category is
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

Line 249: c_event_id ota_events.event_id%type;

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:
253: cursor c_get_activity_dm is

Line 257: ota_events evt,

253: cursor c_get_activity_dm is
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