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 435: from per_absence_attendances paa, per_absence_attendance_types paat

431: cursor csr_absence_days (
432: p_person_id per_all_people_f.person_id%type
433: ) is
434: select paa.date_start, paa.date_end
435: from per_absence_attendances paa, per_absence_attendance_types paat
436: where paat.absence_attendance_type_id =
437: paa.absence_attendance_type_id
438: and paa.person_id = p_person_id
439: and paa.date_end - paa.date_start > g_absence_termination_limit

Line 451: from per_absence_attendances paa, per_absence_attendance_types paat

447: cursor csr_absence_start_days (
448: p_person_id per_all_people_f.person_id%type
449: ) is
450: select paa.date_start, paa.date_end
451: from per_absence_attendances paa, per_absence_attendance_types paat
452: where paat.absence_attendance_type_id =
453: paa.absence_attendance_type_id
454: and paa.person_id = p_person_id
455: and nvl(paa.date_end,g_end_date) - paa.date_start >= g_absence_termination_limit

Line 465: from per_absence_attendances paa, per_absence_attendance_types paat

461: p_person_id per_all_people_f.person_id%type
462: ,p_prev_last_date date
463: ) is
464: select paa.date_start, paa.date_end
465: from per_absence_attendances paa, per_absence_attendance_types paat
466: where paat.absence_attendance_type_id =
467: paa.absence_attendance_type_id
468: and paa.person_id = p_person_id
469: and paa.date_end - paa.date_start >= g_absence_termination_limit