DBA Data[Home] [Help]

APPS.HZ_GNR_PVT dependencies on HZ_ADDRESS_USAGES

Line 4137: ,hz_address_usages hau

4133: IS
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

Line 4156: ,hz_address_usages hau

4152: IS
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