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_GET_PUB dependencies on HZ_GEO_NAME_REFERENCES

Line 147: FROM hz_geo_name_references

143: -- done for this location
144: -- Bug 6842648 Perf fix to query
145: SELECT count(1)
146: INTO l_gnr_count
147: FROM hz_geo_name_references
148: WHERE location_table_name = p_location_table_name
149: AND location_id = p_location_id
150: AND rownum = 1;
151:

Line 179: -- find the geography id from hz_geo_name_references

175: IF l_ref_geo_type = 'COUNTRY' THEN
176: l_country_found := 'Y';
177: END IF;
178:
179: -- find the geography id from hz_geo_name_references
180: BEGIN
181: SELECT geography_id
182: INTO l_geography_id
183: FROM hz_geo_name_references

Line 183: FROM hz_geo_name_references

179: -- find the geography id from hz_geo_name_references
180: BEGIN
181: SELECT geography_id
182: INTO l_geography_id
183: FROM hz_geo_name_references
184: WHERE location_table_name = p_location_table_name
185: AND location_id = p_location_id
186: AND geography_type = l_ref_geo_type;
187: