APPS.PJI_LAUNCH_UPP_MAIN dependencies on PJI_FP_XBS_ACCUM_F

Line 752: tabname => 'PJI_FP_XBS_ACCUM_F',

748: /* Code added for bug 8416116 starts */
749: if (mod(g_stat_count,10) = 0) then
750:
751: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
752: tabname => 'PJI_FP_XBS_ACCUM_F',
753: percent => 5,
754: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
755:
756: end if;

Line 1757: FROM pji_fp_xbs_accum_f f,

1753: group by ver.project_id) budgets
1754: LEFT OUTER JOIN
1755: (SELECT f.project_id, p.project_status_code,
1756: Sum(brdn_cost) cost
1757: FROM pji_fp_xbs_accum_f f,
1758: pa_projects_all p
1759: WHERE plan_version_id = -3
1760: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(p.project_status_code,'STATUS_REPORTING') = 'Y'
1761: AND rbs_aggr_level = 'T'

Line 1802: FROM pji_fp_xbs_accum_f f,

1798: group by ver.project_id) budgets
1799: LEFT OUTER JOIN
1800: (SELECT f.project_id, p.project_status_code,
1801: Sum(revenue) revenue
1802: FROM pji_fp_xbs_accum_f f,
1803: pa_projects_all p
1804: WHERE plan_version_id = -3
1805: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(p.project_status_code,'STATUS_REPORTING') = 'Y'
1806: AND rbs_aggr_level = 'T'

Line 1848: pji_fp_xbs_accum_f f

1844: /*+ ordered */
1845: brdn_cost amt,
1846: f.project_id
1847: FROM pa_projects_all p ,
1848: pji_fp_xbs_accum_f f
1849: WHERE p.project_id = f.project_id
1850: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(p.project_status_code,'STATUS_REPORTING') = 'Y'
1851: AND f.currency_code = p.projfunc_currency_code
1852: AND f.plan_type_id = -1

Line 1882: FROM pji_fp_xbs_accum_f f

1878: Sum(Nvl(act_labor_hrs,0)) act_ppl_effort,
1879: Sum(Nvl(act_equip_hrs,0)) act_eq_effort,
1880: Sum(Nvl(act_raw_cost,0)) act_raw_cost,
1881: Sum(Nvl(act_brdn_cost,0)) act_brdn_cost
1882: FROM pji_fp_xbs_accum_f f
1883: WHERE plan_version_id IN (SELECT budget_version_id
1884: FROM pa_budget_versions bv
1885: WHERE bv.project_id = f.project_id
1886: AND project_structure_version_id =

Line 1932: FROM pji_fp_xbs_accum_f f

1928: Sum(Nvl(act_labor_hrs,0)) act_ppl_effort,
1929: Sum(Nvl(act_equip_hrs,0)) act_eq_effort,
1930: Sum(Nvl(act_raw_cost,0)) act_raw_cost,
1931: Sum(Nvl(act_brdn_cost,0)) act_brdn_cost
1932: FROM pji_fp_xbs_accum_f f
1933: WHERE plan_type_id IN (SELECT fin_plan_type_id
1934: FROM pa_fin_plan_types_b
1935: WHERE primary_cost_forecast_flag = 'Y')
1936: AND plan_version_id = -3

Line 2275: delete PJI_FP_XBS_ACCUM_F where project_id = v_project_id(i);

2271:
2272:
2273: If v_project_id.COUNT > 0 THEN
2274: FOR i in v_project_id.FIRST..v_project_id.LAST loop
2275: delete PJI_FP_XBS_ACCUM_F where project_id = v_project_id(i);
2276: commit;
2277:
2278: delete PJI_AC_XBS_ACCUM_F where project_id = v_project_id(i);
2279: commit;