APPS.GHR_PAY_CAPS dependencies on GHR_DUTY_STATIONS_F
Line 464: FROM ghr_duty_stations_f ds, ghr_locality_pay_areas_f lc
460: --Bug 13414643,13403289
461: CURSOR get_locality_pay_area
462: IS
463: SELECT lc.locality_pay_area_code 464: FROM ghr_duty_stations_f ds, ghr_locality_pay_areas_f lc 465: WHERE ds.duty_station_id = p_duty_station_id
466: AND ds.locality_pay_area_id = lc.locality_pay_area_id
467: AND p_effective_date between ds.effective_start_date and ds.effective_end_date
468: AND p_effective_date between lc.effective_start_date and lc.effective_end_date;