APPS.HXC_ALIAS_UTILITY dependencies on FND_FLEX_VALIDATION_TABLES

Line 2929: from fnd_flex_validation_tables t

2925: select 'select to_char('||value_column_name||') display_value, '||
2926: replace(id_column_name, ',', ' || ''ALIAS_SEPARATOR'' || ')||' id_value '||
2927: ' from '||application_table_name
2928: into l_stmt
2929: from fnd_flex_validation_tables t
2930: where t.flex_value_set_id = p_vset_id;
2931:
2932: select additional_where_clause
2933: into l_where

Line 2934: from fnd_flex_validation_tables t

2930: where t.flex_value_set_id = p_vset_id;
2931:
2932: select additional_where_clause
2933: into l_where
2934: from fnd_flex_validation_tables t
2935: where t.flex_value_set_id = p_vset_id;
2936:
2937: if l_where is not null then
2938: l_stmt := l_stmt ||' '||l_where;

Line 3114: from fnd_flex_validation_tables t

3110: BEGIN
3111:
3112: select id_column_type,instr(id_column_name,'to_char')
3113: into l_id_col_type, l_to_char_in_col_id
3114: from fnd_flex_validation_tables t
3115: where t.flex_value_set_id = p_vset_id;
3116:
3117: -- if the type is a NUMBER
3118: IF l_id_col_type = 'N' THEN

Line 3657: from fnd_flex_validation_tables t,

3653: ELSE
3654:
3655: select application_table_name
3656: into l_apps_table
3657: from fnd_flex_validation_tables t,
3658: hxc_alias_types h,
3659: hxc_alias_definitions hd
3660: where t.flex_value_set_id = h.reference_object
3661: and hd.alias_definition_id = p_alias_definition_id