APPS.FND_FLEX_VAL_API dependencies on FND_FLEX_VALUE_NORM_HIERARCHY

Line 1483: FROM fnd_flex_value_norm_hierarchy

1479: FROM fnd_flex_value_hierarchies
1480: WHERE flex_value_set_id = l_value_set_id;
1481:
1482: DELETE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1483: FROM fnd_flex_value_norm_hierarchy
1484: WHERE flex_value_set_id = l_value_set_id;
1485:
1486: --
1487: -- Delete Table Validated Value set.

Line 3428: DELETE FROM fnd_flex_value_norm_hierarchy

3424:
3425: IF (l_value.summary_flag = 'N') THEN
3426: l_value.structured_hierarchy_level := NULL;
3427:
3428: DELETE FROM fnd_flex_value_norm_hierarchy
3429: WHERE flex_value_set_id = l_vset.flex_value_set_id
3430: AND parent_flex_value = l_value.flex_value;
3431: END IF;
3432:

Line 3649: FROM fnd_flex_value_norm_hierarchy

3645: l_count NUMBER;
3646: BEGIN
3647: SELECT COUNT(*)
3648: INTO l_count
3649: FROM fnd_flex_value_norm_hierarchy
3650: WHERE flex_value_set_id = l_vset.flex_value_set_id
3651: AND parent_flex_value = l_value.flex_value
3652: AND range_attribute = p_range_attribute
3653: AND child_flex_value_low = l_storage_value_low

Line 3673: INSERT INTO fnd_flex_value_norm_hierarchy

3669:
3670: -- Ready to insert
3671:
3672: BEGIN
3673: INSERT INTO fnd_flex_value_norm_hierarchy
3674: (
3675: flex_value_set_id,
3676: parent_flex_value,
3677: range_attribute,