DBA Data[Home] [Help]

APPS.HZ_GNR_PVT dependencies on HZ_ADDRESS_USAGES

Line 4043: ,hz_address_usages hau

4039: IS
4040: SELECT haud.geography_type
4041: FROM hz_geo_struct_map smap
4042: ,hz_geo_struct_map_dtl dmap
4043: ,hz_address_usages hau
4044: ,hz_address_usage_dtls haud
4045: WHERE smap.address_style = ll_address_style
4046: AND SMAP.country_code = ll_country_code
4047: AND SMAP.loc_tbl_name = ll_table_name

Line 4062: ,hz_address_usages hau

4058: IS
4059: SELECT haud.geography_type
4060: FROM hz_geo_struct_map smap
4061: ,hz_geo_struct_map_dtl dmap
4062: ,hz_address_usages hau
4063: ,hz_address_usage_dtls haud
4064: WHERE smap.address_style IS NULL
4065: AND SMAP.country_code = ll_country_code
4066: AND SMAP.loc_tbl_name = ll_table_name