APPS.PAY_NO_ABS_VALIDATION dependencies on HR_API

Line 252: BETWEEN p_date_start AND NVL(p_date_end,hr_api.g_eot)

248: AND p_date_start is not null
249: AND (p_absence_attendance_id is null or
250: p_absence_attendance_id <> abs.absence_attendance_id)
251: AND (( abs.date_start
252: BETWEEN p_date_start AND NVL(p_date_end,hr_api.g_eot)
253: )
254: OR
255: ( p_date_start
256: BETWEEN abs.date_start AND NVL(abs.date_end,hr_api.g_eot)

Line 256: BETWEEN abs.date_start AND NVL(abs.date_end,hr_api.g_eot)

252: BETWEEN p_date_start AND NVL(p_date_end,hr_api.g_eot)
253: )
254: OR
255: ( p_date_start
256: BETWEEN abs.date_start AND NVL(abs.date_end,hr_api.g_eot)
257: )
258: );
259: l_exists VARCHAR2(1);
260: l_proc VARCHAR2(100) := 'PAY_NO_ABS_VALIDATION.CHK_ABSENCE_OVERLAP';