APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_BUDGET_VERSIONS

Line 1132: FROM pa_budget_versions bud

1128: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1129: AND x_budgets_flag = 'Y'
1130: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684
1131: AND EXISTS (SELECT 'x'
1132: FROM pa_budget_versions bud
1133: WHERE bud.project_id = proj.project_id
1134: AND bud.current_flag = 'Y'
1135: AND bud.resource_accumulated_flag = 'N')
1136: UNION ALL

Line 1748: UPDATE Pa_Budget_Versions

1744:
1745: -- Mark all budgets to be accumulated
1746: -- When the accumulation period is changed
1747:
1748: UPDATE Pa_Budget_Versions
1749: SET Resource_Accumulated_Flag ='N'
1750: WHERE Project_id = l_project_id
1751: AND (Current_Flag = 'Y' OR current_original_flag = 'Y');
1752:

Line 2577: UPDATE Pa_Budget_Versions

2573: RETURN;
2574: END IF; -- IF(x_reporting_period_status = 'Y')
2575:
2576:
2577: UPDATE Pa_Budget_Versions
2578: SET Resource_Accumulated_Flag ='N'
2579: WHERE Project_id = projrec.project_id AND
2580: (Current_Flag = 'Y' OR current_original_flag = 'Y');
2581: