APPS.FII_EA_UTIL_PKG dependencies on FII_UDD1_HIERARCHIES

Line 1066: FROM fii_udd1_hierarchies fud1_hier, fnd_flex_values_tl viewby_dim

1062: IF g_if_trend_sum_mv = 'Y' THEN
1063: l_fud1_sql := 'SELECT NULL, NULL, NULL, NULL FROM dual';
1064: ELSIF g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN
1065: l_fud1_sql := ' SELECT fud1_hier.parent_value_id, fud1_hier.next_level_value_id, fud1_hier.next_level_value_sort_order, viewby_dim.description
1066: FROM fii_udd1_hierarchies fud1_hier, fnd_flex_values_tl viewby_dim
1067: WHERE viewby_dim.flex_value_id = fud1_hier.next_level_value_id
1068: and viewby_dim.language = userenv(''LANG'')
1069: and '||l_fud1_join;
1070: ELSE

Line 1072: FROM fii_udd1_hierarchies fud1_hier

1068: and viewby_dim.language = userenv(''LANG'')
1069: and '||l_fud1_join;
1070: ELSE
1071: l_fud1_sql := ' SELECT fud1_hier.parent_value_id, fud1_hier.next_level_value_id, NULL, null
1072: FROM fii_udd1_hierarchies fud1_hier
1073: WHERE '||l_fud1_join;
1074: END IF;
1075: -- fetch all records for FUD1 in fud1's table of records
1076: EXECUTE IMMEDIATE l_fud1_sql BULK COLLECT INTO fud1_table;

Line 1324: FROM fii_udd1_hierarchies;

1320: WHERE dimension_short_name = 'FII_USER_DEFINED_1';
1321:
1322: IF l_fud1_enabled_flag = 'N' THEN
1323: SELECT parent_value_id INTO g_top_fud1_id
1324: FROM fii_udd1_hierarchies;
1325:
1326: g_udd1_id := g_top_fud1_id;
1327:
1328: l_aggrt_fud1_join := 'parent_value_id = '||g_top_fud1_id||' and

Line 1353: FROM fii_udd1_hierarchies

1349:
1350: IF g_ud1_is_leaf = 'Y' THEN
1351:
1352: SELECT parent_value_id INTO g_parent_fud1_id
1353: FROM fii_udd1_hierarchies
1354: WHERE child_value_id = g_fud1_id
1355: and parent_level = child_level-1;
1356: l_aggrt_fud1_join := 'parent_value_id = '||g_parent_fud1_id||'
1357: and child_value_id = '||g_fud1_id;

Line 1377: FROM fii_udd1_hierarchies

1373: ELSE
1374: g_udd1_id := g_fud1_id;
1375:
1376: SELECT parent_value_id INTO g_parent_fud1_id
1377: FROM fii_udd1_hierarchies
1378: WHERE child_value_id = g_fud1_id
1379: and parent_level=child_level-1;
1380: l_aggrt_fud1_join := 'parent_value_id = '||g_parent_fud1_id||'
1381: and child_value_id = '||g_fud1_id;

Line 2048: FROM fii_udd1_hierarchies

2044:
2045: g_id := NVL(g_udd1_id,-9999);
2046:
2047: SELECT is_leaf_flag INTO g_ud1_is_leaf
2048: FROM fii_udd1_hierarchies
2049: WHERE parent_value_id = p_id
2050: and parent_value_id = child_value_id;
2051:
2052: ELSIF g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_2' THEN

Line 2054: FROM fii_udd1_hierarchies

2050: and parent_value_id = child_value_id;
2051:
2052: ELSIF g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_2' THEN
2053: SELECT is_leaf_flag INTO g_ud2_is_leaf
2054: FROM fii_udd1_hierarchies
2055: WHERE parent_value_id = p_id
2056: and parent_value_id = child_value_id;
2057: END IF;
2058: