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: --Begin Bug 10387022
149: l_rpa_type ghr_pa_requests.rpa_type%type;
150: CURSOR cur_rpa_type
151: IS

Line 170: FROM ghr_locality_pay_areas_f

166: (p_ds_loc_area_id ghr_duty_Stations_f.locality_pay_area_id%type,
167: p_eff_date ghr_pa_requests.effective_date%type)
168: IS
169: SELECT adjustment_percentage
170: FROM ghr_locality_pay_areas_f
171: WHERE locality_pay_area_id = p_ds_loc_area_id
172: AND p_eff_date between effective_start_date and effective_end_date;
173:
174: PROCEDURE Create_Remark(p_remark_code in ghr_remarks.code%TYPE,