[Home] [Help]
42: l_Duty_Station_ID hr_location_extra_info.lei_information3%type;
43: l_Duty_Station_Lookup_Code ghr_duty_stations_f.Duty_Station_Code%type;
44: l_education_level ghr_pa_requests.EDUCATION_LEVEL%type;
45: l_effective_date ghr_pa_requests.EFFECTIVE_DATE%type;
46: l_Employee_Date_of_Birth per_people_f.date_of_birth%type;
47: l_Employee_First_Name ghr_pa_requests.EMPLOYEE_FIRST_NAME%type;
48: l_Employee_Last_Name ghr_pa_requests.EMPLOYEE_LAST_NAME%type;
49: l_employee_National_ID per_people_f.national_identifier%type;
50: l_fegli_code ghr_pa_requests.FEGLI%type;
45: l_effective_date ghr_pa_requests.EFFECTIVE_DATE%type;
46: l_Employee_Date_of_Birth per_people_f.date_of_birth%type;
47: l_Employee_First_Name ghr_pa_requests.EMPLOYEE_FIRST_NAME%type;
48: l_Employee_Last_Name ghr_pa_requests.EMPLOYEE_LAST_NAME%type;
49: l_employee_National_ID per_people_f.national_identifier%type;
50: l_fegli_code ghr_pa_requests.FEGLI%type;
51: l_fers_coverage per_people_extra_info.pei_information3%type;
52: l_First_Action_NOA_LA_Code1 ghr_pa_requests.FIRST_ACTION_LA_CODE1%type;
53: l_First_Action_NOA_LA_Code2 ghr_pa_requests.FIRST_ACTION_LA_CODE2%type;
98: --Bug# 11726461
99: l_scd_leave date;
100: l_scd_retirement date;
101: --Bug# 11726461
102: l_Sex per_people_f.sex%type;
103: l_special_pay_table_id per_position_extra_info.poei_information5%type;
104: l_staffing_differential varchar2(30); -- ghr_pa_requests.TO_STAFFING_DIFFERENTIAL%type; --number(15,2)
105: l_submission_date date;
106: l_supervisory_differential varchar2(30); -- ghr_pa_requests.TO_SUPERVISORY_DIFFERENTIAL%type; --number(15,2)