APPS.FII_EA_UTIL_PKG dependencies on FII_COST_CTR_HIERARCHIES

Line 875: FROM fii_cost_ctr_hierarchies

871:
872: IF g_cost_center_is_leaf = 'Y' THEN
873: IF g_if_trend_sum_mv = 'Y' OR (p_comp_agg_flag = 'Y' and l_cc_agg_flag = 'Y' and g_fin_aggregate_flag = 'Y' and g_ud1_aggregate_flag = 'Y') THEN
874: SELECT parent_cc_id INTO g_parent_cost_center_id
875: FROM fii_cost_ctr_hierarchies
876: WHERE child_cc_id = p_cc_id
877: and parent_level = child_level-1;
878: l_cc_join := 'parent_cc_id = '||g_parent_cost_center_id||'
879: and child_cc_id = '||p_cc_id;

Line 891: FROM fii_cost_ctr_hierarchies

887: END IF;
888: ELSE -- we have > 1 record in cc security table FOR that user
889: IF g_if_trend_sum_mv = 'Y' OR (p_comp_agg_flag = 'Y' and l_cc_agg_flag = 'Y' and g_fin_aggregate_flag = 'Y' and g_ud1_aggregate_flag = 'Y') THEN
890: SELECT parent_cc_id INTO g_parent_cost_center_id
891: FROM fii_cost_ctr_hierarchies
892: WHERE child_cc_id = p_cc_id
893: and parent_level = child_level-1;
894: l_cc_join := 'parent_cc_id = '||g_parent_cost_center_id||'
895: and child_cc_id = '||p_cc_id;

Line 904: FROM fii_cost_ctr_hierarchies

900: END IF ; -- END of IF g_cc_count=1 IF LOOP
901: ELSE -- non viewby CC
902: IF g_if_trend_sum_mv = 'Y' OR (p_comp_agg_flag = 'Y' and l_cc_agg_flag = 'Y' and g_fin_aggregate_flag = 'Y' and g_ud1_aggregate_flag = 'Y') THEN
903: SELECT parent_cc_id INTO g_parent_cost_center_id
904: FROM fii_cost_ctr_hierarchies
905: WHERE child_cc_id = p_cc_id
906: and parent_level = child_level-1;
907: l_cc_join := 'parent_cc_id = '||g_parent_cost_center_id||'
908: and child_cc_id = '||p_cc_id;

Line 916: FROM fii_cost_ctr_hierarchies cc_hier, fnd_flex_values_tl viewby_dim

912: END IF;
913: END IF; -- END of IF viewby cc
914: IF g_view_by = 'ORGANIZATION+HRI_CL_ORGCC' THEN
915: l_cc_sql := 'SELECT cc_hier.parent_cc_id, cc_hier.next_level_cc_id, cc_hier.next_level_cc_sort_order, viewby_dim.description
916: FROM fii_cost_ctr_hierarchies cc_hier, fnd_flex_values_tl viewby_dim
917: WHERE viewby_dim.flex_value_id = cc_hier.next_level_cc_id
918: and viewby_dim.language = userenv(''LANG'')
919: and '||l_cc_join;
920: ELSE

Line 922: FROM fii_cost_ctr_hierarchies cc_hier

918: and viewby_dim.language = userenv(''LANG'')
919: and '||l_cc_join;
920: ELSE
921: l_cc_sql := 'SELECT cc_hier.parent_cc_id, cc_hier.next_level_cc_id, NULL, NULL
922: FROM fii_cost_ctr_hierarchies cc_hier
923: WHERE '||l_cc_join;
924: END IF;
925: -- fetch all records FOR CC in CC dimension's table of records
926: EXECUTE IMMEDIATE l_cc_sql BULK COLLECT INTO cc_table;

Line 949: FROM fii_cost_ctr_hierarchies

945:
946: IF g_cost_center_is_leaf = 'Y' THEN
947:
948: SELECT parent_cc_id INTO g_parent_cost_center_id
949: FROM fii_cost_ctr_hierarchies
950: WHERE child_cc_id = g_cost_center_id
951: and parent_level = child_level-1;
952: l_cc_join := 'parent_cc_id = '||g_parent_cost_center_id||'
953: and child_cc_id = '||g_cost_center_id;

Line 960: FROM fii_cost_ctr_hierarchies

956: and child_level = parent_level + 1';
957: END IF;
958: ELSE
959: SELECT parent_cc_id INTO g_parent_cost_center_id
960: FROM fii_cost_ctr_hierarchies
961: WHERE child_cc_id = g_cost_center_id
962: and parent_level = child_level-1;
963: l_cc_join := 'parent_cc_id = '||g_parent_cost_center_id||'
964: and child_cc_id = '||g_cost_center_id;

Line 986: FROM fii_cost_ctr_hierarchies cc_hier, fnd_flex_values_tl viewby_dim

982: END IF;
983:
984: IF g_view_by = 'ORGANIZATION+HRI_CL_ORGCC' THEN
985: l_cc_sql := 'SELECT cc_hier.parent_cc_id, cc_hier.next_level_cc_id, cc_hier.next_level_cc_sort_order, viewby_dim.description
986: FROM fii_cost_ctr_hierarchies cc_hier, fnd_flex_values_tl viewby_dim
987: WHERE viewby_dim.flex_value_id = cc_hier.next_level_cc_id
988: and viewby_dim.language = userenv(''LANG'')
989: and '||l_cc_join;
990: ELSE

Line 992: FROM fii_cost_ctr_hierarchies cc_hier

988: and viewby_dim.language = userenv(''LANG'')
989: and '||l_cc_join;
990: ELSE
991: l_cc_sql := 'SELECT cc_hier.parent_cc_id, cc_hier.next_level_cc_id, NULL, NULL
992: FROM fii_cost_ctr_hierarchies cc_hier
993: WHERE '||l_cc_join;
994: END IF;
995:
996: EXECUTE IMMEDIATE l_cc_sql BULK COLLECT INTO cc_table;

Line 2028: FROM fii_cost_ctr_hierarchies

2024: and parent_company_id = child_company_id;
2025:
2026: ELSIF g_view_by = 'ORGANIZATION+HRI_CL_ORGCC' THEN
2027: SELECT is_leaf_flag INTO g_cost_center_is_leaf
2028: FROM fii_cost_ctr_hierarchies
2029: WHERE parent_cc_id = p_id
2030: and parent_cc_id = child_cc_id;
2031:
2032: ELSIF g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN