APPS.FII_EA_UTIL_PKG dependencies on FII_UDD2_HIERARCHIES

Line 1082: FROM fii_udd2_hierarchies fud2_hier, fnd_flex_values_tl viewby_dim

1078: IF g_if_trend_sum_mv = 'Y' THEN
1079: l_fud2_sql := 'SELECT NULL, NULL, NULL, NULL FROM dual';
1080: ELSIF g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_2' THEN
1081: l_fud2_sql := ' SELECT fud2_hier.parent_value_id, fud2_hier.next_level_value_id, fud2_hier.next_level_value_sort_order, viewby_dim.description
1082: FROM fii_udd2_hierarchies fud2_hier, fnd_flex_values_tl viewby_dim
1083: WHERE viewby_dim.flex_value_id = fud2_hier.next_level_value_id
1084: and viewby_dim.language = userenv(''LANG'')
1085: and '||l_fud2_join;
1086: ELSE

Line 1088: FROM fii_udd2_hierarchies fud2_hier

1084: and viewby_dim.language = userenv(''LANG'')
1085: and '||l_fud2_join;
1086: ELSE
1087: l_fud2_sql := ' SELECT fud2_hier.parent_value_id, fud2_hier.next_level_value_id, NULL, null
1088: FROM fii_udd2_hierarchies fud2_hier
1089: WHERE '||l_fud2_join;
1090: END IF;
1091: -- fetch all records for FUD2 in fud2's table of records
1092: EXECUTE IMMEDIATE l_fud2_sql BULK COLLECT INTO fud2_table;

Line 1413: FROM fii_udd2_hierarchies;

1409: FROM fii_financial_dimensions
1410: WHERE dimension_short_name = 'FII_USER_DEFINED_2';
1411: If l_fud2_enabled_flag = 'N' THEN
1412: SELECT parent_value_id INTO g_top_fud2_id
1413: FROM fii_udd2_hierarchies;
1414: l_fud2_join := 'parent_value_id = '||g_top_fud2_id||' and
1415: child_value_id = '||g_top_fud2_id;
1416: ELSE
1417: IF g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_2' THEN