APPS.GL_CHART_OF_ACCOUNTS_API_PKG dependencies on FND_FLEX_VALUE_NORM_HIERARCHY

Line 32: FROM fnd_flex_value_norm_hierarchy

28: value_set_id IN NUMBER
29: ) RETURN BOOLEAN IS
30: CURSOR find_parent_cursor IS
31: SELECT parent_flex_value, range_attribute
32: FROM fnd_flex_value_norm_hierarchy
33: WHERE flex_value_set_id = value_set_id
34: AND target BETWEEN child_flex_value_low
35: AND child_flex_value_high;
36: parent find_parent_cursor%ROWTYPE;

Line 2378: -- fnd_flex_value_norm_hierarchy

2374: -- Procedure
2375: -- validate_hierarchy
2376: -- Purpose
2377: -- Detect hierarchy loop in rows to be added to
2378: -- fnd_flex_value_norm_hierarchy
2379: -- History
2380: -- 02.03.2001 M Marra Created.
2381: -- 03.08.2001 M Marra Modified to work row by row rather than
2382: -- validating the entire hierarchy at once.

Line 2462: -- Compile hierarchy data from fnd_flex_value_norm_hierarchy.

2458: --
2459: -- Procedure
2460: -- compile_hierarchy
2461: -- Purpose
2462: -- Compile hierarchy data from fnd_flex_value_norm_hierarchy.
2463: -- History
2464: -- 02.03.2001 MMarra Created.
2465: --
2466: FUNCTION compile_hierarchy (