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.HR_BIS_ALERTS dependencies on OTA_ACTIVITY_VERSIONS

Line 783: l_activity_version_name ota_activity_versions.version_name%TYPE;

779: (p_activity_version_id IN NUMBER)
780: RETURN VARCHAR2
781: IS
782:
783: l_activity_version_name ota_activity_versions.version_name%TYPE;
784:
785: CURSOR av_cur (p_activity_version_id IN NUMBER) IS
786: SELECT version_name
787: FROM ota_activity_versions

Line 787: FROM ota_activity_versions

783: l_activity_version_name ota_activity_versions.version_name%TYPE;
784:
785: CURSOR av_cur (p_activity_version_id IN NUMBER) IS
786: SELECT version_name
787: FROM ota_activity_versions
788: WHERE activity_version_id = p_activity_version_id;
789:
790:
791: BEGIN

Line 2896: l_activity_version_name ota_activity_versions.version_name%TYPE; -- name of training course (activity version)

2892: l_error VARCHAR2(2000);
2893:
2894: l_report_name VARCHAR2(8) := 'HRTRNSUC';
2895:
2896: l_activity_version_name ota_activity_versions.version_name%TYPE; -- name of training course (activity version)
2897: l_actual VARCHAR2(80); -- Actual value (e.g. 25%)
2898: l_job_cat hr_lookups.meaning%TYPE; -- Job category
2899: l_job_name per_jobs.name%TYPE; -- Job name
2900: l_loc_name hr_locations.location_code%TYPE; -- Location name

Line 3160: , ota_activity_versions ver

3156: , evt.title
3157: , dbk.successful_attendance_flag
3158: FROM per_assignments_f asg
3159: , ota_booking_status_types bst
3160: , ota_activity_versions ver
3161: , ota_events evt
3162: , ota_delegate_bookings dbk
3163: WHERE dbk.delegate_assignment_id = asg.assignment_id
3164: AND evt.course_start_date BETWEEN