APPS.ZX_MERGE_LOC_CHECK_PKG dependencies on HZ_ADDRESS_USAGES

Line 40: FROM hz_geo_struct_map map, hz_locations loc, hz_address_usages usage

36: x_merge_yn := 'N';
37: BEGIN
38: SELECT 'TRUE'
39: INTO l_from_tax_usage_exists
40: FROM hz_geo_struct_map map, hz_locations loc, hz_address_usages usage
41: WHERE map.country_code = loc.country
42: AND map.loc_tbl_name = 'HZ_LOCATIONS'
43: AND nvl(map.address_style,'1') = nvl(loc.address_style,'1')
44: AND map.map_id = usage.map_id

Line 54: FROM hz_geo_struct_map map, hz_locations loc, hz_address_usages usage

50:
51: BEGIN
52: SELECT 'TRUE'
53: INTO l_to_tax_usage_exists
54: FROM hz_geo_struct_map map, hz_locations loc, hz_address_usages usage
55: WHERE map.country_code = loc.country
56: AND map.loc_tbl_name = 'HZ_LOCATIONS'
57: AND nvl(map.address_style,'1') = nvl(loc.address_style,'1')
58: AND map.map_id = usage.map_id

Line 72: hz_address_usages usage,

68: FROM hz_geo_name_references gnr,
69: hz_geo_name_reference_log log,
70: hz_geo_struct_map map,
71: hz_locations loc,
72: hz_address_usages usage,
73: hz_address_usage_dtls dtl
74: WHERE gnr.location_id = p_from_location_id
75: AND gnr.location_id = log.location_id
76: AND log.map_status = 'S'

Line 94: hz_address_usages usage,

90: FROM hz_geo_name_references gnr,
91: hz_geo_name_reference_log log,
92: hz_geo_struct_map map,
93: hz_locations loc,
94: hz_address_usages usage,
95: hz_address_usage_dtls dtl
96: WHERE gnr.location_id = p_to_location_id
97: AND gnr.location_id = log.location_id
98: AND log.map_status = 'S'