APPS.PA_ASSIGNMENTS_PVT dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 589: ,PA_PROJ_ELEM_VER_STRUCTURE evs

585: (
586: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
587: FROM PA_RESOURCE_ASSIGNMENTS ra
588: ,PA_BUDGET_VERSIONS bv
589: ,PA_PROJ_ELEM_VER_STRUCTURE evs
590: -- ,PA_PROJECT_ASSIGNMENTS pa -- 5110598 Removed PA_PROJECT_ASSIGNMENTS table usage
591: WHERE ra.project_id = bv.project_id
592: AND bv.project_id = evs.project_id
593: AND bv.budget_type_code IS NULL -- added for bug#8247628

Line 605: ,PA_PROJ_ELEM_VER_STRUCTURE evs

601: UNION ALL
602: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
603: FROM PA_RESOURCE_ASSIGNMENTS ra
604: ,PA_BUDGET_VERSIONS bv
605: ,PA_PROJ_ELEM_VER_STRUCTURE evs
606: ,PA_PROJ_WORKPLAN_ATTR pwa
607: -- ,PA_PROJECT_ASSIGNMENTS pa -- 5110598 Removed PA_PROJECT_ASSIGNMENTS table usage
608: WHERE pwa.wp_enable_Version_flag = 'N'
609: AND pwa.project_id = ra.project_id

Line 1141: l_structure_ver_name pa_proj_elem_ver_structure.name%type;

1137: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1138: l_rate_incurred_by_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1139:
1140: -- Added for Bug 6856934
1141: l_structure_ver_name pa_proj_elem_ver_structure.name%type;
1142:
1143: BEGIN
1144: l_overall_return_status := FND_API.G_RET_STS_SUCCESS;
1145:

Line 1427: from pa_proj_elem_ver_structure ppevs

1423: IF p_mode <> 'CREATE' THEN
1424: -- Bug 6856934
1425: Begin
1426: select ppevs.name into l_structure_ver_name
1427: from pa_proj_elem_ver_structure ppevs
1428: where ppevs.project_id = l_project_id
1429: and ppevs.element_version_id = l_last_struct_version_id;
1430: Exception when NO_DATA_FOUND then
1431: null;