APPS.OTA_LRNR_ENROLL_UNENROLL_WF dependencies on OTA_ACTIVITY_VERSIONS

Line 161: l_version_name ota_activity_versions.version_name%type;

157: l_course_start_time ota_events.course_start_time%type;
158: l_course_end_date ota_events.course_end_date%type;
159: l_delivery_mode ota_category_usages_tl.category%type;
160: l_event_location hr_locations_all.location_code%TYPE;
161: l_version_name ota_activity_versions.version_name%type;
162:
163: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;
164:
165: l_return_status varchar2(1000);

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 358: l_version_name ota_activity_versions.version_name%type;

354:
355: l_event_title ota_events.title%type;
356: l_course_start_date ota_events.course_start_date%type;
357:
358: l_version_name ota_activity_versions.version_name%type;
359:
360: --l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;
361:
362:

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;