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:
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)

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

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
152: SELECT locality_pay_area_id
153: FROM ghr_duty_stations_f

Line 153: FROM ghr_duty_stations_f

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
152: SELECT locality_pay_area_id
153: FROM ghr_duty_stations_f
154: WHERE duty_station_id=p_ds_id
155: AND p_eff_date between effective_start_date and effective_end_date;
156:
157: CURSOR cur_loc_perc

Line 158: (p_ds_loc_area_id ghr_duty_Stations_f.locality_pay_area_id%type,

154: WHERE duty_station_id=p_ds_id
155: AND p_eff_date between effective_start_date and effective_end_date;
156:
157: CURSOR cur_loc_perc
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