eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_ABSENCE_PLAN_PROCESS dependencies on HR_API

Line 197: ,hr_api.g_eot

193: ,p_absence_attendance_id => p_absence_attendance_id
194: ,p_absence_date_start => l_absence_dates.date_start
195: ,p_absence_date_end => NVL(
196: l_absence_dates.date_end
197: ,hr_api.g_eot
198: )
199: ,p_effective_start_date => p_effective_start_date
200: ,p_effective_end_date => p_effective_end_date
201: ,p_formula_outputs => p_formula_outputs

Line 318: ,hr_api.g_eot

314: ,p_absence_attendance_id => p_absence_attendance_id
315: ,p_absence_date_start => l_absence_dates.date_start
316: ,p_absence_date_end => NVL(
317: l_absence_dates.date_end
318: ,hr_api.g_eot
319: )
320: ,p_pl_id => p_pl_id
321: ,p_pl_typ_id => p_pl_typ_id
322: ,p_element_type_id => p_element_type_id

Line 517: AND NVL(b.date_end,hr_api.g_eot) )

513: FROM per_absence_attendances b, per_absence_attendance_types paat1
514: WHERE a.person_id = b.person_id
515: AND (
516: (a.date_start BETWEEN b.date_start
517: AND NVL(b.date_end,hr_api.g_eot) )
518: OR (NVL(a.date_end,hr_api.g_eot) BETWEEN b.date_start
519: AND NVL(b.date_end,hr_api.g_eot) )
520: OR (b.date_start BETWEEN a.date_start
521: AND NVL(a.date_end,hr_api.g_eot))

Line 518: OR (NVL(a.date_end,hr_api.g_eot) BETWEEN b.date_start

514: WHERE a.person_id = b.person_id
515: AND (
516: (a.date_start BETWEEN b.date_start
517: AND NVL(b.date_end,hr_api.g_eot) )
518: OR (NVL(a.date_end,hr_api.g_eot) BETWEEN b.date_start
519: AND NVL(b.date_end,hr_api.g_eot) )
520: OR (b.date_start BETWEEN a.date_start
521: AND NVL(a.date_end,hr_api.g_eot))
522: )

Line 519: AND NVL(b.date_end,hr_api.g_eot) )

515: AND (
516: (a.date_start BETWEEN b.date_start
517: AND NVL(b.date_end,hr_api.g_eot) )
518: OR (NVL(a.date_end,hr_api.g_eot) BETWEEN b.date_start
519: AND NVL(b.date_end,hr_api.g_eot) )
520: OR (b.date_start BETWEEN a.date_start
521: AND NVL(a.date_end,hr_api.g_eot))
522: )
523: AND is_gap_absence_type(b.absence_attendance_type_id) = 1

Line 521: AND NVL(a.date_end,hr_api.g_eot))

517: AND NVL(b.date_end,hr_api.g_eot) )
518: OR (NVL(a.date_end,hr_api.g_eot) BETWEEN b.date_start
519: AND NVL(b.date_end,hr_api.g_eot) )
520: OR (b.date_start BETWEEN a.date_start
521: AND NVL(a.date_end,hr_api.g_eot))
522: )
523: AND is_gap_absence_type(b.absence_attendance_type_id) = 1
524: -- checking only for the absence_type_id in table, it is assumed that a
525: -- is the driving absence for which the process is triggered and if that