APPS.PON_FORMS_UTIL_PVT dependencies on FND_FLEX_VALIDATION_TABLES

Line 873: from fnd_flex_validation_tables tbl, fnd_flex_value_sets val

869: p_orderby = '||p_orderby);
870:
871: select VALUE_COLUMN_NAME, ID_COLUMN_NAME
872: into l_value_column_name,l_id_column_name
873: from fnd_flex_validation_tables tbl, fnd_flex_value_sets val
874: where tbl.flex_value_set_id =val.flex_value_set_id
875: and val.flex_value_set_name = p_value_set_name;
876:
877: print_debug_log(l_api_name, ' l_value_column_name = '||l_value_column_name||'

Line 1027: from fnd_flex_validation_tables tbl,

1023: rt_value := p_id_value;
1024: else
1025: select tbl.ID_COLUMN_NAME, tbl.VALUE_COLUMN_NAME, fld.VALUE_SET_QUERY, fld.VALUE_SET_ID_EXISTS
1026: into l_id_column_name, l_value_column_name, l_query_stmt, l_id_column_exists
1027: from fnd_flex_validation_tables tbl,
1028: fnd_flex_value_sets val,
1029: pon_fields fld
1030: where tbl.flex_value_set_id = val.flex_value_set_id
1031: and val.flex_value_set_name = fld.value_set_name

Line 1124: from fnd_flex_validation_tables tbl, fnd_flex_value_sets val

1120: elsif l_value_set_type = 'F' then
1121:
1122: select VALUE_COLUMN_NAME, ID_COLUMN_NAME
1123: into l_value_column_name,l_id_column_name
1124: from fnd_flex_validation_tables tbl, fnd_flex_value_sets val
1125: where tbl.flex_value_set_id =val.flex_value_set_id
1126: and val.flex_value_set_name = p_value_set_name;
1127:
1128: print_debug_log(l_api_name, 'l_value_column_name = '||l_value_column_name ||' l_id_column_name = '||l_id_column_name);