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_MASS_SEL_NOA dependencies on GHR_DUTY_STATIONS_V

Line 1993: FROM hr_location_extra_info lei, ghr_duty_stations_v ds

1989: AND proc_method_flag = 'Y';
1990:
1991: CURSOR get_loc_id(c_duty_station_code ghr_pa_requests.duty_station_code%type) IS
1992: SELECT lei.location_id location_id
1993: FROM hr_location_extra_info lei, ghr_duty_stations_v ds
1994: WHERE ds.duty_station_code = c_duty_station_code
1995: AND lei.information_type = 'GHR_US_LOC_INFORMATION'
1996: and to_number(lei.lei_information3) = ds.duty_station_id
1997: and l_effective_date between ds.effective_start_date