APPS.ZX_MERGE_LOC_CHECK_PKG dependencies on HZ_LOCATIONS

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 42: AND map.loc_tbl_name = 'HZ_LOCATIONS'

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
45: AND usage.usage_code = 'TAX'
46: AND loc.location_id = p_from_location_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 56: AND map.loc_tbl_name = 'HZ_LOCATIONS'

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
59: AND usage.usage_code = 'TAX'
60: AND loc.location_id = p_to_location_id;

Line 71: hz_locations loc,

67: BULK COLLECT INTO l_from_geography_id_tbl, l_from_geography_type_tbl
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

Line 80: AND map.loc_tbl_name = 'HZ_LOCATIONS'

76: AND log.map_status = 'S'
77: AND log.usage_code = 'TAX'
78: AND loc.location_id = gnr.location_id
79: AND map.country_code = loc.country
80: AND map.loc_tbl_name = 'HZ_LOCATIONS'
81: AND nvl(map.address_style,'1') = nvl(loc.address_style,'1')
82: AND map.map_id = usage.map_id
83: AND usage.usage_code = 'TAX'
84: AND dtl.usage_id = usage.usage_id

Line 93: hz_locations loc,

89: BULK COLLECT INTO l_to_geography_id_tbl, l_to_geography_type_tbl
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

Line 102: AND map.loc_tbl_name = 'HZ_LOCATIONS'

98: AND log.map_status = 'S'
99: AND log.usage_code = 'TAX'
100: AND loc.location_id = gnr.location_id
101: AND map.country_code = loc.country
102: AND map.loc_tbl_name = 'HZ_LOCATIONS'
103: AND nvl(map.address_style,'1') = nvl(loc.address_style,'1')
104: AND map.map_id = usage.map_id
105: AND usage.usage_code = 'TAX'
106: AND dtl.usage_id = usage.usage_id

Line 151: FROM hz_locations loc

147:
148: ELSIF l_from_tax_usage_exists = 'FALSE' and l_to_tax_usage_exists = 'FALSE' THEN
149: SELECT country
150: INTO l_from_country_code
151: FROM hz_locations loc
152: WHERE loc.location_id = p_from_location_id;
153:
154: SELECT country
155: INTO l_to_country_code

Line 156: FROM hz_locations loc

152: WHERE loc.location_id = p_from_location_id;
153:
154: SELECT country
155: INTO l_to_country_code
156: FROM hz_locations loc
157: WHERE loc.location_id = p_to_location_id;
158:
159: IF l_from_country_code <> l_to_country_code THEN
160: x_merge_yn := 'N';