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_GB_OMP_DAILY_ABSENCES dependencies on PQP_GAP_ABSENCE_PLANS

Line 56: ,pqp_gap_absence_plans pgap

52: SELECT pgda.level_of_entitlement
53: ,SUM (pgda.duration) consumed
54: ,SUM (pgda.duration_in_hours) consumed_in_hours
55: FROM pqp_gap_daily_absences pgda
56: ,pqp_gap_absence_plans pgap
57: ,per_absence_attendances paa
58: ,ben_pl_f bpf
59: WHERE pgda.gap_absence_plan_id = pgap.gap_absence_plan_id
60: AND pgap.absence_attendance_id = paa.absence_attendance_id

Line 94: FROM pqp_gap_absence_plans pgap

90: CURSOR c_get_abs_id ( p_plan_id IN NUMBER
91: ,p_absence_id IN NUMBER ) IS
92: SELECT pgap.gap_absence_plan_id abs_id
93: ,pgap.object_version_number
94: FROM pqp_gap_absence_plans pgap
95: WHERE pgap.absence_attendance_id = p_absence_id
96: AND pgap.pl_id = p_plan_id ;
97:
98: -------------debug------------------------------