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.HZ_GEO_UI_UTIL_PUB dependencies on HZ_LOCATIONS

Line 564: from hz_locations loc

560: is
561: select 'Y'
562: from hz_geo_name_reference_log geo
563: where exists ( select 'Y'
564: from hz_locations loc
565: where loc.country = ll_country_code
566: AND geo.location_id = loc.location_id)
567: and location_table_name = 'HZ_LOCATIONS'
568: and rownum = 1; --bug 6870808

Line 567: and location_table_name = 'HZ_LOCATIONS'

563: where exists ( select 'Y'
564: from hz_locations loc
565: where loc.country = ll_country_code
566: AND geo.location_id = loc.location_id)
567: and location_table_name = 'HZ_LOCATIONS'
568: and rownum = 1; --bug 6870808
569:
570: cursor hr_cur(ll_country_code in varchar2)
571: is

Line 593: if(p_loc_table_name = 'HZ_LOCATIONS')

589: close geo_cur;
590: if( l_country_code is not null)
591: then
592: -- check if gnr data exists
593: if(p_loc_table_name = 'HZ_LOCATIONS')
594: then
595: open hz_cur(l_country_code);
596: fetch hz_cur into l_value;
597: close hz_cur;