DBA Data[Home] [Help]

APPS.OTA_LRNR_ENROLL_UNENROLL_WF dependencies on OTA_EVENTS_TL

Line 185: from ota_Events oev , ota_events_tl evt,ota_activity_versions_tl oav,

181: oev.course_end_date, oev.course_start_time,
182: ctl.category,
183: ota_general.get_location_code(oev.location_id) Location_Name,
184: oav.version_name,ota_timezone_util.get_timezone_name(oev.timezone),oev.course_end_time
185: from ota_Events oev , ota_events_tl evt,ota_activity_versions_tl oav,
186: OTA_CATEGORY_USAGES_TL ctl,ota_offerings off
187: where oev.event_id = evt.event_id
188: and oev.parent_offering_id=off.offering_id
189: and off.activity_version_id= oav.activity_version_id

Line 368: from ota_Events oev , ota_events_tl evt,ota_activity_versions_tl oav

364:
365: Cursor csr_name is
366: select evt.title,oev.course_start_date,
367: oav.version_name
368: from ota_Events oev , ota_events_tl evt,ota_activity_versions_tl oav
369: where oev.event_id = evt.event_id
370: and oev.activity_version_id= oav.activity_version_id
371: AND evt.language = userenv('LANG')
372: and oev.event_id= p_eventid;