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_LEARNER_ENROLL_REVIEW_SS dependencies on OTA_ACTIVITY_VERSIONS

Line 1007: l_version_name ota_activity_versions.version_name%type;

1003: l_offering_id ota_events.offering_id%type;
1004: l_date_booking_placed date;
1005: l_current_date date;
1006: l_restricted_assignment_id PER_ASSIGNMENTS_F.assignment_id%type;
1007: l_version_name ota_activity_versions.version_name%type;
1008: l_owner_username fnd_user.user_name%type;
1009: l_owner_id ota_events.owner_id%type;
1010: l_activity_version_id ota_activity_versions.activity_version_id%type;
1011: l_event_title ota_events.title%type;

Line 1010: l_activity_version_id ota_activity_versions.activity_version_id%type;

1006: l_restricted_assignment_id PER_ASSIGNMENTS_F.assignment_id%type;
1007: l_version_name ota_activity_versions.version_name%type;
1008: l_owner_username fnd_user.user_name%type;
1009: l_owner_id ota_events.owner_id%type;
1010: l_activity_version_id ota_activity_versions.activity_version_id%type;
1011: l_event_title ota_events.title%type;
1012: l_course_start_date ota_events.course_start_date%type;
1013: l_course_start_time ota_events.course_start_time%type;
1014: l_course_end_date ota_events.course_end_date%type;

Line 1116: FROM OTA_ACTIVITY_VERSIONS_TL

1112:
1113: CURSOR csr_activity(p_activity_version_id number )
1114: IS
1115: SELECT version_name
1116: FROM OTA_ACTIVITY_VERSIONS_TL
1117: WHERE activity_version_id = p_activity_version_id
1118: AND language=userenv('LANG');
1119:
1120: