APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on PER_ABSENCE_ATTENDANCE_TYPES
Line 370: ,per_absence_attendance_types pat
366: -- ,paa.date_end
367: , LEAST (paa.date_end, csr_v_end_date) enddate
368: ,paa.time_end
369: FROM per_absence_attendances paa 370: ,per_absence_attendance_types pat 371: WHERE paa.person_id = csr_v_person_id
372: AND ( paa.date_start BETWEEN csr_v_start_date AND csr_v_end_date
373: OR paa.date_end BETWEEN csr_v_start_date AND csr_v_end_date
374: )