DBA Data[Home] [Help]

APPS.OTA_BULK_ENROLL_UTIL dependencies on OTA_ACTIVITY_VERSIONS

Line 474: FROM OTA_ACTIVITY_VERSIONS_TL

470:
471: CURSOR csr_activity(p_activity_version_id number )
472: IS
473: SELECT version_name
474: FROM OTA_ACTIVITY_VERSIONS_TL
475: WHERE activity_version_id = p_activity_version_id
476: AND language=userenv('LANG');
477:
478: CURSOR csr_get_priority IS

Line 599: l_activity_version_id ota_activity_versions.activity_version_id%type;

595: l_event_title ota_events.title%type;
596: l_course_start_date ota_events.course_start_date%type;
597: l_course_end_date ota_events.course_end_date%type;
598: l_owner_id ota_events.owner_id%type;
599: l_activity_version_id ota_activity_versions.activity_version_id%type;
600: l_version_name ota_activity_versions.version_name%type;
601: l_owner_username fnd_user.user_name%type;
602: l_offering_id ota_events.offering_id%type;
603: l_booking_status_used VARCHAR2(20);

Line 600: l_version_name ota_activity_versions.version_name%type;

596: l_course_start_date ota_events.course_start_date%type;
597: l_course_end_date ota_events.course_end_date%type;
598: l_owner_id ota_events.owner_id%type;
599: l_activity_version_id ota_activity_versions.activity_version_id%type;
600: l_version_name ota_activity_versions.version_name%type;
601: l_owner_username fnd_user.user_name%type;
602: l_offering_id ota_events.offering_id%type;
603: l_booking_status_used VARCHAR2(20);
604: