APPS.PQH_LENGTH_OF_SERVICE_PKG dependencies on PER_ABSENCE_ATTENDANCES

Line 232: FROM per_absence_attendances paa,

228: NVL(paa.absence_days,0) ABSENCE_DAYS,
229: NVL(paa.absence_hours,0) ABSENCE_HOURS,
230: paa.date_start,
231: paa.date_end
232: FROM per_absence_attendances paa,
233: per_absence_attendance_types aat
234: WHERE paa.business_group_id = p_bg_id
235: AND paa.person_id = p_person_id
236: AND ( paa.date_start BETWEEN p_start_date AND p_end_date