APPS.POA_DBI_SUTIL_PKG dependencies on FII_CC_PMV_AGRT_NODES

Line 567: from fnd_flex_values_tl t, fii_cc_pmv_agrt_nodes c, fnd_flex_values f

563: from fnd_flex_values_tl t, fii_com_pmv_agrt_nodes c, fnd_flex_values f
564: where c.company_id = t.flex_value_id and t.language = userenv(''LANG'') and t.flex_value_id = f.flex_value_id)'
565: WHEN 'ORGANIZATION+HRI_CL_ORGCC' THEN
566: '(select t.flex_value_id id, t.description value, f.summary_flag
567: from fnd_flex_values_tl t, fii_cc_pmv_agrt_nodes c, fnd_flex_values f
568: where c.cost_center_id = t.flex_value_id and t.language = userenv(''LANG'') and t.flex_value_id = f.flex_value_id)'
569: WHEN 'POA_PERSON+NEG_CREATOR' THEN '(select person_id id, substrb(first_name,1,1) || ''. ''|| last_name value from per_all_people_f where sysdate between effective_start_date and effective_end_date)'
570: WHEN 'LOOKUP+NEG_DOCTYPES' THEN 'poa_neg_doctypes_v'
571: ELSE ''

Line 2012: 'from fii_cc_pmv_agrt_nodes '||l_rtn||

2008: and report_region_code = p_region_code
2009: and aggregated_flag = 'N';
2010: else
2011: l_viewby_sql := 'select cost_center_id, aggregated_flag cc_agg_flag '||l_rtn||
2012: 'from fii_cc_pmv_agrt_nodes '||l_rtn||
2013: 'where cost_center_id = &COSTCTRID';
2014: select count(*) into l_non_agrt_nodes
2015: from fii_cc_pmv_agrt_nodes
2016: where cost_center_id = p_cost_center_id

Line 2015: from fii_cc_pmv_agrt_nodes

2011: l_viewby_sql := 'select cost_center_id, aggregated_flag cc_agg_flag '||l_rtn||
2012: 'from fii_cc_pmv_agrt_nodes '||l_rtn||
2013: 'where cost_center_id = &COSTCTRID';
2014: select count(*) into l_non_agrt_nodes
2015: from fii_cc_pmv_agrt_nodes
2016: where cost_center_id = p_cost_center_id
2017: and aggregated_flag = 'N';
2018: end if;
2019: else

Line 2041: 'from fii_cc_pmv_agrt_nodes '||l_rtn||

2037: and parent_cc_id = child_cc_id;
2038:
2039: if(l_leaf_flag = 'Y') then
2040: l_viewby_sql := 'select cost_center_id, aggregated_flag cc_agg_flag '||l_rtn||
2041: 'from fii_cc_pmv_agrt_nodes '||l_rtn||
2042: 'where cost_center_id = &TOPCOSTCTRID';
2043: select count(*) into l_non_agrt_nodes
2044: from fii_cc_pmv_agrt_nodes
2045: where cost_center_id = l_top_node

Line 2044: from fii_cc_pmv_agrt_nodes

2040: l_viewby_sql := 'select cost_center_id, aggregated_flag cc_agg_flag '||l_rtn||
2041: 'from fii_cc_pmv_agrt_nodes '||l_rtn||
2042: 'where cost_center_id = &TOPCOSTCTRID';
2043: select count(*) into l_non_agrt_nodes
2044: from fii_cc_pmv_agrt_nodes
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||

Line 2076: 'from fii_cc_pmv_agrt_nodes '||l_rtn||

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||
2076: 'from fii_cc_pmv_agrt_nodes '||l_rtn||
2077: 'where cost_center_id = &COSTCTRID';
2078: select count(*) into l_non_agrt_nodes
2079: from fii_cc_pmv_agrt_nodes
2080: where cost_center_id = p_cost_center_id

Line 2079: from fii_cc_pmv_agrt_nodes

2075: l_viewby_sql := 'select cost_center_id, aggregated_flag cc_agg_flag '||l_rtn||
2076: 'from fii_cc_pmv_agrt_nodes '||l_rtn||
2077: 'where cost_center_id = &COSTCTRID';
2078: select count(*) into l_non_agrt_nodes
2079: from fii_cc_pmv_agrt_nodes
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||