DBA Data[Home] [Help]

APPS.HZ_GNR_PVT dependencies on HZ_ADDRESS_USAGE_DTLS

Line 4138: ,hz_address_usage_dtls haud

4134: SELECT haud.geography_type
4135: FROM hz_geo_struct_map smap
4136: ,hz_geo_struct_map_dtl dmap
4137: ,hz_address_usages hau
4138: ,hz_address_usage_dtls haud
4139: WHERE smap.address_style = ll_address_style
4140: AND SMAP.country_code = ll_country_code
4141: AND SMAP.loc_tbl_name = ll_table_name
4142: AND smap.map_id = dmap.map_id

Line 4157: ,hz_address_usage_dtls haud

4153: SELECT haud.geography_type
4154: FROM hz_geo_struct_map smap
4155: ,hz_geo_struct_map_dtl dmap
4156: ,hz_address_usages hau
4157: ,hz_address_usage_dtls haud
4158: WHERE smap.address_style IS NULL
4159: AND SMAP.country_code = ll_country_code
4160: AND SMAP.loc_tbl_name = ll_table_name
4161: AND smap.map_id = dmap.map_id