DBA Data[Home] [Help]

APPS.ZX_MERGE_LOC_CHECK_PKG dependencies on HZ_GEO_NAME_REFERENCE_LOG

Line 69: hz_geo_name_reference_log log,

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,
73: hz_address_usage_dtls dtl

Line 91: hz_geo_name_reference_log log,

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,
95: hz_address_usage_dtls dtl