APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_BUDGET_VERSIONS

Line 1096: FROM pa_budget_versions bud

1092: BETWEEN l_project_num_from AND l_project_num_to
1093: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1094: AND x_budgets_flag = 'Y'
1095: AND EXISTS (SELECT 'x'
1096: FROM pa_budget_versions bud
1097: WHERE bud.project_id = proj.project_id
1098: AND bud.current_flag = 'Y'
1099: AND bud.resource_accumulated_flag = 'N')
1100: UNION ALL

Line 1705: UPDATE Pa_Budget_Versions

1701:
1702: -- Mark all budgets to be accumulated
1703: -- When the accumulation period is changed
1704:
1705: UPDATE Pa_Budget_Versions
1706: SET Resource_Accumulated_Flag ='N'
1707: WHERE Project_id = l_project_id
1708: AND (Current_Flag = 'Y' OR current_original_flag = 'Y');
1709:

Line 2514: UPDATE Pa_Budget_Versions

2510: RETURN;
2511: END IF; -- IF(x_reporting_period_status = 'Y')
2512:
2513:
2514: UPDATE Pa_Budget_Versions
2515: SET Resource_Accumulated_Flag ='N'
2516: WHERE Project_id = projrec.project_id AND
2517: (Current_Flag = 'Y' OR current_original_flag = 'Y');
2518: