APPS.OTA_EL_TRAINING_SS dependencies on OTA_ACTIVITY_VERSIONS

Line 1124: l_version_name ota_activity_versions.version_name%type;

1120: l_offering_id ota_events.offering_id%type;
1121: l_date_booking_placed date;
1122: l_current_date date;
1123: l_restricted_assignment_id PER_ASSIGNMENTS_F.assignment_id%type;
1124: l_version_name ota_activity_versions.version_name%type;
1125: l_owner_username fnd_user.user_name%type;
1126: l_owner_id ota_events.owner_id%type;
1127: l_activity_version_id ota_activity_versions.activity_version_id%type;
1128: l_event_title ota_events.title%type;

Line 1127: l_activity_version_id ota_activity_versions.activity_version_id%type;

1123: l_restricted_assignment_id PER_ASSIGNMENTS_F.assignment_id%type;
1124: l_version_name ota_activity_versions.version_name%type;
1125: l_owner_username fnd_user.user_name%type;
1126: l_owner_id ota_events.owner_id%type;
1127: l_activity_version_id ota_activity_versions.activity_version_id%type;
1128: l_event_title ota_events.title%type;
1129: l_course_start_date ota_events.course_start_date%type;
1130: l_course_end_date ota_events.course_end_date%type;
1131: l_notification_text VARCHAR2(1000);

Line 1216: FROM OTA_ACTIVITY_VERSIONS_TL

1212:
1213: CURSOR csr_activity(p_activity_version_id number )
1214: IS
1215: SELECT version_name
1216: FROM OTA_ACTIVITY_VERSIONS_TL
1217: WHERE activity_version_id = p_activity_version_id AND language(+) = userenv('LANG');
1218:
1219: CURSOR csr_user(p_owner_id in number) IS
1220: SELECT