APPS.PA_STRUCT_TASK_ROLLUP_PUB dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 126: pa_proj_elem_ver_structure pevst

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

Line 190: ,pa_proj_elem_ver_structure e --bug 4541039

186: UNION ALL
187: SELECT min(d.scheduled_start_date) scheduled_start_date --bug 3967855
188: FROM pa_proj_element_versions c,
189: pa_proj_elem_ver_schedule d
190: ,pa_proj_elem_ver_structure e --bug 4541039
191: WHERE c.project_id = d.project_id
192: AND d.project_id =e.project_id --Bug#6277752 Added for performance
193: AND d.element_version_id = e.element_version_id --Bug#6277752 Added for performance
194: AND E.PROJECT_ID=C.PROJECT_ID --Bug 7607077

Line 234: ,pa_proj_elem_ver_structure e --bug 4541039

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

Line 1319: FROM pa_proj_elem_ver_structure

1315: get_str_ver_ic_lnk_tasks_rec get_str_ver_ic_lnk_tasks%ROWTYPE;
1316:
1317: CURSOR chk_str_working_ver(cp_proj_id NUMBER, cp_str_ver_id NUMBER) IS
1318: SELECT 1
1319: FROM pa_proj_elem_ver_structure
1320: WHERE project_id = cp_proj_id
1321: -- AND proj_element_id = p_structure_id
1322: AND element_version_id = ( select parent_structure_version_id
1323: from pa_proj_element_versions where element_version_id=cp_str_ver_id) --bug 4287813

Line 1346: FROM pa_proj_elem_ver_structure

1342: --bug 4296915
1343: CURSOR check_pub_str(cp_project_id NUMBER, cp_str_ver_id NUMBER)
1344: IS
1345: SELECT 'x'
1346: FROM pa_proj_elem_ver_structure
1347: WHERE project_id=cp_project_id
1348: AND element_version_id = cp_str_ver_id
1349: AND status_code = 'STRUCTURE_PUBLISHED'
1350: ;

Line 2734: pa_proj_elem_ver_structure b,

2730: IS
2731: --select working verisons from versioned projects
2732: SELECT a.project_id, a.element_version_id, a.prg_level
2733: FROM pa_proj_element_versions a,
2734: pa_proj_elem_ver_structure b,
2735: pa_proj_workplan_attr ppwa,
2736: pa_proj_structure_types ppst,
2737: pa_proj_element_versions c,
2738: pa_proj_elem_ver_structure b1,

Line 2738: pa_proj_elem_ver_structure b1,

2734: pa_proj_elem_ver_structure b,
2735: pa_proj_workplan_attr ppwa,
2736: pa_proj_structure_types ppst,
2737: pa_proj_element_versions c,
2738: pa_proj_elem_ver_structure b1,
2739: pa_proj_workplan_attr ppwa1,
2740: pa_proj_structure_types ppst1
2741: WHERE
2742: c.project_id = p_project_id

Line 2767: pa_proj_elem_ver_structure b,

2763: UNION
2764: --select published verisons from non-versioned projects
2765: SELECT a.project_id, a.element_version_id, a.prg_level
2766: FROM pa_proj_element_versions a,
2767: pa_proj_elem_ver_structure b,
2768: pa_proj_workplan_attr ppwa,
2769: pa_proj_structure_types ppst,
2770: pa_proj_element_versions c,
2771: pa_proj_elem_ver_structure b1,

Line 2771: pa_proj_elem_ver_structure b1,

2767: pa_proj_elem_ver_structure b,
2768: pa_proj_workplan_attr ppwa,
2769: pa_proj_structure_types ppst,
2770: pa_proj_element_versions c,
2771: pa_proj_elem_ver_structure b1,
2772: pa_proj_workplan_attr ppwa1,
2773: pa_proj_structure_types ppst1
2774: WHERE
2775: c.project_id = p_project_id