APPS.HXC_ALIAS_UTILITY dependencies on FND_FLEX_VALIDATION_TABLES

Line 2613: from fnd_flex_validation_tables t

2609: select 'select to_char('||value_column_name||') display_value, '||
2610: replace(id_column_name, ',', ' || ''ALIAS_SEPARATOR'' || ')||' id_value '||
2611: ' from '||application_table_name
2612: into l_stmt
2613: from fnd_flex_validation_tables t
2614: where t.flex_value_set_id = p_vset_id;
2615:
2616: select additional_where_clause
2617: into l_where

Line 2618: from fnd_flex_validation_tables t

2614: where t.flex_value_set_id = p_vset_id;
2615:
2616: select additional_where_clause
2617: into l_where
2618: from fnd_flex_validation_tables t
2619: where t.flex_value_set_id = p_vset_id;
2620:
2621: if l_where is not null then
2622: l_stmt := l_stmt ||' '||l_where;

Line 2798: from fnd_flex_validation_tables t

2794: BEGIN
2795:
2796: select id_column_type,instr(id_column_name,'to_char')
2797: into l_id_col_type, l_to_char_in_col_id
2798: from fnd_flex_validation_tables t
2799: where t.flex_value_set_id = p_vset_id;
2800:
2801: -- if the type is a NUMBER
2802: IF l_id_col_type = 'N' THEN

Line 3341: from fnd_flex_validation_tables t,

3337: ELSE
3338:
3339: select application_table_name
3340: into l_apps_table
3341: from fnd_flex_validation_tables t,
3342: hxc_alias_types h,
3343: hxc_alias_definitions hd
3344: where t.flex_value_set_id = h.reference_object
3345: and hd.alias_definition_id = p_alias_definition_id