DBA Data[Home] [Help]

APPS.HZ_GEOCODE_PKG dependencies on AR_LOOKUPS

Line 447: FROM ar_lookups al

443: p_null_ok IN VARCHAR2 DEFAULT 'Y'
444: ) RETURN VARCHAR2 IS
445: CURSOR c_validcountries IS
446: SELECT al.lookup_code
447: FROM ar_lookups al
448: WHERE al.lookup_type = 'HZ_SPATIAL_VALID_COUNTRIES'
449: AND al.lookup_code = p_country_code;
450: l_country VARCHAR2(30);
451: BEGIN