DBA Data[Home] [Help]

APPS.FII_EA_UTIL_PKG dependencies on FII_FC_PMV_AGRT_NODES

Line 1176: SELECT for_viewby_flag INTO g_fin_aggregate_flag FROM fii_fc_pmv_agrt_nodes WHERE fin_category_id=g_fin_category_id;

1172:
1173: IF g_fin_category_id = 'All' THEN
1174: g_fin_aggregate_flag := 'Y';
1175: ELSIF g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
1176: SELECT for_viewby_flag INTO g_fin_aggregate_flag FROM fii_fc_pmv_agrt_nodes WHERE fin_category_id=g_fin_category_id;
1177: ELSE
1178: SELECT aggregated_flag INTO g_fin_aggregate_flag FROM fii_fc_pmv_agrt_nodes WHERE fin_category_id=g_fin_category_id;
1179: END IF;
1180:

Line 1178: SELECT aggregated_flag INTO g_fin_aggregate_flag FROM fii_fc_pmv_agrt_nodes WHERE fin_category_id=g_fin_category_id;

1174: g_fin_aggregate_flag := 'Y';
1175: ELSIF g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
1176: SELECT for_viewby_flag INTO g_fin_aggregate_flag FROM fii_fc_pmv_agrt_nodes WHERE fin_category_id=g_fin_category_id;
1177: ELSE
1178: SELECT aggregated_flag INTO g_fin_aggregate_flag FROM fii_fc_pmv_agrt_nodes WHERE fin_category_id=g_fin_category_id;
1179: END IF;
1180:
1181: -- fin category join is being formed. Child_level = parent_level check has been
1182: --included to take care of loading of budget/forecast at summary nodes