DBA Data[Home] [Help]

APPS.FND_FLEX_VALUE_RULES_PKG dependencies on FND_FLEX_VALUE_SETS

Line 305: FROM fnd_flex_value_sets

301: l_rowid VARCHAR2(64);
302: BEGIN
303: SELECT flex_value_set_id, validation_type
304: INTO l_flex_value_set_id, l_validation_type
305: FROM fnd_flex_value_sets
306: WHERE flex_value_set_name = x_flex_value_set_name;
307:
308: BEGIN
309: IF (l_validation_type = 'D') THEN

Line 379: FROM fnd_flex_value_rules fvr, fnd_flex_value_sets fvs

375: last_update_login = x_who.last_update_login,
376: source_lang = userenv('LANG')
377: WHERE (flex_value_rule_id =
378: (SELECT flex_value_rule_id
379: FROM fnd_flex_value_rules fvr, fnd_flex_value_sets fvs
380: WHERE fvr.flex_value_set_id = fvs.flex_value_set_id
381: AND fvs.flex_value_set_name = x_flex_value_set_name
382: AND fvr.flex_value_rule_name = x_flex_value_rule_name
383: AND ((fvs.validation_type NOT IN ('D', 'Y')) OR