APPS.GHR_EHRI_DYNRPT dependencies on PER_PEOPLE_EXTRA_INFO

Line 507: l_per_ei_grp1_data per_people_extra_info%rowtype;

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

Line 803: l_per_ei_grp1_data per_people_extra_info%rowtype;

799: IS
800: --
801: l_information_type ghr_pa_request_extra_info.information_type%TYPE;
802: l_rei ghr_pa_request_extra_info%ROWTYPE;
803: l_per_ei_grp1_data per_people_extra_info%rowtype;
804: l_appt_nte_date DATE;
805: --per_assignment_extra_info.aei_information4%TYPE;
806: --
807: CURSOR get_asg_id(p_request_id NUMBER,

Line 2602: ll_per_ei_data per_people_extra_info%rowtype;

2598: l_scd_retirement ghr_pa_request_extra_info.rei_information8%type;
2599: l_scd_tsp ghr_pa_request_extra_info.rei_information8%type;
2600: l_scd_leave ghr_pa_request_extra_info.rei_information8%type;
2601: l_ehri_id ghr_cpdf_temp.ehri_employee_id%TYPE;
2602: ll_per_ei_data per_people_extra_info%rowtype;
2603: l_last_name per_all_people.last_name%type;
2604: l_suffix ghr_cpdf_temp.prior_name_suffix%type;
2605:
2606: -- For Dual Actions PRD is becoming null so preserving it using a local variable.