APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on BEN_EXT_PERSON

Line 177: g_event_counter := ben_ext_person.g_pay_proc_evt_tab.FIRST;

173: l_proc_step := 10;
174: debug_enter(l_proc_name);
175: END IF;
176:
177: g_event_counter := ben_ext_person.g_pay_proc_evt_tab.FIRST;
178: g_min_effective_date := NULL;
179: g_min_eff_date_exists := 'N';
180:
181: IF g_debug

Line 5902: l_tab_pay_proc_evnts ben_ext_person.t_detailed_output_table;

5898: := g_proc_name || 'chk_ser_periodic_criteria';
5899: l_proc_step PLS_INTEGER;
5900: l_include_flag VARCHAR2(10);
5901: i NUMBER;
5902: l_tab_pay_proc_evnts ben_ext_person.t_detailed_output_table;
5903: l_latest_start_date DATE;
5904: l_rec_asg_details r_asg_details;
5905: l_ser_start_date DATE;
5906: l_start_reason VARCHAR2(10);

Line 5953: l_tab_pay_proc_evnts := ben_ext_person.g_pay_proc_evt_tab;

5949: DEBUG('p_assignment_id: ' || p_assignment_id);
5950: END IF;
5951:
5952: l_include_flag := 'N';
5953: l_tab_pay_proc_evnts := ben_ext_person.g_pay_proc_evt_tab;
5954:
5955: IF l_tab_pay_proc_evnts.COUNT > 0
5956: THEN
5957: IF g_debug

Line 7061: -- ben_ext_person.g_pay_proc_evt_tab.NEXT(g_event_counter);

7057: clear_per_cache;
7058: g_person_id := g_assignment_dtl.person_id;
7059: -- ELSE
7060: -- g_event_counter :=
7061: -- ben_ext_person.g_pay_proc_evt_tab.NEXT(g_event_counter);
7062: END IF;
7063:
7064: IF g_debug
7065: THEN

Line 7089: g_event_counter := ben_ext_person.g_chg_pay_evt_index;

7085: l_include_flag := 'Y';
7086: ELSIF g_extract_type = 'PERIODIC'
7087: THEN
7088: -- Set counter index to pay evt index
7089: g_event_counter := ben_ext_person.g_chg_pay_evt_index;
7090:
7091: IF g_debug
7092: THEN
7093: l_proc_step := 80;

Line 7102: -- IF g_event_counter = ben_ext_person.g_pay_proc_evt_tab.LAST

7098: l_include_flag :=
7099: chk_ser_periodic_criteria(p_assignment_id => p_assignment_id);
7100: -- get_asg_ser_periodic_data (p_assignment_id => p_assignment_id);
7101: -- Call process retro event for the last counter
7102: -- IF g_event_counter = ben_ext_person.g_pay_proc_evt_tab.LAST
7103: -- THEN
7104: -- IF g_debug
7105: -- THEN
7106: -- l_proc_step := 90;

Line 7108: -- DEBUG('Last Counter: ' || ben_ext_person.g_pay_proc_evt_tab.LAST);

7104: -- IF g_debug
7105: -- THEN
7106: -- l_proc_step := 90;
7107: -- DEBUG(l_proc_name, l_proc_step);
7108: -- DEBUG('Last Counter: ' || ben_ext_person.g_pay_proc_evt_tab.LAST);
7109: -- DEBUG('g_event_counter: ' || g_event_counter);
7110: -- END IF;
7111: pqp_gb_psi_functions.process_retro_event;
7112: -- END IF; -- End if of event counter is last check ...