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_DAILY_ABSENCES

Line 149: -- write_daily_absences will insert the data into pqp_gap_daily_absences

145: -- entitlements. Then calculate the Absences already taken ( entitlements
146: -- used up ). the difference gives the remaining entitlements.
147: -- Then generate_daily_absences process caches the day and its
148: -- work pattern, Pay band and Absence Band in a pl/sql table
149: -- write_daily_absences will insert the data into pqp_gap_daily_absences
150: -- table using the bulk insert method.
151:
152: PROCEDURE create_absence_plan_details --create_daily_absences
153: (p_assignment_id IN NUMBER

Line 1453: FROM pqp_gap_daily_absences pgda

1449: ,p_pl_typ_id NUMBER ) IS
1450: SELECT pgda.level_of_entitlement
1451: ,SUM(pgda.duration) days
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