APPS.PA_OPPORTUNITY_MGT_PVT dependencies on PA_PROJECTS

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 156: PA_PROJECTS_MAINT_UTILS.check_currency_name_or_code (

152:
153: END IF;
154:
155: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
156: PA_PROJECTS_MAINT_UTILS.check_currency_name_or_code (
157: p_agreement_currency => p_opp_value_currency_code,
158: p_agreement_currency_name => NULL,
159: p_check_id_flag => 'Y',
160: x_agreement_currency => l_opp_value_currency_code,

Line 450: FROM pa_projects

446: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
447: IS
448: CURSOR c1 IS
449: SELECT project_value, projfunc_currency_code, project_currency_code, expected_approval_date, org_id
450: FROM pa_projects
451: WHERE project_id = p_project_id;
452:
453: v_c1 c1%ROWTYPE;
454:

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 ;

Line 628: AND object_type_to = 'PA_PROJECTS'

624: SELECT object_id_from1 request_id
625: FROM pa_object_relationships
626: WHERE relationship_type = 'A'
627: AND object_type_from = 'PA_PROJECT_REQUESTS'
628: AND object_type_to = 'PA_PROJECTS'
629: AND object_id_to1 = p_project_id;
630:
631: l_request_id NUMBER;
632:

Line 637: AND object_type_to = 'PA_PROJECTS'

633: CURSOR c2 IS
634: SELECT object_relationship_id, record_version_number
635: FROM pa_object_relationships
636: WHERE ((object_type_from = 'PA_PROJECT_REQUESTS'
637: AND object_type_to = 'PA_PROJECTS'
638: AND object_id_from1 = l_request_id
639: AND object_id_to1 = p_project_id) OR
640: (object_type_from = 'PA_PROJECTS'
641: AND object_type_to = 'PA_PROJECT_REQUESTS'

Line 640: (object_type_from = 'PA_PROJECTS'

636: WHERE ((object_type_from = 'PA_PROJECT_REQUESTS'
637: AND object_type_to = 'PA_PROJECTS'
638: AND object_id_from1 = l_request_id
639: AND object_id_to1 = p_project_id) OR
640: (object_type_from = 'PA_PROJECTS'
641: AND object_type_to = 'PA_PROJECT_REQUESTS'
642: AND object_id_from1 = p_project_id
643: AND object_id_to1 = l_request_id))
644: AND relationship_type = 'A'

Line 958: START WITH (object_type_from = 'PA_PROJECTS'

954: SELECT object_type_from, object_type_to
955: FROM pa_object_relationships
956: WHERE relationship_type = 'A'
957: AND relationship_subtype = 'PROJECT_REQUEST'
958: START WITH (object_type_from = 'PA_PROJECTS'
959: AND object_type_to = 'PA_PROJECT_REQUESTS'
960: AND object_id_from1 = p_project_id)
961: CONNECT BY (PRIOR object_id_to1 = object_id_from1
962: AND PRIOR object_id_from1 <> object_id_to1);*/

Line 967: START WITH (object_type_from = 'PA_PROJECTS'

963:
964: CURSOR c1 IS
965: SELECT object_type_from, object_type_to
966: FROM pa_object_relationships
967: START WITH (object_type_from = 'PA_PROJECTS'
968: AND object_type_to = 'PA_PROJECT_REQUESTS'
969: AND object_id_from1 = p_project_id)
970: CONNECT BY (PRIOR object_id_to1 = object_id_from1
971: AND PRIOR object_id_from1 <> object_id_to1