APPS.FND_FLEX_VAL_API dependencies on FND_FLEX_HIERARCHIES

Line 1471: FROM fnd_flex_hierarchies_TL

1467: --
1468: -- Delete Value hierarchies.
1469: --
1470: DELETE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1471: FROM fnd_flex_hierarchies_TL
1472: WHERE flex_value_set_id = l_value_set_id;
1473:
1474: DELETE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1475: FROM fnd_flex_hierarchies

Line 1475: FROM fnd_flex_hierarchies

1471: FROM fnd_flex_hierarchies_TL
1472: WHERE flex_value_set_id = l_value_set_id;
1473:
1474: DELETE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1475: FROM fnd_flex_hierarchies
1476: WHERE flex_value_set_id = l_value_set_id;
1477:
1478: DELETE /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1479: FROM fnd_flex_value_hierarchies

Line 2745: FROM fnd_flex_hierarchies

2741:
2742: BEGIN
2743: SELECT hierarchy_id
2744: INTO x_hierarchy_id
2745: FROM fnd_flex_hierarchies
2746: WHERE flex_value_set_id = l_vset.flex_value_set_id
2747: AND hierarchy_code = p_hierarchy_code;
2748: EXCEPTION
2749: WHEN OTHERS THEN

Line 3001: l_hierarchy_code fnd_flex_hierarchies.hierarchy_code%TYPE;

2997: 'Structured Hierarchy Level can only be specified for Parent Values.');
2998: END IF;
2999:
3000: DECLARE
3001: l_hierarchy_code fnd_flex_hierarchies.hierarchy_code%TYPE;
3002: BEGIN
3003: SELECT hierarchy_code
3004: INTO l_hierarchy_code
3005: FROM fnd_flex_hierarchies

Line 3005: FROM fnd_flex_hierarchies

3001: l_hierarchy_code fnd_flex_hierarchies.hierarchy_code%TYPE;
3002: BEGIN
3003: SELECT hierarchy_code
3004: INTO l_hierarchy_code
3005: FROM fnd_flex_hierarchies
3006: WHERE flex_value_set_id = p_vset.flex_value_set_id
3007: AND hierarchy_id = p_value.structured_hierarchy_level;
3008: EXCEPTION
3009: WHEN OTHERS THEN