DBA Data[Home] [Help]

APPS.GHR_PER_SUM dependencies on HR_LOCATION_EXTRA_INFO

Line 431: ,hr_location_extra_info lei

427: ,lpa.adjustment_percentage
428: FROM ghr_locality_pay_areas_f lpa
429: ,ghr_duty_stations_v dstv
430: ,ghr_duty_stations_f dst
431: ,hr_location_extra_info lei
432: WHERE lei.location_id = p_location_id
433: AND lei.information_type = 'GHR_US_LOC_INFORMATION'
434: AND dst.duty_station_id = lei.lei_information3
435: AND NVL(p_effective_date,TRUNC(sysdate)) BETWEEN dst.effective_start_date AND dst.effective_end_date