APPS.FND_FLEX_VAL_API dependencies on FND_FLEX_VALUE_NORM_HIERARCHY

Line 1472: FROM fnd_flex_value_norm_hierarchy

1468: FROM fnd_flex_value_hierarchies
1469: WHERE flex_value_set_id = l_value_set_id;
1470:
1471: DELETE /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1472: FROM fnd_flex_value_norm_hierarchy
1473: WHERE flex_value_set_id = l_value_set_id;
1474:
1475: --
1476: -- Delete Table Validated Value set.

Line 3300: DELETE FROM fnd_flex_value_norm_hierarchy

3296:
3297: IF (l_value.summary_flag = 'N') THEN
3298: l_value.structured_hierarchy_level := NULL;
3299:
3300: DELETE FROM fnd_flex_value_norm_hierarchy
3301: WHERE flex_value_set_id = l_vset.flex_value_set_id
3302: AND parent_flex_value = l_value.flex_value;
3303: END IF;
3304:

Line 3521: FROM fnd_flex_value_norm_hierarchy

3517: l_count NUMBER;
3518: BEGIN
3519: SELECT COUNT(*)
3520: INTO l_count
3521: FROM fnd_flex_value_norm_hierarchy
3522: WHERE flex_value_set_id = l_vset.flex_value_set_id
3523: AND parent_flex_value = l_value.flex_value
3524: AND range_attribute = p_range_attribute
3525: AND child_flex_value_low = l_storage_value_low

Line 3545: INSERT INTO fnd_flex_value_norm_hierarchy

3541:
3542: -- Ready to insert
3543:
3544: BEGIN
3545: INSERT INTO fnd_flex_value_norm_hierarchy
3546: (
3547: flex_value_set_id,
3548: parent_flex_value,
3549: range_attribute,