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_SC_ARCHIVE dependencies on PER_ABSENCE_ATTENDANCES

Line 196: AND EXISTS(select paa.absence_attendance_id from per_absence_attendances paa, per_absence_attendance_types paat

192: AND csr_v_effective_date BETWEEN papf.effective_start_date
193: AND papf.effective_end_date
194: AND csr_v_effective_date BETWEEN paaf.effective_start_date
195: AND paaf.effective_end_date
196: AND EXISTS(select paa.absence_attendance_id from per_absence_attendances paa, per_absence_attendance_types paat
197: where paa.person_id = papf.person_id
198: and paa.absence_attendance_type_id = paat.absence_attendance_type_id
199: and paat.absence_category in ('CMS','S','PTS')
200: and paa.abs_information1 = 'SC'

Line 293: from per_absence_attendances paa,

289: select papf.employee_number,
290: papf.full_name,
291: paaf.assignment_id,
292: count(paa.abs_information1) sc_days
293: from per_absence_attendances paa,
294: per_absence_attendance_types paat,
295: per_all_assignments_f paaf,
296: per_assignment_status_types past,
297: pay_assignment_actions paas,