APPS.OKC_TERMS_UTIL_PVT dependencies on FND_FLEX_VALUE_SETS

Line 2590: fnd_flex_value_sets val_set

2586:
2587: cursor flex_value_vl_csr(l_value_set_id NUMBER, l_flex_value_id VARCHAR2) is
2588: select value.flex_value
2589: from fnd_flex_values_vl value,
2590: fnd_flex_value_sets val_set
2591: where
2592: value.FLEX_VALUE_SET_ID = val_set.FLEX_VALUE_SET_ID
2593: and val_set.flex_value_set_id = l_value_set_id
2594: and to_char(value.flex_value_id)= l_flex_value_id;

Line 5386: l_validation_type fnd_flex_value_sets.validation_type%TYPE;

5382: l_procedure_spec_status ALL_OBJECTS.status%TYPE;
5383: l_procedure_body_status ALL_OBJECTS.status%TYPE;
5384: l_dummy VARCHAR2(1);
5385:
5386: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
5387: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5388: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
5389: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
5390: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;

Line 5408: FROM FND_FLEX_VALUE_SETS

5404: AND VB.variable_source = 'P';
5405:
5406: CURSOR csr_get_validation_type(p_value_set_id IN NUMBER) IS
5407: SELECT validation_type
5408: FROM FND_FLEX_VALUE_SETS
5409: WHERE flex_value_set_id = p_value_set_id;
5410:
5411: CURSOR csr_value_set_table(p_value_set_id IN NUMBER) IS
5412: SELECT application_table_name,