APPS.PAY_FR_ATTESTATION_ASSEDIC dependencies on PER_ABSENCE_ATTENDANCES

Line 83: per_absence_attendances paa

79: p_last_day_worked In Date) Return Date Is
80: Cursor csr_last_fulltime_day_worked Is
81: select nvl(min(paa.date_start)-1,p_last_day_worked)
82: from
83: per_absence_attendances paa
84: where exists (select paat.absence_attendance_type_id
85: from per_absence_attendance_types paat
86: Where paat.absence_category in ('S','UL')
87: and paa.absence_attendance_type_id = paat.absence_attendance_type_id