APPS.PAY_FR_ATTESTATION_ASSEDIC dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 85: from per_absence_attendance_types paat

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
88: ) --Not possible to Join as 'connect by ' with 'join' fails in 8i.
89: and level=rownum