APPS.PA_PROGRESS_PVT dependencies on PA_BUDGET_VERSIONS

Line 9750: FROM pa_budget_versions

9746: CURSOR budget_version_info_cur(c_str_ver_id NUMBER) IS
9747: SELECT resource_list_id,
9748: etc_start_date,
9749: budget_version_id
9750: FROM pa_budget_versions
9751: WHERE project_id = p_project_id
9752: AND wp_version_flag = 'Y'
9753: AND project_structure_version_id = c_str_ver_id;
9754:

Line 10152: FROM PA_BUDGET_VERSIONS

10148: 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);
10149: END IF;
10150:
10151: SELECT budget_version_id into l_bv_id
10152: FROM PA_BUDGET_VERSIONS
10153: WHERE project_id = P_PROJECT_ID
10154: AND project_structure_version_id = p_target_struct_ver_id
10155: AND nvl(wp_version_flag,'N') = 'Y';
10156:

Line 10161: UPDATE pa_budget_versions

10157: IF l_debug_mode = 'Y' THEN
10158: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.copy_actuals_for_workplan', x_Msg => 'l_bv_id='||l_bv_id, x_Log_Level=> 3);
10159: END IF;
10160:
10161: UPDATE pa_budget_versions
10162: SET etc_start_date = l_as_of_date + 1
10163: WHERE budget_version_id = l_bv_id;
10164:
10165: IF l_debug_mode = 'Y' THEN

Line 10166: 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);

10162: SET etc_start_date = l_as_of_date + 1
10163: WHERE budget_version_id = l_bv_id;
10164:
10165: IF l_debug_mode = 'Y' THEN
10166: 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);
10167: END IF;
10168:
10169: --bug 4255329
10170: