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