APPS.OKC_TERMS_UTIL_PVT dependencies on FND_FLEX_VALUE_SETS

Line 2548: fnd_flex_value_sets val_set

2544:
2545: cursor flex_value_vl_csr(l_value_set_id NUMBER, l_flex_value_id VARCHAR2) is
2546: select value.flex_value
2547: from fnd_flex_values_vl value,
2548: fnd_flex_value_sets val_set
2549: where
2550: value.FLEX_VALUE_SET_ID = val_set.FLEX_VALUE_SET_ID
2551: and val_set.flex_value_set_id = l_value_set_id
2552: and to_char(value.flex_value_id)= l_flex_value_id;

Line 5337: l_validation_type fnd_flex_value_sets.validation_type%TYPE;

5333: l_procedure_spec_status ALL_OBJECTS.status%TYPE;
5334: l_procedure_body_status ALL_OBJECTS.status%TYPE;
5335: l_dummy VARCHAR2(1);
5336:
5337: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
5338: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5339: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
5340: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
5341: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;

Line 5359: FROM FND_FLEX_VALUE_SETS

5355: AND VB.variable_source = 'P';
5356:
5357: CURSOR csr_get_validation_type(p_value_set_id IN NUMBER) IS
5358: SELECT validation_type
5359: FROM FND_FLEX_VALUE_SETS
5360: WHERE flex_value_set_id = p_value_set_id;
5361:
5362: CURSOR csr_value_set_table(p_value_set_id IN NUMBER) IS
5363: SELECT application_table_name,