DBA Data[Home] [Help]

APPS.PA_OPPORTUNITY_MGT_PVT dependencies on PA_PROJECT_OPP_ATTRS

Line 400: FROM pa_project_opp_attrs

396: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
397: IS
398: CURSOR c1 IS
399: SELECT opportunity_value, opp_value_currency_code, projfunc_opp_value, projfunc_opp_rate_type, projfunc_opp_rate_date, project_opp_value, project_opp_rate_type, project_opp_rate_date
400: FROM pa_project_opp_attrs
401: WHERE project_id = p_source_project_id;
402:
403: v_c1 c1%ROWTYPE;
404:

Line 523: -- store it in pa_project_opp_attrs.project_opp_value.

519: p_ei_date => v_c1.expected_approval_date,
520: p_gl_date => sysdate,
521: p_org_id => v_c1.org_id);
522: -- Convert pa_projects_all.project_value to prject_currency_code and
523: -- store it in pa_project_opp_attrs.project_opp_value.
524: -- Bug: 4537865
525:
526: l_tmp_number := l_dummy_number ;
527: l_new1_dummy_number := l_tmp_number;