[Home] [Help]
61: l_Indiv_Award ghr_pa_request_extra_info.rei_information6%type;
62: --l_locality_pay_area hr_location_extra_info.lei_information4%type;
63: l_locality_pay_area ghr_locality_pay_areas_f.Locality_Pay_Area_Code%type;
64: l_Occupation_code ghr_pa_requests.to_occ_code%type;
65: -- l_Occupation_code per_position_extra_info.poei_information6%type;
66: l_One_Time_Payment_Amount ghr_pa_requests.AWARD_AMOUNT%type;
67: l_Organ_Component per_position_extra_info.poei_information5%type;
68:
69: l_pay_rate_determinant_code ghr_pa_requests.PAY_RATE_DETERMINANT%type;
63: l_locality_pay_area ghr_locality_pay_areas_f.Locality_Pay_Area_Code%type;
64: l_Occupation_code ghr_pa_requests.to_occ_code%type;
65: -- l_Occupation_code per_position_extra_info.poei_information6%type;
66: l_One_Time_Payment_Amount ghr_pa_requests.AWARD_AMOUNT%type;
67: l_Organ_Component per_position_extra_info.poei_information5%type;
68:
69: l_pay_rate_determinant_code ghr_pa_requests.PAY_RATE_DETERMINANT%type;
70: l_Personnel_Officer_ID per_position_extra_info.poei_information3%type;
71: l_Position_Occ_Code ghr_pa_requests.POSITION_OCCUPIED%type;
66: l_One_Time_Payment_Amount ghr_pa_requests.AWARD_AMOUNT%type;
67: l_Organ_Component per_position_extra_info.poei_information5%type;
68:
69: l_pay_rate_determinant_code ghr_pa_requests.PAY_RATE_DETERMINANT%type;
70: l_Personnel_Officer_ID per_position_extra_info.poei_information3%type;
71: l_Position_Occ_Code ghr_pa_requests.POSITION_OCCUPIED%type;
72: l_Prior_Basic_Pay varchar2(30); -- ghr_pa_requests.FROM_BASIC_PAY%type;
73: -- l_prior_location_id hr_locations.location_id%type
74: l_prior_duty_station ghr_duty_stations_f.Duty_Station_Code%type;
75: l_Prior_Grade_Or_Level per_grade_definitions.segment2%type;
76: l_Prior_Locality_Adj varchar2(30); --ghr_pa_requests.FROM_LOCALITY_ADJ%type;
77: l_prior_locality_pay_area ghr_locality_pay_areas_f.Locality_Pay_Area_Code%type;
78: l_Prior_Occupation_code per_job_definitions.segment1%type;
79: l_Prior_Pay_Basis per_position_extra_info.poei_information6%type;
80: l_Prior_Pay_Plan per_grade_definitions.segment1%type;
81: l_Prior_Pay_Rate_Det_Code per_assignment_extra_info.aei_information6%type;
82: l_Prior_Step_Or_Rate per_assignment_extra_info.aei_information3%type;
83: l_prior_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;
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)
107: l_Supervisory_Status_Code ghr_pa_requests.SUPERVISORY_STATUS%type;
126: l_prior_ds_effective_date ghr_pa_requests.effective_date%type;
127: ---Bug 5855843
128: l_prior_ds_effective_date_flag BOOLEAN;
129: ---Bug 5855843
130: l_org_structure_id per_position_extra_info.poei_information5%type;
131: l_update34_date date;
132: l_race_ethnic_info varchar2(30); -- Bug 4724337 Race or National Origin changes
133:
134:
297: ------------------ cursor created to handle Null Org Struct id for MRE Correction
298:
299: Cursor c_pei_null_OPM(p_position_id number) is
300: select poei_information5 l_org_structure_id
301: from per_position_extra_info
302: where information_type='GHR_US_POS_GRP1' and position_id=p_position_id;
303:
304: ----------------------------------- cursor to handle changes to LAC codes for Correction to Apptmt action 1274541
305: Cursor c_Corr_LAC_Codes(p_pa_request_id number) is