APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on PQP_GAP_ABSENCE_PLANS

Line 4792: FROM pqp_gap_absence_plans gap, pqp_gap_duration_summary glds

4788: IS
4789: SELECT gap.absence_attendance_id, glds.gap_absence_plan_id
4790: ,glds.gap_level, glds.date_start, glds.date_end
4791: ,glds.summary_type
4792: FROM pqp_gap_absence_plans gap, pqp_gap_duration_summary glds
4793: WHERE glds.gap_absence_plan_id = gap.gap_absence_plan_id
4794: AND glds.gap_duration_summary_id = p_gap_duration_summary_id;
4795:
4796: --For Bug 6972649 from here