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

Line 518: from per_absence_attendances paa, per_absence_attendance_types paat

514: cursor csr_absence_days (
515: p_person_id per_all_people_f.person_id%type
516: ) is
517: select paa.date_start, paa.date_end
518: from per_absence_attendances paa, per_absence_attendance_types paat
519: where paat.absence_attendance_type_id =
520: paa.absence_attendance_type_id
521: and paa.person_id = p_person_id
522: and paa.date_end - paa.date_start > g_absence_termination_limit

Line 534: from per_absence_attendances paa, per_absence_attendance_types paat

530: cursor csr_absence_start_days (
531: p_person_id per_all_people_f.person_id%type
532: ) is
533: select paa.date_start, paa.date_end
534: from per_absence_attendances paa, per_absence_attendance_types paat
535: where paat.absence_attendance_type_id =
536: paa.absence_attendance_type_id
537: and paa.person_id = p_person_id
538: and paa.date_start between g_effective_start_date and g_effective_date

Line 595: from per_absence_attendances paa, per_absence_attendance_types paat

591: p_person_id per_all_people_f.person_id%type
592: ,p_prev_last_date date
593: ) is
594: select paa.date_start, paa.date_end
595: from per_absence_attendances paa, per_absence_attendance_types paat
596: where paat.absence_attendance_type_id =
597: paa.absence_attendance_type_id
598: and paa.person_id = p_person_id
599: and paa.date_end between p_prev_last_date and g_effective_date