DBA Data[Home] [Help]

APPS.PQP_GB_OMP_DAILY_ABSENCES dependencies on PQP_GAP_DAILY_ABSENCES

Line 55: FROM pqp_gap_daily_absences pgda

51: ,p_pl_typ_id IN NUMBER) IS
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