DBA Data[Home] [Help]

APPS.ZX_MERGE_LOC_CHECK_PKG dependencies on HZ_ADDRESS_USAGE_DTLS

Line 73: hz_address_usage_dtls dtl

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'
77: AND log.usage_code = 'TAX'

Line 95: hz_address_usage_dtls dtl

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'
99: AND log.usage_code = 'TAX'