DBA Data[Home] [Help]

APPS.PAY_NO_EERR_CONTINUOUS dependencies on PER_ABSENCE_ATTENDANCES

Line 452: from per_absence_attendances paa, per_absence_attendance_types paat

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

Line 466: from per_absence_attendances paa, per_absence_attendance_types paat

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