DBA Data[Home] [Help]

APPS.GHR_MASS_AWARDS_ELIG dependencies on HR_LOCATION_EXTRA_INFO

Line 102: from hr_location_extra_info lei

98: Select dsf.duty_station_code
99: from ghr_duty_stations_f dsf
100: where dsf.duty_station_id =
101: (select lei.lei_information3
102: from hr_location_extra_info lei
103: where lei.location_id = l_loc_id
104: )
105: and l_effective_date
106: between dsf.effective_start_date