DBA Data[Home] [Help]

APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on PER_ABSENCE_ATTENDANCES

Line 369: FROM per_absence_attendances paa

365: ,paa.time_start
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