DBA Data[Home] [Help]

APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 368: ,per_absence_attendance_types pat

364: -- ,paa.date_end
365: , LEAST (paa.date_end, csr_v_end_date) enddate
366: ,paa.time_end
367: FROM per_absence_attendances paa
368: ,per_absence_attendance_types pat
369: WHERE paa.person_id = csr_v_person_id
370: AND ( paa.date_start BETWEEN csr_v_start_date AND csr_v_end_date
371: OR paa.date_end BETWEEN csr_v_start_date AND csr_v_end_date
372: )