APPS.FND_FLEX_VAL_API dependencies on FND_FLEX_VALUE_RULES

Line 1439: FROM fnd_flex_value_rules_tl

1435: --
1436: -- Delete Value rules.
1437: --
1438: DELETE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1439: FROM fnd_flex_value_rules_tl
1440: WHERE flex_value_rule_id IN
1441: (SELECT flex_value_rule_id FROM fnd_flex_value_rules
1442: WHERE flex_value_set_id = l_value_set_id);
1443:

Line 1441: (SELECT flex_value_rule_id FROM fnd_flex_value_rules

1437: --
1438: DELETE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1439: FROM fnd_flex_value_rules_tl
1440: WHERE flex_value_rule_id IN
1441: (SELECT flex_value_rule_id FROM fnd_flex_value_rules
1442: WHERE flex_value_set_id = l_value_set_id);
1443:
1444: DELETE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1445: FROM fnd_flex_value_rules

Line 1445: FROM fnd_flex_value_rules

1441: (SELECT flex_value_rule_id FROM fnd_flex_value_rules
1442: WHERE flex_value_set_id = l_value_set_id);
1443:
1444: DELETE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1445: FROM fnd_flex_value_rules
1446: WHERE flex_value_set_id = l_value_set_id;
1447:
1448: DELETE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1449: FROM fnd_flex_value_rule_lines