DBA Data[Home] [Help]

APPS.PQP_GB_OMP_DAILY_ABSENCES dependencies on PER_ABSENCE_ATTENDANCES

Line 1455: ,per_absence_attendances paa

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
1459: AND pgda.absence_date <= p_effective_date