APPS.FII_EA_UTIL_PKG dependencies on FII_FINANCIAL_DIMENSIONS

Line 1319: FROM fii_financial_dimensions

1315: END IF;
1316:
1317: -- fud1 join is being formed
1318: SELECT dbi_enabled_flag INTO l_fud1_enabled_flag
1319: FROM fii_financial_dimensions
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

Line 1337: FROM fii_financial_dimensions

1333: -- we need to consider next_level fud1 nodes
1334: IF g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_1' THEN
1335: IF g_fud1_id = 'All' THEN
1336: SELECT NVL(dbi_hier_top_node_id, -99999) INTO g_top_fud1_id
1337: FROM fii_financial_dimensions
1338: WHERE dimension_short_name = 'FII_USER_DEFINED_1';
1339:
1340: g_udd1_id := g_top_fud1_id;
1341:

Line 1366: FROM fii_financial_dimensions

1362: END IF;
1363: ELSE -- we can consider parent fud1 node directly
1364: IF g_fud1_id = 'All' THEN
1365: SELECT NVL(dbi_hier_top_node_id, -99999) INTO g_top_fud1_id
1366: FROM fii_financial_dimensions
1367: WHERE dimension_short_name = 'FII_USER_DEFINED_1';
1368:
1369: g_udd1_id := g_top_fud1_id;
1370:

Line 1409: FROM fii_financial_dimensions

1405:
1406: -- fud2 join is being formed
1407:
1408: SELECT dbi_enabled_flag INTO l_fud2_enabled_flag
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;

Line 1420: FROM fii_financial_dimensions

1416: ELSE
1417: IF g_view_by = 'FII_USER_DEFINED+FII_USER_DEFINED_2' THEN
1418: IF g_fud2_id = 'All' THEN
1419: SELECT NVL(dbi_hier_top_node_id, -99999) INTO g_top_fud2_id
1420: FROM fii_financial_dimensions
1421: WHERE dimension_short_name = 'FII_USER_DEFINED_2';
1422: l_fud2_join := 'parent_value_id = '||g_top_fud2_id||'
1423: and parent_level+1 = child_level';
1424: ELSE

Line 1438: FROM fii_financial_dimensions

1434: END IF;
1435: ELSE
1436: IF g_fud2_id = 'All' THEN
1437: SELECT NVL(dbi_hier_top_node_id, -99999) INTO g_top_fud2_id
1438: FROM fii_financial_dimensions
1439: WHERE dimension_short_name = 'FII_USER_DEFINED_2';
1440: l_fud2_join := 'parent_value_id = '||g_top_fud2_id||'
1441: and child_value_id = '||g_top_fud2_id;
1442: ELSE

Line 1816: FROM fii_financial_dimensions

1812: l_stmt VARCHAR2(200);
1813: l_enabled_flag VARCHAR2(1);
1814: BEGIN
1815: SELECT dbi_enabled_flag INTO l_enabled_flag
1816: FROM fii_financial_dimensions
1817: WHERE dimension_short_name = 'FII_USER_DEFINED_1';
1818:
1819: IF l_enabled_flag = 'Y' THEN
1820:

Line 1843: FROM fii_financial_dimensions

1839: l_stmt VARCHAR2(200);
1840: l_enabled_flag VARCHAR2(1);
1841: BEGIN
1842: SELECT dbi_enabled_flag INTO l_enabled_flag
1843: FROM fii_financial_dimensions
1844: WHERE dimension_short_name = 'FII_USER_DEFINED_2';
1845:
1846: IF l_enabled_flag = 'Y' THEN
1847: