APPS.POA_DBI_SUTIL_PKG dependencies on FII_COMPANY_GRANTS

Line 1622: from fii_company_grants

1618: */
1619: return '0';
1620: else
1621: select count(*) into l_count
1622: from fii_company_grants
1623: where user_id = fnd_global.user_id
1624: and company_id = to_number(p_id)
1625: and report_region_code = 'POA_DBI_INV_STATUS';
1626: /* we are using Invoice Amount report as a reference to determine the

Line 1874: 'from fii_company_grants '||l_rtn||

1870:
1871: if(p_viewby <> 'FII_COMPANIES+FII_COMPANIES') then
1872: if(p_company_id = 'All') then
1873: l_viewby_sql := 'select company_id, aggregated_flag com_agg_flag '||l_rtn||
1874: 'from fii_company_grants '||l_rtn||
1875: 'where user_id = fnd_global.user_id '||l_rtn||
1876: 'and report_region_code = ®IONCODE';
1877: select count(*) into l_non_agrt_nodes
1878: from fii_company_grants

Line 1878: from fii_company_grants

1874: 'from fii_company_grants '||l_rtn||
1875: 'where user_id = fnd_global.user_id '||l_rtn||
1876: 'and report_region_code = ®IONCODE';
1877: select count(*) into l_non_agrt_nodes
1878: from fii_company_grants
1879: where user_id = fnd_global.user_id
1880: and report_region_code = p_region_code
1881: and aggregated_flag = 'N';
1882: else

Line 1895: from fii_company_grants

1891: else
1892: if(p_company_id = 'All') then
1893:
1894: select count(1) into l_company_count
1895: from fii_company_grants
1896: where user_id = fnd_global.user_id
1897: and report_region_code = p_region_code;
1898:
1899: if(l_company_count = 1) then

Line 1902: from fii_company_grants

1898:
1899: if(l_company_count = 1) then
1900:
1901: select to_char(company_id) into l_top_node
1902: from fii_company_grants
1903: where user_id = fnd_global.user_id
1904: and report_region_code = p_region_code;
1905:
1906: select is_leaf_flag into l_leaf_flag

Line 1932: 'from fii_company_grants '||l_rtn||

1928: and aggregate_next_level_flag = 'N';
1929: end if;
1930: else
1931: l_viewby_sql := 'select company_id, aggregated_flag com_agg_flag '||l_rtn||
1932: 'from fii_company_grants '||l_rtn||
1933: 'where user_id = fnd_global.user_id '||l_rtn||
1934: 'and report_region_code = ®IONCODE';
1935: select count(*) into l_non_agrt_nodes
1936: from fii_company_grants

Line 1936: from fii_company_grants

1932: 'from fii_company_grants '||l_rtn||
1933: 'where user_id = fnd_global.user_id '||l_rtn||
1934: 'and report_region_code = ®IONCODE';
1935: select count(*) into l_non_agrt_nodes
1936: from fii_company_grants
1937: where user_id = fnd_global.user_id
1938: and report_region_code = p_region_code
1939: and aggregated_flag = 'N';
1940: end if;

Line 2341: from fii_company_grants

2337:
2338: /* check how many companies the user has access to
2339: */
2340: select count(1) into l_count
2341: from fii_company_grants
2342: where user_id = fnd_global.user_id
2343: and report_region_code = l_region_code;
2344:
2345: if (l_count = 1) then

Line 2347: from fii_company_grants

2343: and report_region_code = l_region_code;
2344:
2345: if (l_count = 1) then
2346: select to_char(company_id) into l_top_company_value
2347: from fii_company_grants
2348: where user_id = fnd_global.user_id
2349: and report_region_code = l_region_code;
2350: else
2351: /* if the user does not have access to exactly one company, then the