APPS.FII_EA_UTIL_PKG dependencies on FII_COMPANY_HIERARCHIES

Line 718: FROM fii_company_hierarchies

714:
715: IF g_company_is_leaf = 'Y' THEN
716: IF g_if_trend_sum_mv = 'Y' OR (l_comp_agg_flag = 'Y' and p_cc_agg_flag = 'Y' and g_fin_aggregate_flag = 'Y' and g_ud1_aggregate_flag = 'Y') THEN
717: SELECT parent_company_id INTO g_parent_company_id
718: FROM fii_company_hierarchies
719: WHERE child_company_id = p_company_id
720: and parent_level = child_level-1;
721: l_company_join := 'parent_company_id = '||g_parent_company_id||'
722: and child_company_id = '||p_company_id;

Line 736: FROM fii_company_hierarchies

732: ELSE -- we have > 1 record in company security table FOR that user
733:
734: IF g_if_trend_sum_mv = 'Y' OR (l_comp_agg_flag = 'Y' and p_cc_agg_flag = 'Y' and g_fin_aggregate_flag = 'Y' and g_ud1_aggregate_flag = 'Y') THEN
735: SELECT parent_company_id INTO g_parent_company_id
736: FROM fii_company_hierarchies
737: WHERE child_company_id = p_company_id
738: and parent_level = child_level-1;
739: l_company_join := 'parent_company_id = '||g_parent_company_id||'
740: and child_company_id = '||p_company_id;

Line 750: FROM fii_company_hierarchies

746:
747: ELSE -- non viewby company
748: IF g_if_trend_sum_mv = 'Y' OR (l_comp_agg_flag = 'Y' and p_cc_agg_flag = 'Y' and g_fin_aggregate_flag = 'Y' and g_ud1_aggregate_flag = 'Y') THEN
749: SELECT parent_company_id INTO g_parent_company_id
750: FROM fii_company_hierarchies
751: WHERE child_company_id = p_company_id
752: and parent_level = child_level-1;
753: l_company_join := 'parent_company_id = '||g_parent_company_id||'
754: and child_company_id = '||p_company_id;

Line 763: FROM fii_company_hierarchies co_hier, fnd_flex_values_tl viewby_dim

759: END IF; -- END of IF viewby company control structure
760:
761: IF g_view_by = 'FII_COMPANIES+FII_COMPANIES' THEN
762: l_company_sql := 'SELECT co_hier.parent_company_id, co_hier.next_level_company_id, co_hier.next_level_company_sort_order, viewby_dim.description
763: FROM fii_company_hierarchies co_hier, fnd_flex_values_tl viewby_dim
764: WHERE viewby_dim.flex_value_id = co_hier.next_level_company_id
765: and viewby_dim.language = userenv(''LANG'')
766: and '||l_company_join;
767: ELSE -- we dont need to join to fnd_flex_values_tl hence passing NULL description

Line 769: FROM fii_company_hierarchies co_hier

765: and viewby_dim.language = userenv(''LANG'')
766: and '||l_company_join;
767: ELSE -- we dont need to join to fnd_flex_values_tl hence passing NULL description
768: l_company_sql := 'SELECT co_hier.parent_company_id, co_hier.next_level_company_id, NULL,NULL
769: FROM fii_company_hierarchies co_hier
770: WHERE '||l_company_join;
771: END IF;
772:
773: -- fetch records in company dimension's pl/sql table of records

Line 797: FROM fii_company_hierarchies

793: check_if_leaf(g_company_id);
794:
795: IF g_company_is_leaf = 'Y' THEN
796: SELECT parent_company_id INTO g_parent_company_id
797: FROM fii_company_hierarchies
798: WHERE child_company_id = g_company_id
799: and parent_level = child_level-1;
800: l_company_join := 'parent_company_id ='||g_parent_company_id||'
801: and child_company_id ='||g_company_id;

Line 808: FROM fii_company_hierarchies

804: and child_level = parent_level + 1';
805: END IF;
806: ELSE -- nonviewby company
807: SELECT parent_company_id INTO g_parent_company_id
808: FROM fii_company_hierarchies
809: WHERE child_company_id = g_company_id
810: and parent_level = child_level-1;
811: l_company_join := 'parent_company_id ='||g_parent_company_id||'
812: and child_company_id ='||g_company_id;

Line 834: FROM fii_company_hierarchies co_hier, fnd_flex_values_tl viewby_dim

830: END IF;
831:
832: IF g_view_by = 'FII_COMPANIES+FII_COMPANIES' THEN
833: l_company_sql := 'SELECT co_hier.parent_company_id,co_hier.next_level_company_id, co_hier.next_level_company_sort_order, viewby_dim.description
834: FROM fii_company_hierarchies co_hier, fnd_flex_values_tl viewby_dim
835: WHERE viewby_dim.flex_value_id = co_hier.next_level_company_id
836: and viewby_dim.language = userenv(''LANG'')
837: and '||l_company_join;
838: ELSE -- no need to join to tl table

Line 840: FROM fii_company_hierarchies co_hier

836: and viewby_dim.language = userenv(''LANG'')
837: and '||l_company_join;
838: ELSE -- no need to join to tl table
839: l_company_sql := 'SELECT co_hier.parent_company_id,co_hier.next_level_company_id, NULL, NULL
840: FROM fii_company_hierarchies co_hier
841: WHERE '||l_company_join;
842: END IF;
843:
844: EXECUTE IMMEDIATE l_company_sql BULK COLLECT INTO company_table;

Line 2022: FROM fii_company_hierarchies

2018: BEGIN
2019:
2020: IF g_view_by = 'FII_COMPANIES+FII_COMPANIES' THEN
2021: SELECT is_leaf_flag INTO g_company_is_leaf
2022: FROM fii_company_hierarchies
2023: WHERE parent_company_id = p_id
2024: and parent_company_id = child_company_id;
2025:
2026: ELSIF g_view_by = 'ORGANIZATION+HRI_CL_ORGCC' THEN