54: select 'select to_char('||value_column_name||') display_value, '||
55: replace(id_column_name, ',', ' || ')||' id_value '||
56: ' from '||application_table_name
57: into l_stmt
58: from fnd_flex_validation_tables t
59: where t.flex_value_set_id = p_value_set_id;
60:
61: select additional_where_clause
62: into l_where
59: where t.flex_value_set_id = p_value_set_id;
60:
61: select additional_where_clause
62: into l_where
63: from fnd_flex_validation_tables t
64: where t.flex_value_set_id = p_value_set_id;
65:
66: if l_where is not null then
67: l_stmt := l_stmt ||' '||l_where;