APPS.PJI_LAUNCH_UPP_MAIN dependencies on PA_BUDGET_LINES

Line 1246: pa_budget_lines pbl

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:
1250: if (( l_budget_lines_cnt + l_curr_lines_cnt

Line 1342: pa_budget_lines pbl

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:
1346: if (( l_budget_lines_cnt + l_curr_lines_cnt

Line 1902: FROM pa_budget_lines bl, pa_resource_assignments res

1898: Sum(Decode(res.resource_class_code,'PEOPLE',Nvl(init_quantity,0),0)) act_ppl_effort,
1899: Sum(Decode(res.resource_class_code,'EQUIPMENT',Nvl(init_quantity,0),0)) act_eq_effort,
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 =

Line 1947: FROM pa_budget_lines bl, pa_resource_assignments res

1943: Sum(Decode(res.resource_class_code,'PEOPLE',Nvl(init_quantity,0),0)) act_ppl_effort,
1944: Sum(Decode(res.resource_class_code,'EQUIPMENT',Nvl(init_quantity,0),0)) act_eq_effort,
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'