DBA Data[Home] [Help]

APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on PQP_GAP_DURATION_SUMMARY

Line 159: FROM pqp_gap_absence_plans gap, pqp_gap_duration_summary glds

155: )
156: IS
157: SELECT glds.gap_absence_plan_id, glds.gap_level, glds.date_start
158: ,glds.date_end
159: FROM pqp_gap_absence_plans gap, pqp_gap_duration_summary glds
160: WHERE glds.gap_absence_plan_id = gap.gap_absence_plan_id
161: AND glds.assignment_id = c_assignment_id
162: AND glds.summary_type = 'PAY'
163: AND gap.absence_attendance_id = c_absence_attendance_id