DBA Data[Home] [Help]

APPS.PA_OPPORTUNITY_MGT_PVT dependencies on PA_PROJECTS_ALL

Line 37: FROM pa_projects_all -- Bug#3807805 Modified pa_projects to pa_projects_all

33: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
34: IS
35: CURSOR c1 IS
36: SELECT projfunc_currency_code, project_currency_code, org_id, probability_member_id
37: FROM pa_projects_all -- Bug#3807805 Modified pa_projects to pa_projects_all
38: WHERE project_id = p_project_id;
39:
40: v_c1 c1%ROWTYPE;
41: l_opp_value_currency_code FND_CURRENCIES_VL.currency_code%TYPE;

Line 522: -- Convert pa_projects_all.project_value to prject_currency_code and

518: l_conversion_date := PA_UTILS2.get_pa_date(
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 ;