APPS.GHR_EHRI_DYNRPT dependencies on PER_PEOPLE_EXTRA_INFO

Line 505: l_per_ei_grp1_data per_people_extra_info%rowtype;

501: l_information_type ghr_pa_request_extra_info.information_type%TYPE;
502: l_rei ghr_pa_request_extra_info%ROWTYPE;
503: l_race_national_origin VARCHAR2(150);
504: l_handicap_code VARCHAR2(150);
505: l_per_ei_grp1_data per_people_extra_info%rowtype;
506:
507: l_leave_scd DATE;
508: l_tsp_scd DATE;
509: l_ehri_employee_id ghr_cpdf_temp.ehri_employee_id%TYPE;

Line 799: l_per_ei_grp1_data per_people_extra_info%rowtype;

795: IS
796: --
797: l_information_type ghr_pa_request_extra_info.information_type%TYPE;
798: l_rei ghr_pa_request_extra_info%ROWTYPE;
799: l_per_ei_grp1_data per_people_extra_info%rowtype;
800: l_appt_nte_date DATE;
801: --per_assignment_extra_info.aei_information4%TYPE;
802: --
803: CURSOR get_asg_id(p_request_id NUMBER,

Line 2448: ll_per_ei_data per_people_extra_info%rowtype;

2444: l_scd_retirement ghr_pa_request_extra_info.rei_information8%type;
2445: l_scd_tsp ghr_pa_request_extra_info.rei_information8%type;
2446: l_scd_leave ghr_pa_request_extra_info.rei_information8%type;
2447: l_ehri_id ghr_cpdf_temp.ehri_employee_id%TYPE;
2448: ll_per_ei_data per_people_extra_info%rowtype;
2449: l_last_name per_all_people.last_name%type;
2450: l_suffix ghr_cpdf_temp.prior_name_suffix%type;
2451:
2452: -- For Dual Actions PRD is becoming null so preserving it using a local variable.