APPS.FII_EA_UTIL_PKG dependencies on FII_COM_PMV_AGRT_NODES

Line 710: FROM fii_com_pmv_agrt_nodes

706: IF g_company_count = 1 THEN -- WHEN only 1 record in security
707: -- table FOR that user, we will check for_viewby_flag ELSE security table's aggregated_flag will be used
708:
709: SELECT for_viewby_flag INTO l_comp_agg_flag
710: FROM fii_com_pmv_agrt_nodes
711: WHERE company_id = p_company_id;
712:
713: check_if_leaf(p_company_id);
714:

Line 1535: FROM fii_com_pmv_agrt_nodes

1531:
1532: IF g_view_by = 'FII_COMPANIES+FII_COMPANIES' THEN
1533: SELECT for_viewby_flag
1534: INTO l_company_aggregate_flag
1535: FROM fii_com_pmv_agrt_nodes
1536: WHERE company_id=g_company_id;
1537: ELSE
1538: SELECT aggregated_flag INTO l_company_aggregate_flag
1539: FROM fii_com_pmv_agrt_nodes

Line 1539: FROM fii_com_pmv_agrt_nodes

1535: FROM fii_com_pmv_agrt_nodes
1536: WHERE company_id=g_company_id;
1537: ELSE
1538: SELECT aggregated_flag INTO l_company_aggregate_flag
1539: FROM fii_com_pmv_agrt_nodes
1540: WHERE company_id=g_company_id;
1541: END IF;
1542:
1543: -- call various procedures to populate PL/SQL tables for different dimensions

Line 1568: FROM fii_com_pmv_agrt_nodes

1564:
1565: IF g_view_by = 'FII_COMPANIES+FII_COMPANIES' THEN
1566: SELECT for_viewby_flag
1567: INTO l_company_aggregate_flag
1568: FROM fii_com_pmv_agrt_nodes
1569: WHERE company_id = g_company_id;
1570: ELSE
1571: SELECT aggregated_flag INTO l_company_aggregate_flag
1572: FROM fii_com_pmv_agrt_nodes

Line 1572: FROM fii_com_pmv_agrt_nodes

1568: FROM fii_com_pmv_agrt_nodes
1569: WHERE company_id = g_company_id;
1570: ELSE
1571: SELECT aggregated_flag INTO l_company_aggregate_flag
1572: FROM fii_com_pmv_agrt_nodes
1573: WHERE company_id=g_company_id;
1574: END IF;
1575:
1576: IF g_view_by = 'ORGANIZATION+HRI_CL_ORGCC' THEN