APPS.POA_DBI_SUTIL_PKG dependencies on FII_COM_PMV_AGRT_NODES

Line 563: from fnd_flex_values_tl t, fii_com_pmv_agrt_nodes c, fnd_flex_values f

559: WHEN 'LOOKUP+CONTRACT_DOCTYPE' THEN 'poa_dbi_contract_type_v'
560: WHEN 'POA_PERSON+REQUESTER' 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)'
561: WHEN 'FII_COMPANIES+FII_COMPANIES' THEN
562: '(select t.flex_value_id id, t.description value, f.summary_flag
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

Line 1884: 'from fii_com_pmv_agrt_nodes '||l_rtn||

1880: and report_region_code = p_region_code
1881: and aggregated_flag = 'N';
1882: else
1883: l_viewby_sql := 'select company_id, aggregated_flag com_agg_flag '||l_rtn||
1884: 'from fii_com_pmv_agrt_nodes '||l_rtn||
1885: 'where company_id = &COMPANYID';
1886: select count(*) into l_non_agrt_nodes
1887: from fii_com_pmv_agrt_nodes
1888: where company_id = to_number(p_company_id)

Line 1887: from fii_com_pmv_agrt_nodes

1883: l_viewby_sql := 'select company_id, aggregated_flag com_agg_flag '||l_rtn||
1884: 'from fii_com_pmv_agrt_nodes '||l_rtn||
1885: 'where company_id = &COMPANYID';
1886: select count(*) into l_non_agrt_nodes
1887: from fii_com_pmv_agrt_nodes
1888: where company_id = to_number(p_company_id)
1889: and aggregated_flag = 'N';
1890: end if;
1891: else

Line 1913: 'from fii_com_pmv_agrt_nodes '||l_rtn||

1909: and parent_company_id = child_company_id;
1910:
1911: if(l_leaf_flag = 'Y') then
1912: l_viewby_sql := 'select company_id, aggregated_flag com_agg_flag '||l_rtn||
1913: 'from fii_com_pmv_agrt_nodes '||l_rtn||
1914: 'where company_id = &TOPCOMPANYID';
1915: select count(*) into l_non_agrt_nodes
1916: from fii_com_pmv_agrt_nodes
1917: where company_id = l_top_node

Line 1916: from fii_com_pmv_agrt_nodes

1912: l_viewby_sql := 'select company_id, aggregated_flag com_agg_flag '||l_rtn||
1913: 'from fii_com_pmv_agrt_nodes '||l_rtn||
1914: 'where company_id = &TOPCOMPANYID';
1915: select count(*) into l_non_agrt_nodes
1916: from fii_com_pmv_agrt_nodes
1917: where company_id = l_top_node
1918: and aggregated_flag = 'N';
1919: else
1920: l_viewby_sql := 'select parent_company_id, child_company_id company_id, aggregate_next_level_flag com_agg_flag '||l_rtn||

Line 1948: 'from fii_com_pmv_agrt_nodes '||l_rtn||

1944: where parent_company_id = to_number(p_company_id)
1945: and parent_company_id = child_company_id;
1946: if(l_leaf_flag = 'Y') then
1947: l_viewby_sql := 'select company_id, aggregated_flag com_agg_flag '||l_rtn||
1948: 'from fii_com_pmv_agrt_nodes '||l_rtn||
1949: 'where company_id = &COMPANYID';
1950: select count(*) into l_non_agrt_nodes
1951: from fii_com_pmv_agrt_nodes
1952: where company_id = to_number(p_company_id)

Line 1951: from fii_com_pmv_agrt_nodes

1947: l_viewby_sql := 'select company_id, aggregated_flag com_agg_flag '||l_rtn||
1948: 'from fii_com_pmv_agrt_nodes '||l_rtn||
1949: 'where company_id = &COMPANYID';
1950: select count(*) into l_non_agrt_nodes
1951: from fii_com_pmv_agrt_nodes
1952: where company_id = to_number(p_company_id)
1953: and aggregated_flag = 'N';
1954: else
1955: l_viewby_sql := 'select parent_company_id, child_company_id company_id, aggregate_next_level_flag com_agg_flag '||l_rtn||