eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TRAINING_SS dependencies on OTA_ACTIVITY_VERSIONS

Line 1379: l_version_name ota_activity_versions.version_name%type;

1375: l_offering_id ota_events.offering_id%type;
1376: l_date_booking_placed date;
1377: l_current_date date;
1378: l_restricted_assignment_id PER_ASSIGNMENTS_F.assignment_id%type;
1379: l_version_name ota_activity_versions.version_name%type;
1380: l_owner_username fnd_user.user_name%type;
1381: l_owner_id ota_events.owner_id%type;
1382: l_activity_version_id ota_activity_versions.activity_version_id%type;
1383: l_event_title ota_events.title%type;

Line 1382: l_activity_version_id ota_activity_versions.activity_version_id%type;

1378: l_restricted_assignment_id PER_ASSIGNMENTS_F.assignment_id%type;
1379: l_version_name ota_activity_versions.version_name%type;
1380: l_owner_username fnd_user.user_name%type;
1381: l_owner_id ota_events.owner_id%type;
1382: l_activity_version_id ota_activity_versions.activity_version_id%type;
1383: l_event_title ota_events.title%type;
1384: l_course_start_date ota_events.course_start_date%type;
1385: l_course_end_date ota_events.course_end_date%type;
1386: l_notification_text VARCHAR2(1000);

Line 1467: FROM OTA_ACTIVITY_VERSIONS_TL

1463:
1464: CURSOR csr_activity(p_activity_version_id number )
1465: IS
1466: SELECT version_name
1467: FROM OTA_ACTIVITY_VERSIONS_TL
1468: WHERE activity_version_id = p_activity_version_id
1469: AND language=userenv('LANG');
1470:
1471: