DBA Data[Home] [Help]

APPS.PAY_NO_ABSENCE_USER dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 64: FROM per_absence_attendances paa, per_absence_attendance_types pat

60: CURSOR CSR_CONT_LINK (l_person_id IN number,l_abs_st_date IN date) IS
61: SELECT paa.absence_attendance_id
62: ,paa.date_start
63: ,paa.date_end
64: FROM per_absence_attendances paa, per_absence_attendance_types pat
65: WHERE paa.person_id = l_person_id
66: AND paa.date_start < l_abs_st_date
67: AND paa.date_end < l_abs_st_date
68: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL