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.PAY_NO_ABSENCE_USER dependencies on PER_ABSENCE_ATTENDANCES

Line 63: FROM per_absence_attendances paa, per_absence_attendance_types pat

59: CURSOR CSR_CONT_LINK (l_person_id IN number,l_abs_st_date IN date) IS
60: SELECT paa.absence_attendance_id
61: ,paa.date_start
62: ,paa.date_end
63: FROM per_absence_attendances paa, per_absence_attendance_types pat
64: WHERE paa.person_id = l_person_id
65: AND paa.date_start < l_abs_st_date
66: AND paa.date_end < l_abs_st_date
67: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 112: FROM per_absence_attendances abs

108: ,l_start_time
109: ,l_end_time
110: ,l_intial_absence
111: ,l_initial_abs_creator_id
112: FROM per_absence_attendances abs
113: WHERE abs.absence_attendance_id = p_absence_attendance_id;
114: EXCEPTION
115: WHEN OTHERS THEN
116: NULL;