APPS.ASO_DEF_UTIL SQL Statements

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

Line: 80

   SELECT col.data_default
     FROM   user_synonyms syn, all_tab_columns col
     WHERE syn.synonym_name = p_table_name
     and col.owner      =  syn.table_owner
    and col.table_name = syn.table_name
     AND    col.column_name = p_column_name;

Line: 108

   SELECT default_value_varchar2, default_value_number, default_value_date
   FROM   ak_Attributes
   WHERE  attribute_application_id = p_application_id
   AND    attribute_code = p_attribute_code;

Line: 140

   SELECT default_value_varchar2, default_value_number, default_value_date
   FROM   ak_OBJECT_Attributes
   WHERE  attribute_application_id = p_application_id
   AND    database_object_name = p_database_object_name
   AND    attribute_code = p_attribute_code;

Line: 171

        l_sql_string :=  'SELECT '||p_expression_string||' FROM SYS.DUAL';

Line: 192

		l_sql_string :=  'SELECT '||p_expression_string||' FROM DUAL';

Line: 318

l_select_stmt		VARCHAR2(200);

Line: 321

        l_select_stmt :=  'SELECT '||p_sequence_name||'.NEXTVAL FROM DUAL';

Line: 322

	EXECUTE IMMEDIATE l_select_stmt INTO l_next_val;

Line: 372

     select src_type, src_api_pkg||'.'||src_api_fn
            ,src_database_object_name, src_attribute_code
            ,src_constant_value, src_profile_option
            ,src_system_variable_expr, src_sequence_name
     into l_src_type, l_src_api_name
            ,l_src_database_object_name, l_src_attribute_code
            ,l_src_constant_value, l_src_profile_option
            ,l_src_system_variable_expr, l_src_sequence_name
     from oe_def_attr_def_rules
     where attr_def_rule_id = p_rule_id;

Line: 395

  select meaning
  into l_src_type_value
  from oe_lookups
  where lookup_type = 'DEFAULTING_SOURCE_TYPE'
  and lookup_code = decode(l_src_type,p_attribute_code,'CONSTANT'
					,l_src_type);

Line: 409

    select name
    into l_src_object
    from ak_objects_vl
    where database_object_name = l_src_database_object_name;

Line: 440

    select user_profile_option_name
    into l_default_source
    from fnd_profile_options_vl
    where profile_option_name = l_src_profile_option;