DBA Data[Home] [Help]

APPS.OTA_FR_PLAN_DFORM dependencies on OTA_EVENTS

Line 122: from ota_events class,

118: select distinct class.event_id class_id
119: ,class_tl.title class_title
120: ,fnd_date.date_to_canonical(class.course_start_date) class_from
121: ,fnd_date.date_to_canonical(class.course_end_date) class_to
122: from ota_events class,
123: ota_events_tl class_tl,
124: ota_activity_versions course
125: where class.event_id is not null
126: and class_tl.event_id = class.event_id

Line 123: ota_events_tl class_tl,

119: ,class_tl.title class_title
120: ,fnd_date.date_to_canonical(class.course_start_date) class_from
121: ,fnd_date.date_to_canonical(class.course_end_date) class_to
122: from ota_events class,
123: ota_events_tl class_tl,
124: ota_activity_versions course
125: where class.event_id is not null
126: and class_tl.event_id = class.event_id
127: and class_tl.language(+) = userenv('LANG')