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.PER_NO_SICKLEAVEMONITORING dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 118: ,per_absence_attendance_types paat

114: ,NVL(paa.date_end,c_to_date) end_date
115: ,papf.employee_number employee_number
116: ,papf.full_name employee_name
117: FROM per_absence_attendances paa
118: ,per_absence_attendance_types paat
119: ,per_all_assignments_f paaf
120: ,per_assignment_status_types past
121: ,per_all_people_f papf
122: ,hr_soft_coding_keyflex hsc

Line 198: ,per_absence_attendance_types pat

194: ,curr_abs.date_start curr_start_date
195: ,curr_abs.date_end curr_end_date
196: FROM per_absence_attendances prev_abs
197: ,per_absence_attendances curr_abs
198: ,per_absence_attendance_types pat
199: WHERE prev_abs.absence_attendance_type_id = pat.absence_attendance_type_id
200: AND prev_abs.date_end < curr_abs.date_start
201: AND pat.absence_category IN ('S','PTS')
202: AND (((curr_abs.date_start - prev_abs.date_end) <= absence_link_period)