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 BEN_PL_F

Line 10: g_pl_id ben_pl_f.pl_typ_id%TYPE;

6: -----------------
7:
8: g_nested_level NUMBER:= 0;
9: g_package_name VARCHAR2(31) := 'pqp_gb_omp_daily_absences.' ;
10: g_pl_id ben_pl_f.pl_typ_id%TYPE;
11: g_plan_information rec_plan_information ;
12: g_debug BOOLEAN ;
13: g_log_duration_summary VARCHAR2(20) := NULL;
14:

Line 1456: ,ben_pl_f bpf

1452: ,SUM(pgda.duration_in_hours) hours
1453: FROM pqp_gap_daily_absences pgda
1454: ,pqp_gap_absence_plans pgap
1455: ,per_absence_attendances paa
1456: ,ben_pl_f bpf
1457: WHERE pgda.gap_absence_plan_id = pgap.gap_absence_plan_id
1458: AND pgap.absence_attendance_id = paa.absence_attendance_id
1459: AND pgda.absence_date <= p_effective_date
1460: AND pgap.assignment_id = p_assignment_id