DBA Data[Home] [Help]

APPS.PQP_GB_OMP_DAILY_ABSENCES dependencies on PQP_GAP_ABSENCE_PLANS

Line 175: l_object_version_number pqp_gap_absence_plans.

171: l_entitlements pqp_absval_pkg.t_entitlements;
172: l_absences_taken_to_date pqp_absval_pkg.t_entitlements;
173: l_entitlements_remaining pqp_absval_pkg.t_entitlements;
174: l_daily_absences pqp_absval_pkg.t_daily_absences;
175: l_object_version_number pqp_gap_absence_plans.
176: object_version_number%TYPE;
177: l_gap_absence_plan pqp_absval_pkg.csr_gap_absence_plan%ROWTYPE;
178:
179: l_plan_information rec_plan_information ;

Line 1454: ,pqp_gap_absence_plans pgap

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
1458: AND pgap.absence_attendance_id = paa.absence_attendance_id