APPS.PON_FORMS_UTIL_PVT dependencies on FND_FLEX_VALIDATION_TABLES

Line 816: from fnd_flex_validation_tables tbl, fnd_flex_value_sets val

812: p_orderby = '||p_orderby);
813:
814: select VALUE_COLUMN_NAME, ID_COLUMN_NAME
815: into l_value_column_name,l_id_column_name
816: from fnd_flex_validation_tables tbl, fnd_flex_value_sets val
817: where tbl.flex_value_set_id =val.flex_value_set_id
818: and val.flex_value_set_name = p_value_set_name;
819:
820: print_debug_log(l_api_name, ' l_value_column_name = '||l_value_column_name||'

Line 970: from fnd_flex_validation_tables tbl,

966: rt_value := p_id_value;
967: else
968: select tbl.ID_COLUMN_NAME, tbl.VALUE_COLUMN_NAME, fld.VALUE_SET_QUERY, fld.VALUE_SET_ID_EXISTS
969: into l_id_column_name, l_value_column_name, l_query_stmt, l_id_column_exists
970: from fnd_flex_validation_tables tbl,
971: fnd_flex_value_sets val,
972: pon_fields fld
973: where tbl.flex_value_set_id = val.flex_value_set_id
974: and val.flex_value_set_name = fld.value_set_name

Line 1067: from fnd_flex_validation_tables tbl, fnd_flex_value_sets val

1063: elsif l_value_set_type = 'F' then
1064:
1065: select VALUE_COLUMN_NAME, ID_COLUMN_NAME
1066: into l_value_column_name,l_id_column_name
1067: from fnd_flex_validation_tables tbl, fnd_flex_value_sets val
1068: where tbl.flex_value_set_id =val.flex_value_set_id
1069: and val.flex_value_set_name = p_value_set_name;
1070:
1071: print_debug_log(l_api_name, 'l_value_column_name = '||l_value_column_name ||' l_id_column_name = '||l_id_column_name);