APPS.PA_PROGRESS_PVT dependencies on PA_BUDGET_VERSIONS

Line 9684: FROM pa_budget_versions

9680: CURSOR budget_version_info_cur(c_str_ver_id NUMBER) IS
9681: SELECT resource_list_id,
9682: etc_start_date,
9683: budget_version_id
9684: FROM pa_budget_versions
9685: WHERE project_id = p_project_id
9686: AND wp_version_flag = 'Y'
9687: AND project_structure_version_id = c_str_ver_id;
9688:

Line 10084: FROM PA_BUDGET_VERSIONS

10080: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.copy_actuals_for_workplan', x_Msg => 'l_as_of_date='||l_as_of_date, x_Log_Level=> 3);
10081: END IF;
10082:
10083: SELECT budget_version_id into l_bv_id
10084: FROM PA_BUDGET_VERSIONS
10085: WHERE project_id = P_PROJECT_ID
10086: AND project_structure_version_id = p_target_struct_ver_id
10087: AND nvl(wp_version_flag,'N') = 'Y';
10088:

Line 10093: UPDATE pa_budget_versions

10089: IF l_debug_mode = 'Y' THEN
10090: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.copy_actuals_for_workplan', x_Msg => 'l_bv_id='||l_bv_id, x_Log_Level=> 3);
10091: END IF;
10092:
10093: UPDATE pa_budget_versions
10094: SET etc_start_date = l_as_of_date + 1
10095: WHERE budget_version_id = l_bv_id;
10096:
10097: IF l_debug_mode = 'Y' THEN

Line 10098: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.copy_actuals_for_workplan', x_Msg => 'Done with updating pa_budget_versions ETC start date', x_Log_Level=> 3);

10094: SET etc_start_date = l_as_of_date + 1
10095: WHERE budget_version_id = l_bv_id;
10096:
10097: IF l_debug_mode = 'Y' THEN
10098: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.copy_actuals_for_workplan', x_Msg => 'Done with updating pa_budget_versions ETC start date', x_Log_Level=> 3);
10099: END IF;
10100:
10101: --bug 4255329
10102: