APPS.FII_PMV_HELPER_TABLES_C dependencies on FII_FIN_CAT_TYPE_ASSGNS

Line 654: from fii_fin_cat_type_assgns, fii_fin_item_leaf_hiers

650: -- we need to take care that the level just below the top nodes is aggregated for FC.
651:
652: g_phase := 'Get the lowest level at which the top node is defined for Revenue';
653: select max(child_level) into l_max_level
654: from fii_fin_cat_type_assgns, fii_fin_item_leaf_hiers
655: where top_node_flag = 'Y'
656: and fin_category_id = child_fin_Cat_id
657: and parent_level = child_level
658: and fin_cat_type_code = 'R';

Line 671: from fii_fin_cat_type_assgns

667: where aggregate_next_level_flag <> 'Y'
668: and (next_level in (1,2)
669: or (next_level <= l_max_level + 1
670: and f.next_level_fin_cat_id in (select fin_category_id
671: from fii_fin_cat_type_assgns
672: where fin_cat_type_code = 'R')));
673:
674: IF (FIIDIM_Debug) THEN
675: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');

Line 680: from fii_fin_cat_type_assgns, fii_fin_item_leaf_hiers

676: END IF;
677:
678: g_phase := 'Get the lowest level at which the top node is defined for Expense';
679: select max(child_level) into l_max_level
680: from fii_fin_cat_type_assgns, fii_fin_item_leaf_hiers
681: where top_node_flag = 'Y'
682: and fin_category_id = child_fin_Cat_id
683: and parent_level = child_level
684: and fin_cat_type_code = 'EXP';

Line 692: from fii_fin_cat_type_assgns

688: set aggregate_next_level_flag = 'Y'
689: where aggregate_next_level_flag <> 'Y'
690: and (f.next_level <= l_max_level + 1
691: and f.next_level_fin_cat_id in (select fin_category_id
692: from fii_fin_cat_type_assgns
693: where fin_cat_type_code = 'EXP'));
694:
695: IF (FIIDIM_Debug) THEN
696: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');