APPS.GHR_CPDF_STATRPT dependencies on PER_PEOPLE_EXTRA_INFO

Line 305: l_PEOPEI_DATA PER_PEOPLE_EXTRA_INFO%ROWTYPE;

301: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
302: )
303: IS
304: l_proc varchar2(30) := 'get_from_history_peopei';
305: l_PEOPEI_DATA PER_PEOPLE_EXTRA_INFO%ROWTYPE;
306: l_PEOPEI_DATA_INIT PER_PEOPLE_EXTRA_INFO%ROWTYPE;
307: l_type_of_employment per_people_extra_info.pei_information4%TYPE;
308: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
309: BEGIN

Line 306: l_PEOPEI_DATA_INIT PER_PEOPLE_EXTRA_INFO%ROWTYPE;

302: )
303: IS
304: l_proc varchar2(30) := 'get_from_history_peopei';
305: l_PEOPEI_DATA PER_PEOPLE_EXTRA_INFO%ROWTYPE;
306: l_PEOPEI_DATA_INIT PER_PEOPLE_EXTRA_INFO%ROWTYPE;
307: l_type_of_employment per_people_extra_info.pei_information4%TYPE;
308: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
309: BEGIN
310: hr_utility.set_location('Entering:'||l_proc,5);

Line 307: l_type_of_employment per_people_extra_info.pei_information4%TYPE;

303: IS
304: l_proc varchar2(30) := 'get_from_history_peopei';
305: l_PEOPEI_DATA PER_PEOPLE_EXTRA_INFO%ROWTYPE;
306: l_PEOPEI_DATA_INIT PER_PEOPLE_EXTRA_INFO%ROWTYPE;
307: l_type_of_employment per_people_extra_info.pei_information4%TYPE;
308: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
309: BEGIN
310: hr_utility.set_location('Entering:'||l_proc,5);
311:

Line 1303: ll_per_ei_data per_people_extra_info%rowtype;

1299: l_full_name per_people_f.full_name%type;
1300: l_ssn per_people_f.national_identifier%type;
1301: l_records_found BOOLEAN;
1302: l_mesgbuff1 VARCHAR2(4000);
1303: ll_per_ei_data per_people_extra_info%rowtype;
1304: -- FWFA Changes Declare variable l_calc_pay_table_id
1305: Cursor c_pay_table_name (p_user_table_id number) is
1306: SELECT SUBSTR(user_table_name,1,4) user_table_name
1307: FROM pay_user_tables