APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on PQP_GAP_DURATION_SUMMARY

Line 2135: l_table_name(i) := 'PQP_GAP_DURATION_SUMMARY';

2131: l_table_name(i) := 'PER_ABSENCE_ATTENDANCES';
2132: i := i + 1;
2133: l_table_name(i) := 'PER_PERIODS_OF_SERVICE';
2134: i := i + 1;
2135: l_table_name(i) := 'PQP_GAP_DURATION_SUMMARY';
2136:
2137: WHILE i > 0
2138: LOOP
2139: IF g_debug

Line 4738: FROM pqp_gap_absence_plans gap, pqp_gap_duration_summary glds

4734: IS
4735: SELECT gap.absence_attendance_id, glds.gap_absence_plan_id
4736: ,glds.gap_level, glds.date_start, glds.date_end
4737: ,glds.summary_type
4738: FROM pqp_gap_absence_plans gap, pqp_gap_duration_summary glds
4739: WHERE glds.gap_absence_plan_id = gap.gap_absence_plan_id
4740: AND glds.gap_duration_summary_id = p_gap_duration_summary_id;
4741:
4742: --For Bug 6972649 from here

Line 6119: ELSIF l_table_name = 'PQP_GAP_DURATION_SUMMARY'

6115: ,p_event_source => l_event_source
6116: );
6117:
6118: --For Bug 7034476: Start
6119: ELSIF l_table_name = 'PQP_GAP_DURATION_SUMMARY'
6120: THEN
6121: -- This should be a sickness/maternity transition
6122: l_gap_duration_summary_id :=
6123: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).surrogate_key);