APPS.POA_DBI_SUTIL_PKG dependencies on FII_COST_CTR_HIERARCHIES

Line 779: if(l_sql like '%fii_cost_ctr_hierarchies%') then

775:
776: get_cost_ctr_sql(l_viewby, l_cost_ctr_value, l_region_code, l_sql, l_agg_flag);
777: p_where_clause := p_where_clause || ' and cc.child_cc_id = fact.cost_center_id ';
778: if(p_mv_set = 'APIA' or p_mv_set = 'PODA' or p_mv_set = 'PQCA' or p_mv_set = 'IDLA' or p_mv_set = 'PODCUTA') then
779: if(l_sql like '%fii_cost_ctr_hierarchies%') then
780: l_in_join_rec.table_name := '(select /*+no_merge*/ b.parent_cc_id, b.cost_center_id, b.cost_center_id child_cc_id '||
781: 'from ('||l_sql||')b '||
782: 'where b.cc_agg_flag = ''Y'')';
783: p_where_clause := p_where_clause || ' and fact.parent_cc_id = cc.parent_cc_id ';

Line 792: 'fii_cost_ctr_hierarchies cc '||

788: end if;
789: else
790: l_in_join_rec.table_name := '(select /*+no_merge*/ b.cost_center_id, cc.child_cc_id, b.cc_agg_flag '||
791: 'from ('||l_sql||')b, '||
792: 'fii_cost_ctr_hierarchies cc '||
793: 'where b.cost_center_id = cc.parent_cc_id)';
794: end if;
795: l_in_join_rec.table_alias := 'cc';
796: l_in_join_rec.aggregated_flag := l_agg_flag;

Line 2035: from fii_cost_ctr_hierarchies

2031: where user_id = fnd_global.user_id
2032: and report_region_code = p_region_code;
2033:
2034: select is_leaf_flag into l_leaf_flag
2035: from fii_cost_ctr_hierarchies
2036: where parent_cc_id = to_number(l_top_node)
2037: and parent_cc_id = child_cc_id;
2038:
2039: if(l_leaf_flag = 'Y') then

Line 2049: 'from fii_cost_ctr_hierarchies '||l_rtn||

2045: where cost_center_id = l_top_node
2046: and aggregated_flag = 'N';
2047: else
2048: l_viewby_sql := 'select parent_cc_id, child_cc_id cost_center_id, aggregate_next_level_flag cc_agg_flag '||l_rtn||
2049: 'from fii_cost_ctr_hierarchies '||l_rtn||
2050: 'where child_level = parent_level+1 '||l_rtn||
2051: 'and parent_cc_id = &TOPCOSTCTRID';
2052: select count(*) into l_non_agrt_nodes
2053: from fii_cost_ctr_hierarchies

Line 2053: from fii_cost_ctr_hierarchies

2049: 'from fii_cost_ctr_hierarchies '||l_rtn||
2050: 'where child_level = parent_level+1 '||l_rtn||
2051: 'and parent_cc_id = &TOPCOSTCTRID';
2052: select count(*) into l_non_agrt_nodes
2053: from fii_cost_ctr_hierarchies
2054: where child_level = parent_level + 1
2055: and parent_cc_id = l_top_node
2056: and aggregate_next_level_flag = 'N';
2057: end if;

Line 2071: from fii_cost_ctr_hierarchies

2067: and aggregated_flag = 'N';
2068: end if;
2069: else
2070: select is_leaf_flag into l_leaf_flag
2071: from fii_cost_ctr_hierarchies
2072: where parent_cc_id = p_cost_center_id
2073: and parent_cc_id = child_cc_id;
2074: if(l_leaf_flag = 'Y') then
2075: l_viewby_sql := 'select cost_center_id, aggregated_flag cc_agg_flag '||l_rtn||

Line 2084: 'from fii_cost_ctr_hierarchies '||l_rtn||

2080: where cost_center_id = p_cost_center_id
2081: and aggregated_flag = 'N';
2082: else
2083: l_viewby_sql := 'select parent_cc_id, child_cc_id cost_center_id, aggregate_next_level_flag cc_agg_flag '||l_rtn||
2084: 'from fii_cost_ctr_hierarchies '||l_rtn||
2085: 'where child_level = parent_level+1 '||l_rtn||
2086: 'and parent_cc_id = &COSTCTRID';
2087: select count(*) into l_non_agrt_nodes
2088: from fii_cost_ctr_hierarchies

Line 2088: from fii_cost_ctr_hierarchies

2084: 'from fii_cost_ctr_hierarchies '||l_rtn||
2085: 'where child_level = parent_level+1 '||l_rtn||
2086: 'and parent_cc_id = &COSTCTRID';
2087: select count(*) into l_non_agrt_nodes
2088: from fii_cost_ctr_hierarchies
2089: where child_level = parent_level + 1
2090: and parent_cc_id = p_cost_center_id
2091: and aggregate_next_level_flag = 'N';
2092: end if;