APPS.HZ_GEOCODE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 438

      SELECT al.lookup_code
      FROM   ar_lookups al
      WHERE  al.lookup_type = 'HZ_SPATIAL_VALID_COUNTRIES'
             AND al.lookup_code = p_country_code;

Line: 478

      SELECT vp.value
      FROM   v$parameter vp
      WHERE  LOWER(vp.name) = 'nls_numeric_characters';

Line: 1291

                                   '), update not possible.',
	                           p_prefix=>'ERROR',
			           p_msg_level=>fnd_log.level_error);