APPS.PQP_GB_PSI_HRS_HISTORY dependencies on BEN_EXT_PERSON

Line 1033: l_rec_abv_dtls.effective_end_date <= ben_ext_person.g_effective_date

1029: l_include_flag := 'Y';
1030: g_start_date := l_rec_abv_dtls.effective_start_date;
1031:
1032: IF l_rec_abv_dtls.effective_end_date <> hr_api.g_eot AND
1033: l_rec_abv_dtls.effective_end_date <= ben_ext_person.g_effective_date
1034: THEN
1035: g_end_date := l_rec_abv_dtls.effective_end_date;
1036: END IF; -- end date not eot check ...
1037:

Line 1146: l_rec_abv_dtls.effective_end_date <= ben_ext_person.g_effective_date

1142: l_include_flag := 'Y';
1143: g_start_date := l_rec_abv_dtls.effective_start_date;
1144:
1145: IF l_rec_abv_dtls.effective_end_date <> hr_api.g_eot AND
1146: l_rec_abv_dtls.effective_end_date <= ben_ext_person.g_effective_date
1147: THEN
1148: g_end_date := l_rec_abv_dtls.effective_end_date;
1149: END IF; -- end date not eot check ...
1150:

Line 1223: l_tab_pay_proc_evnts ben_ext_person.t_detailed_output_table;

1219: l_include_flag VARCHAR2(10);
1220: l_rec_abv_dtls csr_abv_dtls%ROWTYPE;
1221: l_ft_hours NUMBER;
1222: l_pt_hours NUMBER;
1223: l_tab_pay_proc_evnts ben_ext_person.t_detailed_output_table;
1224: l_event_group_id NUMBER;
1225: l_event_group_name pay_event_groups.event_group_name%TYPE;
1226: l_dated_table_id NUMBER;
1227: l_table_name pay_dated_tables.table_name%TYPE;

Line 1248: l_tab_pay_proc_evnts := ben_ext_person.g_pay_proc_evt_tab;

1244: END IF;
1245:
1246: l_include_flag := 'N';
1247:
1248: l_tab_pay_proc_evnts := ben_ext_person.g_pay_proc_evt_tab;
1249:
1250: IF l_tab_pay_proc_evnts.COUNT > 0
1251: THEN
1252: IF g_debug

Line 1820: g_event_counter := ben_ext_person.g_chg_pay_evt_index;

1816: g_pt_hours := NULL;
1817: g_ft_hours := NULL;
1818: g_hours_type := NULL;
1819: g_effective_date := p_effective_date;
1820: g_event_counter := ben_ext_person.g_chg_pay_evt_index;
1821:
1822:
1823: -- Check penserver basic criteria
1824: IF g_debug