APPS.FII_EA_UTIL_PKG dependencies on FII_CC_PMV_AGRT_NODES

Line 867: FROM fii_cc_pmv_agrt_nodes

863: IF g_view_by = 'ORGANIZATION+HRI_CL_ORGCC' THEN
864:
865: IF g_cc_count = 1 THEN
866: SELECT for_viewby_flag INTO l_cc_agg_flag
867: FROM fii_cc_pmv_agrt_nodes
868: WHERE cost_center_id = p_cc_id;
869:
870: check_if_leaf(p_cc_id);
871:

Line 1495: FROM fii_cc_pmv_agrt_nodes

1491: FOR i in company_cursor LOOP
1492: IF g_view_by = 'ORGANIZATION+HRI_CL_ORGCC' THEN
1493: SELECT for_viewby_flag
1494: INTO l_cc_aggregate_flag
1495: FROM fii_cc_pmv_agrt_nodes
1496: WHERE cost_center_id=g_cost_center_id;
1497: ELSE
1498: SELECT aggregated_flag INTO l_cc_aggregate_flag FROM fii_cc_pmv_agrt_nodes id
1499: WHERE cost_center_id=g_cost_center_id;

Line 1498: SELECT aggregated_flag INTO l_cc_aggregate_flag FROM fii_cc_pmv_agrt_nodes id

1494: INTO l_cc_aggregate_flag
1495: FROM fii_cc_pmv_agrt_nodes
1496: WHERE cost_center_id=g_cost_center_id;
1497: ELSE
1498: SELECT aggregated_flag INTO l_cc_aggregate_flag FROM fii_cc_pmv_agrt_nodes id
1499: WHERE cost_center_id=g_cost_center_id;
1500: END IF;
1501:
1502: -- call various procedures to populate PL/SQL tables for different dimensions

Line 1579: FROM fii_cc_pmv_agrt_nodes

1575:
1576: IF g_view_by = 'ORGANIZATION+HRI_CL_ORGCC' THEN
1577: SELECT for_viewby_flag
1578: INTO l_cc_aggregate_flag
1579: FROM fii_cc_pmv_agrt_nodes
1580: WHERE cost_center_id = g_cost_center_id;
1581: ELSE
1582: SELECT aggregated_flag INTO l_cc_aggregate_flag
1583: FROM fii_cc_pmv_agrt_nodes

Line 1583: FROM fii_cc_pmv_agrt_nodes

1579: FROM fii_cc_pmv_agrt_nodes
1580: WHERE cost_center_id = g_cost_center_id;
1581: ELSE
1582: SELECT aggregated_flag INTO l_cc_aggregate_flag
1583: FROM fii_cc_pmv_agrt_nodes
1584: WHERE cost_center_id=g_cost_center_id;
1585: END IF;
1586:
1587: -- call various procedures to populate PL/SQL tables for different dimensions