APPS.GHR_GHRWS52L dependencies on PER_PEOPLE_F

Line 45: l_Employee_Date_of_Birth per_people_f.date_of_birth%type;

41: l_Duty_Station_ID hr_location_extra_info.lei_information3%type;
42: l_Duty_Station_Lookup_Code ghr_duty_stations_f.Duty_Station_Code%type;
43: l_education_level ghr_pa_requests.EDUCATION_LEVEL%type;
44: l_effective_date ghr_pa_requests.EFFECTIVE_DATE%type;
45: l_Employee_Date_of_Birth per_people_f.date_of_birth%type;
46: l_Employee_First_Name ghr_pa_requests.EMPLOYEE_FIRST_NAME%type;
47: l_Employee_Last_Name ghr_pa_requests.EMPLOYEE_LAST_NAME%type;
48: l_employee_National_ID per_people_f.national_identifier%type;
49: l_fegli_code ghr_pa_requests.FEGLI%type;

Line 48: l_employee_National_ID per_people_f.national_identifier%type;

44: l_effective_date ghr_pa_requests.EFFECTIVE_DATE%type;
45: l_Employee_Date_of_Birth per_people_f.date_of_birth%type;
46: l_Employee_First_Name ghr_pa_requests.EMPLOYEE_FIRST_NAME%type;
47: l_Employee_Last_Name ghr_pa_requests.EMPLOYEE_LAST_NAME%type;
48: l_employee_National_ID per_people_f.national_identifier%type;
49: l_fegli_code ghr_pa_requests.FEGLI%type;
50: l_fers_coverage per_people_extra_info.pei_information3%type;
51: l_First_Action_NOA_LA_Code1 ghr_pa_requests.FIRST_ACTION_LA_CODE1%type;
52: l_First_Action_NOA_LA_Code2 ghr_pa_requests.FIRST_ACTION_LA_CODE2%type;

Line 97: l_Sex per_people_f.sex%type;

93: l_Retirement_Plan_Code ghr_pa_requests.RETIREMENT_PLAN%type;
94: l_Retention_Allowance varchar2(30); -- ghr_pa_requests.TO_RETENTION_ALLOWANCE%type; --number(15,2)
95: l_Second_NOAC_Lookup_code ghr_pa_requests.SECOND_NOA_CODE%type;
96: l_Service_Computation_Date ghr_pa_requests.SERVICE_COMP_DATE%type;
97: l_Sex per_people_f.sex%type;
98: l_special_pay_table_id per_position_extra_info.poei_information5%type;
99: l_staffing_differential varchar2(30); -- ghr_pa_requests.TO_STAFFING_DIFFERENTIAL%type; --number(15,2)
100: l_submission_date date;
101: l_supervisory_differential varchar2(30); -- ghr_pa_requests.TO_SUPERVISORY_DIFFERENTIAL%type; --number(15,2)