DBA Data[Home] [Help]

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;