APPS.FII_BUDGET_FORECAST_C dependencies on FII_CCC_MGR_GT

Line 1786: FROM FII_CCC_MGR_GT cccorg,

1782: -- company_id and cost_center_id of FII_BUDGET_STG
1783: CURSOR ccc_org_cursor IS
1784: SELECT DISTINCT NVL(cccorg.ccc_org_id, -1),
1785: stg.company_id, stg.cost_center_id
1786: FROM FII_CCC_MGR_GT cccorg,
1787: FII_BUDGET_STG stg
1788: WHERE cccorg.company_id (+) = stg.company_id
1789: AND cccorg.cost_center_id (+) = stg.cost_center_id;
1790:

Line 1931: g_phase := 'Populate the temp table FII_CCC_MGR_GT';

1927: END IF;
1928:
1929: -- Bug 5004852: Populate CCC - Mgr mappings temp table before opening the
1930: -- ccc_org_cursor to select company_cost_center_org_id
1931: g_phase := 'Populate the temp table FII_CCC_MGR_GT';
1932: l_status := null;
1933:
1934: FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR (l_status);
1935:

Line 1938: fii_util.write_log('Table FII_CCC_MGR_GT is not populated');

1934: FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR (l_status);
1935:
1936: IF l_status = -1 then
1937: fii_util.write_log('Error in FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR ...');
1938: fii_util.write_log('Table FII_CCC_MGR_GT is not populated');
1939: raise NO_DATA_FOUND;
1940: END IF;
1941:
1942: -- Bug 5004852: Populate company_cost_center_org_id in fii_budget_stg

Line 2108: FROM FII_CCC_MGR_GT cccorg,

2104:
2105: CURSOR ccc_org_cursor IS
2106: SELECT DISTINCT NVL(cccorg.ccc_org_id, -1),
2107: int.company_id, int.cost_center_id
2108: FROM FII_CCC_MGR_GT cccorg,
2109: FII_BUDGET_INTERFACE int
2110: WHERE cccorg.company_id (+) = int.company_id
2111: AND cccorg.cost_center_id (+) = int.cost_center_id
2112: AND int.company_cost_center_org_id IS NULL;

Line 2189: fii_util.write_log('Table FII_CCC_MGR_GT is not populated');

2185: FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR (l_status);
2186:
2187: IF l_status = -1 then
2188: fii_util.write_log('Error in FII_GL_EXTRACTION_UTIL.LOAD_CCC_MGR ...');
2189: fii_util.write_log('Table FII_CCC_MGR_GT is not populated');
2190: raise NO_DATA_FOUND;
2191: END IF;
2192:
2193: g_phase := 'Value to ID Conversion';