APPS.AP_VENDOR_PUB_PKG dependencies on HZ_GEOGRAPHY_IDENTIFIERS

Line 2133: FROM HZ_GEOGRAPHY_IDENTIFIERS hgi

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));
2135:
2136: ELSE
2137: primary_state := p_state;