eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_MTO_INT dependencies on GHR_DUTY_STATIONS_V

Line 4109: FROM hr_location_extra_info lei, ghr_duty_stations_v ds

4105: and p.effective_end_date;
4106:
4107: cursor cur_lei(p_location_id number) is
4108: select ds.duty_station_desc, ds.duty_station_code
4109: FROM hr_location_extra_info lei, ghr_duty_stations_v ds
4110: WHERE lei.location_id = p_location_id
4111: AND lei.information_type = 'GHR_US_LOC_INFORMATION'
4112: and to_number(lei.lei_information3) = ds.duty_station_id
4113: and trunc(l_effdate) between ds.effective_start_date