APPS.MSD_CS_DEFN_UTL2 SQL Statements

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

Line: 14

        g_defn_para_list.delete;

Line: 217

SELECT flex_value_set_id
FROM fnd_flex_value_sets where upper(flex_value_set_name) = upper(p_vs_name);

Line: 221

SELECT application_table_name,
       value_column_name, id_column_name,
       additional_where_clause
FROM fnd_flex_validation_tables
WHERE flex_value_set_id = p_vs_id;

Line: 249

       l_sql_stmt := 'SELECT ' ||
                     l_value_col || ', '||
                     l_id_col || ' ' ||
                     'FROM ' || l_table_name || p_dblink || ' ' ||
                     l_where_clause;

Line: 287

      l_sql_stmt := ' SELECT ' || p_val_col ||
                    ' FROM (' || p_sql_stmt || ')' ||
                    ' WHERE ' || p_id_col || ' = :p_default_code';