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 HR_LOCATION_EXTRA_INFO

Line 4108: FROM hr_location_extra_info lei, ghr_duty_stations_v ds

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