APPS.AP_VENDOR_PUB_PKG dependencies on HZ_GEOGRAPHIES

Line 2130: FROM HZ_GEOGRAPHIES hg

2126: IF (UPPER(p_country) = 'US') THEN
2127:
2128: SELECT hg.GEOGRAPHY_NAME
2129: INTO primary_state
2130: FROM HZ_GEOGRAPHIES hg
2131: WHERE hg.COUNTRY_CODE='US' AND hg.GEOGRAPHY_ID IN
2132: (SELECT hgi.GEOGRAPHY_ID
2133: FROM HZ_GEOGRAPHY_IDENTIFIERS hgi
2134: WHERE hgi.GEOGRAPHY_TYPE ='STATE' AND UPPER(hgi.IDENTIFIER_VALUE) = UPPER(p_state));