APPS.PQH_UTILITY dependencies on FND_FLEX_VALIDATION_TABLES

Line 1573: l_add_where_clause, l_id_column_name from fnd_flex_validation_tables where flex_value_set_id = p_value_set_id;

1569:
1570: If l_value_set.validation_type = 'F' then
1571: select value_column_name, application_table_name,
1572: additional_where_clause, id_column_name into l_value_column_name, l_app_tab_name,
1573: l_add_where_clause, l_id_column_name from fnd_flex_validation_tables where flex_value_set_id = p_value_set_id;
1574:
1575: p_sql_stmt := rtrim('select '||l_id_column_name||' Id,'||l_value_column_name||' Val,'||'null Att_Name'||' from '||l_app_tab_name||' '||l_add_where_clause, ' ');
1576: --
1577: Else

Line 1621: FROM fnd_flex_validation_tables

1617: ELSE
1618: IF l_value_set_rec.validation_type = 'F' THEN
1619: SELECT value_column_name, application_table_name, additional_where_clause, id_column_name
1620: INTO l_value_column_name, l_app_tab_name, l_add_where_clause, l_id_column_name
1621: FROM fnd_flex_validation_tables
1622: WHERE flex_value_set_id = p_value_set_id;
1623: IF l_add_where_clause IS NOT NULL THEN
1624: IF INSTR(UPPER(l_add_where_clause), 'ORDER BY') <> 0 THEN
1625: l_add_where_clause := REPLACE(l_add_where_clause,

Line 1728: FROM fnd_flex_validation_tables

1724: ELSE
1725: IF l_value_set_rec.validation_type = 'F' THEN
1726: SELECT value_column_name, application_table_name, additional_where_clause, id_column_name
1727: INTO l_value_column_name, l_app_tab_name, l_add_where_clause, l_id_column_name
1728: FROM fnd_flex_validation_tables
1729: WHERE flex_value_set_id = p_value_set_id;
1730: IF l_add_where_clause IS NOT NULL THEN
1731: IF INSTR(UPPER(l_add_where_clause), 'ORDER BY') <> 0 THEN
1732: l_add_where_clause := REPLACE(l_add_where_clause,