APPS.GHR_CPDF_STATRPT dependencies on PER_PEOPLE_EXTRA_INFO

Line 301: l_PEOPEI_DATA PER_PEOPLE_EXTRA_INFO%ROWTYPE;

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

Line 302: l_PEOPEI_DATA_INIT PER_PEOPLE_EXTRA_INFO%ROWTYPE;

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

Line 303: l_type_of_employment per_people_extra_info.pei_information4%TYPE;

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

Line 1268: ll_per_ei_data per_people_extra_info%rowtype;

1264: l_full_name per_people_f.full_name%type;
1265: l_ssn per_people_f.national_identifier%type;
1266: l_records_found BOOLEAN;
1267: l_mesgbuff1 VARCHAR2(4000);
1268: ll_per_ei_data per_people_extra_info%rowtype;
1269: -- FWFA Changes Declare variable l_calc_pay_table_id
1270: Cursor c_pay_table_name (p_user_table_id number) is
1271: SELECT SUBSTR(user_table_name,1,4) user_table_name
1272: FROM pay_user_tables