APPS.POA_DBI_SUTIL_PKG dependencies on FII_COST_CENTER_GRANTS

Line 1664: from fii_cost_center_grants

1660: */
1661: return '0';
1662: else
1663: select count(*) into l_count
1664: from fii_cost_center_grants
1665: where user_id = fnd_global.user_id
1666: and cost_center_id = to_number(p_id)
1667: and report_region_code = 'POA_DBI_INV_STATUS';
1668: /* we are using Invoice Amount report as a reference to determine the

Line 2002: 'from fii_cost_center_grants '||l_rtn||

1998:
1999: if(p_viewby <> 'ORGANIZATION+HRI_CL_ORGCC') then
2000: if(p_cost_center_id = 'All') then
2001: l_viewby_sql := 'select cost_center_id, aggregated_flag cc_agg_flag '||l_rtn||
2002: 'from fii_cost_center_grants '||l_rtn||
2003: 'where user_id = fnd_global.user_id '||l_rtn||
2004: 'and report_region_code = ®IONCODE';
2005: select count(*) into l_non_agrt_nodes
2006: from fii_cost_center_grants

Line 2006: from fii_cost_center_grants

2002: 'from fii_cost_center_grants '||l_rtn||
2003: 'where user_id = fnd_global.user_id '||l_rtn||
2004: 'and report_region_code = ®IONCODE';
2005: select count(*) into l_non_agrt_nodes
2006: from fii_cost_center_grants
2007: where user_id = fnd_global.user_id
2008: and report_region_code = p_region_code
2009: and aggregated_flag = 'N';
2010: else

Line 2023: from fii_cost_center_grants

2019: else
2020: if(p_cost_center_id = 'All') then
2021:
2022: select count(1) into l_cost_center_count
2023: from fii_cost_center_grants
2024: where user_id = fnd_global.user_id
2025: and report_region_code = p_region_code;
2026:
2027: if(l_cost_center_count = 1) then

Line 2030: from fii_cost_center_grants

2026:
2027: if(l_cost_center_count = 1) then
2028:
2029: select to_char(cost_center_id) into l_top_node
2030: from fii_cost_center_grants
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

Line 2060: 'from fii_cost_center_grants '||l_rtn||

2056: and aggregate_next_level_flag = 'N';
2057: end if;
2058: else
2059: l_viewby_sql := 'select cost_center_id, aggregated_flag cc_agg_flag '||l_rtn||
2060: 'from fii_cost_center_grants '||l_rtn||
2061: 'where user_id = fnd_global.user_id '||l_rtn||
2062: 'and report_region_code = ®IONCODE';
2063: select count(*) into l_non_agrt_nodes
2064: from fii_cost_center_grants

Line 2064: from fii_cost_center_grants

2060: 'from fii_cost_center_grants '||l_rtn||
2061: 'where user_id = fnd_global.user_id '||l_rtn||
2062: 'and report_region_code = ®IONCODE';
2063: select count(*) into l_non_agrt_nodes
2064: from fii_cost_center_grants
2065: where user_id = fnd_global.user_id
2066: and report_region_code = p_region_code
2067: and aggregated_flag = 'N';
2068: end if;

Line 2360: from fii_cost_center_grants

2356:
2357: /* check how many cost-centers the user has access to
2358: */
2359: select count(1) into l_count
2360: from fii_cost_center_grants
2361: where user_id = fnd_global.user_id
2362: and report_region_code = l_region_code;
2363:
2364: if (l_count = 1) then

Line 2366: from fii_cost_center_grants

2362: and report_region_code = l_region_code;
2363:
2364: if (l_count = 1) then
2365: select to_char(cost_center_id) into l_top_cost_ctr_value
2366: from fii_cost_center_grants
2367: where user_id = fnd_global.user_id
2368: and report_region_code = l_region_code;
2369: else
2370: /* if the user does not have access to exactly one cost-center, then the