DBA Data[Home] [Help]

APPS.FND_FLEX_VAL_API dependencies on FND_FLEX_VALUE_RULES

Line 1450: FROM fnd_flex_value_rules_tl

1446: --
1447: -- Delete Value rules.
1448: --
1449: DELETE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1450: FROM fnd_flex_value_rules_tl
1451: WHERE flex_value_rule_id IN
1452: (SELECT flex_value_rule_id FROM fnd_flex_value_rules
1453: WHERE flex_value_set_id = l_value_set_id);
1454:

Line 1452: (SELECT flex_value_rule_id FROM fnd_flex_value_rules

1448: --
1449: DELETE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1450: FROM fnd_flex_value_rules_tl
1451: WHERE flex_value_rule_id IN
1452: (SELECT flex_value_rule_id FROM fnd_flex_value_rules
1453: WHERE flex_value_set_id = l_value_set_id);
1454:
1455: DELETE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1456: FROM fnd_flex_value_rules

Line 1456: FROM fnd_flex_value_rules

1452: (SELECT flex_value_rule_id FROM fnd_flex_value_rules
1453: WHERE flex_value_set_id = l_value_set_id);
1454:
1455: DELETE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1456: FROM fnd_flex_value_rules
1457: WHERE flex_value_set_id = l_value_set_id;
1458:
1459: DELETE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1460: FROM fnd_flex_value_rule_lines