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.

[Home] [Help]

APPS.HZ_GEO_GET_PUB dependencies on HZ_GEOGRAPHY_RANGES

Line 201: FROM hz_geography_ranges

197: -- for that zone.
198:
199: -- Bug 6842648 Perf fix to query
200: SELECT count(1) INTO l_count
201: FROM hz_geography_ranges
202: WHERE master_ref_geography_id = l_geography_id
203: AND geography_id = l_zone_id
204: AND geography_type = p_zone_type
205: AND geography_use = 'TAX'

Line 231: FROM hz_geography_ranges

227:
228: -- Bug 6842648 Perf fix to query
229: SELECT count(1)
230: INTO l_count
231: FROM hz_geography_ranges
232: WHERE geography_id = l_zone_id
233: AND master_ref_geography_id = l_geography_id
234: AND l_postal_code between geography_from and geography_to
235: AND p_date between start_date and end_date