DBA Data[Home] [Help]

APPS.OTA_ENT_BUS dependencies on OTA_EVENTS_TL

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 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