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 ra.budget_version_id = bv.budget_version_id

Line 604: ,PA_PROJ_ELEM_VER_STRUCTURE evs

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

Line 1133: l_structure_ver_name pa_proj_elem_ver_structure.name%type;

1129: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1130: l_rate_incurred_by_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1131:
1132: -- Added for Bug 6856934
1133: l_structure_ver_name pa_proj_elem_ver_structure.name%type;
1134:
1135: BEGIN
1136: l_overall_return_status := FND_API.G_RET_STS_SUCCESS;
1137:

Line 1419: from pa_proj_elem_ver_structure ppevs

1415: IF p_mode <> 'CREATE' THEN
1416: -- Bug 6856934
1417: Begin
1418: select ppevs.name into l_structure_ver_name
1419: from pa_proj_elem_ver_structure ppevs
1420: where ppevs.project_id = l_project_id
1421: and ppevs.element_version_id = l_last_struct_version_id;
1422: Exception when NO_DATA_FOUND then
1423: null;