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 118: FROM hz_geo_name_references

114: -- done for this location
115: -- Bug 6842648 Perf fix to query
116: SELECT count(1)
117: INTO l_gnr_count
118: FROM hz_geo_name_references
119: WHERE location_table_name = p_location_table_name
120: AND location_id = p_location_id
121: AND rownum = 1;
122:

Line 145: -- find the geography id from hz_geo_name_references

141: IF l_ref_geo_type = 'COUNTRY' THEN
142: l_country_found := 'Y';
143: END IF;
144:
145: -- find the geography id from hz_geo_name_references
146: BEGIN
147: SELECT geography_id
148: INTO l_geography_id
149: FROM hz_geo_name_references

Line 149: FROM hz_geo_name_references

145: -- find the geography id from hz_geo_name_references
146: BEGIN
147: SELECT geography_id
148: INTO l_geography_id
149: FROM hz_geo_name_references
150: WHERE location_table_name = p_location_table_name
151: AND location_id = p_location_id
152: AND geography_type = l_ref_geo_type;
153: