[Home] [Help]
69: l_ap_amount number;
70: l_auo_amount number;
71: l_exists boolean;
72: l_noa_family_code ghr_families.noa_family_code%type;
73: l_to_agency_code per_people_extra_info.pei_information8%type;
74: l_to_supervisor_diff ghr_pa_requests.TO_SUPERVISORY_DIFFERENTIAL%type ;
75: l_award_salary ghr_pa_requests.from_basic_pay%type ; -- Bug 3376761
76:
77: l_slr_recur_amount number;
93: l_null_list varchar2(2000);
94: l_new_line VARCHAR2(1) := substr('
95: ',1,1);
96: -- Bug#5036370
97: l_serv_oblig_code per_people_extra_info.pei_information3%type;
98: l_serv_oblig_stdt DATE;
99: l_serv_oblig_enddt DATE;
100: --Open Pay Range variables.
101: l_row_high number;
200: SELECT rei_information3 temp_step
201: FROM ghr_pa_request_extra_info
202: WHERE pa_request_id = p_pa_request_rec.pa_request_id
203: AND information_type = 'GHR_US_PAR_RG_TEMP_PROMO';
204: l_temp_step per_people_extra_info.pei_information9%type := hr_api.g_varchar2;
205:
206: -- Family Code
207: -- Bug # 1145963
208: -- Bug#3941541 Added effective date condition.
421: WHERE grd.grade_id = p_grade_id
422: AND grd.grade_definition_id = gdf.grade_definition_id;
423: --End of 3604377
424:
425: l_appt_type PER_PEOPLE_EXTRA_INFO.pei_information3%type;
426: l_ele_name pay_element_types_f.element_name%type;
427: l_ele_end_date pay_element_entries_f.effective_end_date%type;
428:
429: l_per_ei_data PER_PEOPLE_EXTRA_INFO%rowtype;
425: l_appt_type PER_PEOPLE_EXTRA_INFO.pei_information3%type;
426: l_ele_name pay_element_types_f.element_name%type;
427: l_ele_end_date pay_element_entries_f.effective_end_date%type;
428:
429: l_per_ei_data PER_PEOPLE_EXTRA_INFO%rowtype;
430: -- Bug#3928110
431: --l_percent NUMBER(8,2);
432:
433: l_max_allowed_amount NUMBER;