DBA Data[Home] [Help]

APPS.HZ_GEOCODE_PKG dependencies on AR_LOOKUPS

Line 439: FROM ar_lookups al

435: p_null_ok IN VARCHAR2 DEFAULT 'Y'
436: ) RETURN VARCHAR2 IS
437: CURSOR c_validcountries IS
438: SELECT al.lookup_code
439: FROM ar_lookups al
440: WHERE al.lookup_type = 'HZ_SPATIAL_VALID_COUNTRIES'
441: AND al.lookup_code = p_country_code;
442: l_country VARCHAR2(30);
443: BEGIN