APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on PQP_GAP_DURATION_SUMMARY

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

2149: l_table_name(i) := 'PER_ABSENCE_ATTENDANCES';
2150: i := i + 1;
2151: l_table_name(i) := 'PER_PERIODS_OF_SERVICE';
2152: i := i + 1;
2153: l_table_name(i) := 'PQP_GAP_DURATION_SUMMARY';
2154:
2155: WHILE i > 0
2156: LOOP
2157: IF g_debug

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

Line 6181: ELSIF l_table_name = 'PQP_GAP_DURATION_SUMMARY'

6177: ,p_event_source => l_event_source
6178: );
6179:
6180: --For Bug 7034476: Start
6181: ELSIF l_table_name = 'PQP_GAP_DURATION_SUMMARY'
6182: THEN
6183: -- This should be a sickness/maternity transition
6184: l_gap_duration_summary_id :=
6185: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).surrogate_key);