APPS.GHR_LACS_REMARKS dependencies on GHR_LOCALITY_PAY_AREAS_F

Line 8: g_loc_percentage ghr_locality_pay_areas_f.adjustment_percentage%TYPE;

4: g_position_id ghr_pa_requests.from_position_id%TYPE;
5: g_pay_plan ghr_pa_requests.from_step_or_rate%TYPE;
6: g_step_or_rate ghr_pa_requests.from_pay_plan%TYPE;
7: g_grade_or_level ghr_pa_requests.from_grade_or_level%TYPE;
8: g_loc_percentage ghr_locality_pay_areas_f.adjustment_percentage%TYPE;
9: -- Added for MSL expanded func
10: g_pay_table_id VARCHAR2(4);
11: g_new_prd VARCHAR2(10);
12: g_leo_posn_indicator per_position_extra_info.poei_information16%TYPE;

Line 147: l_loc_perc ghr_locality_pay_areas_f.adjustment_percentage%TYPE;

143: l_pay_cap_amount ghr_pa_requests.from_adj_basic_pay%type;
144: l_create_rmk BOOLEAN:=FALSE;
145: l_remark_id ghr_pa_remarks.pa_remark_id%type;
146: l_loc_area_id ghr_duty_Stations_f.locality_pay_area_id%type;
147: l_loc_perc ghr_locality_pay_areas_f.adjustment_percentage%TYPE;
148:
149: CURSOR cur_loc_area_id(p_ds_id ghr_duty_Stations_f.duty_station_id%type,
150: p_eff_date ghr_pa_requests.effective_date%type)
151: IS

Line 162: FROM ghr_locality_pay_areas_f

158: (p_ds_loc_area_id ghr_duty_Stations_f.locality_pay_area_id%type,
159: p_eff_date ghr_pa_requests.effective_date%type)
160: IS
161: SELECT adjustment_percentage
162: FROM ghr_locality_pay_areas_f
163: WHERE locality_pay_area_id = p_ds_loc_area_id
164: AND p_eff_date between effective_start_date and effective_end_date;
165:
166: PROCEDURE Create_Remark(p_remark_code in ghr_remarks.code%TYPE,