APPS.GHR_LACS_REMARKS dependencies on GHR_DUTY_STATIONS_F

Line 146: l_loc_area_id ghr_duty_Stations_f.locality_pay_area_id%type;

142: l_adj_bp ghr_pa_requests.from_adj_basic_pay%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

Line 157: CURSOR cur_loc_area_id(p_ds_id ghr_duty_Stations_f.duty_station_id%type,

153: FROM ghr_pa_requests
154: WHERE pa_request_id =p_pa_request_id;
155: -- End Bug 10387022
156:
157: CURSOR cur_loc_area_id(p_ds_id ghr_duty_Stations_f.duty_station_id%type,
158: p_eff_date ghr_pa_requests.effective_date%type)
159: IS
160: SELECT locality_pay_area_id
161: FROM ghr_duty_stations_f

Line 161: FROM ghr_duty_stations_f

157: CURSOR cur_loc_area_id(p_ds_id ghr_duty_Stations_f.duty_station_id%type,
158: p_eff_date ghr_pa_requests.effective_date%type)
159: IS
160: SELECT locality_pay_area_id
161: FROM ghr_duty_stations_f
162: WHERE duty_station_id=p_ds_id
163: AND p_eff_date between effective_start_date and effective_end_date;
164:
165: CURSOR cur_loc_perc

Line 166: (p_ds_loc_area_id ghr_duty_Stations_f.locality_pay_area_id%type,

162: WHERE duty_station_id=p_ds_id
163: AND p_eff_date between effective_start_date and effective_end_date;
164:
165: CURSOR cur_loc_perc
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