APPS.PJI_LAUNCH_UPP_MAIN dependencies on PA_BUDGET_VERSIONS

Line 1245: from pa_budget_versions pbv,

1241:
1242: l_curr_lines_cnt := 0;
1243: select count(*)
1244: into l_curr_lines_cnt
1245: from pa_budget_versions pbv,
1246: pa_budget_lines pbl
1247: where pbv.project_id = l_prj_list(a) and
1248: pbv.budget_version_id = pbl.budget_version_id;
1249:

Line 1341: from pa_budget_versions pbv,

1337: l_curr_lines_cnt := 0;
1338:
1339: select count(*)
1340: into l_curr_lines_cnt
1341: from pa_budget_versions pbv,
1342: pa_budget_lines pbl
1343: where pbv.project_id = k.project_id
1344: and pbv.budget_version_id = pbl.budget_version_id;
1345:

Line 1744: FROM pa_budget_versions ver,

1740: reporting.cost REPORTING_COST,
1741: budgets.cost - reporting.cost cost_diff_budgets
1742: FROM (SELECT ver.project_id,
1743: sum(ver.burdened_cost) cost
1744: FROM pa_budget_versions ver,
1745: pa_projects_all ppa
1746: WHERE ver.budget_status_code = 'B'
1747: and ver.project_id = ppa.project_id
1748: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(ppa.project_status_code,'STATUS_REPORTING') = 'Y'

Line 1789: FROM pa_budget_versions ver,

1785: reporting.revenue REPORTING_REVENUE,
1786: budgets.revenue - reporting.revenue rev_diff_budgets
1787: FROM (SELECT ver.project_id,
1788: sum(ver.revenue) revenue
1789: FROM pa_budget_versions ver,
1790: pa_projects_all ppa
1791: WHERE ver.budget_status_code = 'B'
1792: and ver.project_id = ppa.project_id
1793: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(ppa.project_status_code,'STATUS_REPORTING') = 'Y'

Line 1884: FROM pa_budget_versions bv

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 =
1887: PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(f.project_id))
1888: AND rbs_version_id = -1 AND time_id = -1

Line 1904: FROM pa_budget_versions bv

1900: Sum(Nvl(init_raw_cost,0)) act_raw_cost,
1901: Sum(Nvl(init_burdened_cost,0)) act_brdn_cost
1902: FROM pa_budget_lines bl, pa_resource_assignments res
1903: WHERE bl.budget_version_id IN (SELECT budget_version_id
1904: FROM pa_budget_versions bv
1905: WHERE bv.project_id = res.project_id
1906: AND project_structure_version_id =
1907: PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(bv.project_id))
1908: AND bl.budget_version_id = res.budget_version_id

Line 1949: FROM pa_budget_versions bv

1945: Sum(Nvl(init_raw_cost,0)) act_raw_cost,
1946: Sum(Nvl(init_burdened_cost,0)) act_brdn_cost
1947: FROM pa_budget_lines bl, pa_resource_assignments res
1948: WHERE bl.budget_version_id IN (SELECT budget_version_id
1949: FROM pa_budget_versions bv
1950: WHERE bv.project_id = res.project_id
1951: AND budget_status_code = 'B'
1952: AND current_flag = 'Y'
1953: AND fin_plan_type_id IN (SELECT fin_plan_type_id

Line 2537: FROM PA_BUDGET_VERSIONS a1

2533: 'PROJ_BASE',
2534: - 1,
2535: project_id,
2536: - 1
2537: FROM PA_BUDGET_VERSIONS a1
2538: WHERE budget_status_code = 'B' AND
2539: pji_summarized_flag = 'P' AND
2540: NOT EXISTS
2541: (SELECT 'x' FROM