APPS.PA_STRUCT_TASK_ROLLUP_PUB dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 124: pa_proj_elem_ver_structure pevst

120: pa_proj_elements ppe,
121: pa_proj_elem_ver_schedule pevs,
122: --bug 4541039
123: pa_object_relationships por,
124: pa_proj_elem_ver_structure pevst
125: --bug 4541039
126: WHERE ppe.project_id = ppev.project_id
127: AND ppe.proj_element_id = ppev.proj_element_id
128: AND ppev.object_type = 'PA_TASKS'

Line 188: ,pa_proj_elem_ver_structure e --bug 4541039

184: UNION ALL
185: SELECT min(d.scheduled_start_date) scheduled_start_date --bug 3967855
186: FROM pa_proj_element_versions c,
187: pa_proj_elem_ver_schedule d
188: ,pa_proj_elem_ver_structure e --bug 4541039
189: WHERE c.project_id = d.project_id
190: AND d.project_id =e.project_id --Bug#6277752 Added for performance
191: AND d.element_version_id = e.element_version_id --Bug#6277752 Added for performance
192: AND d.project_id = cp_lnk_proj_id_to --Bug 3634389 Added for performance

Line 231: ,pa_proj_elem_ver_structure e --bug 4541039

227: UNION ALL
228: SELECT max(d.scheduled_finish_date) scheduled_finish_date --bug 3967855
229: FROM pa_proj_element_versions c,
230: pa_proj_elem_ver_schedule d
231: ,pa_proj_elem_ver_structure e --bug 4541039
232: WHERE c.project_id = d.project_id
233: AND d.project_id =e.project_id --Bug#6277752 Added for performance
234: AND d.element_version_id = e.element_version_id --Bug#6277752 Added for performance
235: AND d.project_id = cp_lnk_proj_id_to --Bug 3634389 Added for performance

Line 1272: FROM pa_proj_elem_ver_structure

1268: get_str_ver_ic_lnk_tasks_rec get_str_ver_ic_lnk_tasks%ROWTYPE;
1269:
1270: CURSOR chk_str_working_ver(cp_proj_id NUMBER, cp_str_ver_id NUMBER) IS
1271: SELECT 1
1272: FROM pa_proj_elem_ver_structure
1273: WHERE project_id = cp_proj_id
1274: -- AND proj_element_id = p_structure_id
1275: AND element_version_id = ( select parent_structure_version_id
1276: from pa_proj_element_versions where element_version_id=cp_str_ver_id) --bug 4287813

Line 1299: FROM pa_proj_elem_ver_structure

1295: --bug 4296915
1296: CURSOR check_pub_str(cp_project_id NUMBER, cp_str_ver_id NUMBER)
1297: IS
1298: SELECT 'x'
1299: FROM pa_proj_elem_ver_structure
1300: WHERE project_id=cp_project_id
1301: AND element_version_id = cp_str_ver_id
1302: AND status_code = 'STRUCTURE_PUBLISHED'
1303: ;

Line 2579: pa_proj_elem_ver_structure b,

2575: IS
2576: --select working verisons from versioned projects
2577: SELECT a.project_id, a.element_version_id, a.prg_level
2578: FROM pa_proj_element_versions a,
2579: pa_proj_elem_ver_structure b,
2580: pa_proj_workplan_attr ppwa,
2581: pa_proj_structure_types ppst,
2582: pa_proj_element_versions c
2583: WHERE

Line 2598: pa_proj_elem_ver_structure b,

2594: UNION
2595: --select published verisons from non-versioned projects
2596: SELECT a.project_id, a.element_version_id, a.prg_level
2597: FROM pa_proj_element_versions a,
2598: pa_proj_elem_ver_structure b,
2599: pa_proj_workplan_attr ppwa,
2600: pa_proj_structure_types ppst,
2601: pa_proj_element_versions c
2602: WHERE