APPS.OTA_TRNG_ENROLL_SS dependencies on OTA_ACTIVITY_VERSIONS

Line 119: FROM OTA_ACTIVITY_VERSIONS_TL

115:
116: CURSOR csr_activity(p_activity_version_id number )
117: IS
118: SELECT version_name
119: FROM OTA_ACTIVITY_VERSIONS_TL
120: WHERE activity_version_id = p_activity_version_id
121: AND language=userenv('LANG');
122:
123: l_price_basis OTA_EVENTS.price_basis%TYPE;

Line 174: l_activity_version_id ota_activity_versions.activity_version_id%type;

170: l_event_title ota_events.title%type;
171: l_course_start_date ota_events.course_start_date%type;
172: l_course_end_date ota_events.course_end_date%type;
173: l_owner_id ota_events.owner_id%type;
174: l_activity_version_id ota_activity_versions.activity_version_id%type;
175: l_version_name ota_activity_versions.version_name%type;
176: l_owner_username fnd_user.user_name%type;
177: --Bug#2197997 commenting out completeactivity call.
178: -- l_return boolean;

Line 175: l_version_name ota_activity_versions.version_name%type;

171: l_course_start_date ota_events.course_start_date%type;
172: l_course_end_date ota_events.course_end_date%type;
173: l_owner_id ota_events.owner_id%type;
174: l_activity_version_id ota_activity_versions.activity_version_id%type;
175: l_version_name ota_activity_versions.version_name%type;
176: l_owner_username fnd_user.user_name%type;
177: --Bug#2197997 commenting out completeactivity call.
178: -- l_return boolean;
179: l_offering_id ota_events.offering_id%type;

Line 1916: l_version_name ota_activity_versions.version_name%type;

1912: l_event_id NUMBER;
1913: l_user_name FND_USER.USER_NAME%TYPE;
1914: l_offering_id ota_events.offering_id%type;
1915: l_booking_id ota_delegate_bookings.booking_id%type;
1916: l_version_name ota_activity_versions.version_name%type;
1917: l_notification_text varchar2(2000);
1918: l_status_type ota_booking_status_types.type%type;
1919: BEGIN
1920: