APPS.OKC_XPRT_RULE_PVT dependencies on FND_FLEX_VALUE_SETS

Line 222: fnd_flex_value_sets b,

218: variable_datatype, b.longlist_flag, b.validation_type,
219: b.flex_value_set_id value_set_id, variable_type,
220: vartype.meaning var_type_meaning
221: FROM okc_bus_variables_v a,
222: fnd_flex_value_sets b,
223: fnd_lookups vartype
224: WHERE contract_expert_yn = 'Y'
225: AND variable_datatype <> 'D'
226: AND a.xprt_value_set_name = b.flex_value_set_name(+)

Line 236: fnd_flex_value_sets b,

232: variable_datatype, b.longlist_flag, b.validation_type,
233: b.flex_value_set_id value_set_id, variable_type,
234: vartype.meaning var_type_meaning
235: FROM okc_bus_variables_v a,
236: fnd_flex_value_sets b,
237: fnd_lookups vartype
238: WHERE a.variable_type = 'U'
239: AND a.value_set_id = b.flex_value_set_id
240: AND ( ( b.validation_type IN ('I', 'X', 'F')

Line 638: FROM fnd_flex_value_sets

634: ELSIF p_object_value_type = 'VALUE'
635: THEN
636: SELECT flex_value_set_id, validation_type
637: INTO l_value_set_id, l_validation_type
638: FROM fnd_flex_value_sets
639: WHERE flex_value_set_name = p_value_set_name;
640:
641: FOR i IN p_rule_cond_vals_tbl.FIRST .. p_rule_cond_vals_tbl.LAST
642: LOOP