DBA Data[Home] [Help]

APPS.ZX_MERGE_LOC_CHECK_PKG dependencies on HZ_GEO_NAME_REFERENCES

Line 68: FROM hz_geo_name_references gnr,

64:
65: IF l_from_tax_usage_exists = 'TRUE' and l_to_tax_usage_exists = 'TRUE' THEN
66: SELECT gnr.geography_id, gnr.geography_type
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,

Line 90: FROM hz_geo_name_references gnr,

86: ORDER BY gnr.geography_id;
87:
88: SELECT gnr.geography_id, gnr.geography_type
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,