APPS.OTA_ENT_BUS dependencies on OTA_EVENTS

Line 115: from OTA_EVENTS EVT, OTA_EVENTS_TL ENT

111: l_dummy number(1);
112: --
113: cursor C1 is
114: select 1
115: from OTA_EVENTS EVT, OTA_EVENTS_TL ENT
116: where EVT.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
117: and ( (P_PARENT_EVENT_ID is null )
118: or (EVT.PARENT_EVENT_ID = P_PARENT_EVENT_ID))
119: and upper (ENT.TITLE) = upper (P_TITLE)

Line 220: from ota_events evt

216: --
217: cursor csr_event is
218: select evt.parent_event_id
219: ,evt.business_group_id
220: from ota_events evt
221: where evt.event_id = NVL(p_rec.event_id, p_event_id);
222: --
223: l_business_group_id ota_events.business_group_id%TYPE;
224: l_parent_event_id ota_events.parent_event_id%TYPE;

Line 223: l_business_group_id ota_events.business_group_id%TYPE;

219: ,evt.business_group_id
220: from ota_events evt
221: where evt.event_id = NVL(p_rec.event_id, p_event_id);
222: --
223: l_business_group_id ota_events.business_group_id%TYPE;
224: l_parent_event_id ota_events.parent_event_id%TYPE;
225: --
226: Begin
227: --

Line 224: l_parent_event_id ota_events.parent_event_id%TYPE;

220: from ota_events evt
221: where evt.event_id = NVL(p_rec.event_id, p_event_id);
222: --
223: l_business_group_id ota_events.business_group_id%TYPE;
224: l_parent_event_id ota_events.parent_event_id%TYPE;
225: --
226: Begin
227: --
228: hr_utility.set_location('Entering:'||l_proc,5);

Line 264: , ota_events evt

260: cursor csr_sec_grp is
261: select pbg.security_group_id,
262: pbg.legislation_code
263: from per_business_groups pbg
264: , ota_events evt
265: where evt.event_id = p_event_id
266: and pbg.business_group_id = evt.business_group_id ;
267:
268:

Line 338: , ota_events_tl ent

334: --
335: cursor csr_leg_code is
336: select pbg.legislation_code
337: from per_business_groups pbg
338: , ota_events_tl ent
339: , ota_events evt
340: where ent.event_id = p_event_id
341: and ent.language = p_language
342: and pbg.business_group_id = evt.business_group_id

Line 339: , ota_events evt

335: cursor csr_leg_code is
336: select pbg.legislation_code
337: from per_business_groups pbg
338: , ota_events_tl ent
339: , ota_events evt
340: where ent.event_id = p_event_id
341: and ent.language = p_language
342: and pbg.business_group_id = evt.business_group_id
343: and evt.event_id = ent.event_id;