APPS.PA_RELATIONSHIP_UTILS dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 545: FROM pa_proj_elem_ver_structure ppevs

541: AND ppe.link_task_flag = 'Y'
542: AND ppe.project_id = ppv1.project_id
543: AND ppe.proj_element_id = ppv1.proj_element_id
544: AND ppv1.parent_structure_version_id IN ( SELECT ppevs.element_version_id
545: FROM pa_proj_elem_ver_structure ppevs
546: WHERE ppevs.project_id = p_parent_project_id
547: AND ppevs.status_code = 'STRUCTURE_PUBLISHED'
548: AND ppevs.latest_eff_published_flag = 'Y' )
549: AND ppv2.project_id = p_sub_project_id

Line 1400: from pa_proj_elem_ver_structure ppevs, pa_proj_element_versions ppev

1396: -- Begin Fix for Bug # 4297715.
1397:
1398: cursor cur_get_status_code(c_task_version_id NUMBER) is
1399: select ppevs.status_code
1400: from pa_proj_elem_ver_structure ppevs, pa_proj_element_versions ppev
1401: where ppev.element_version_id = c_task_version_id
1402: and ppev.project_id = ppevs.project_id -- Bug # 4868867.
1403: and ppev.parent_structure_version_id = ppevs.element_version_id;
1404:

Line 2108: from pa_proj_element_versions pev, pa_object_relationships por, pa_proj_elem_ver_structure ppevs

2104:
2105: select 1
2106: from dual
2107: where exists (select 1
2108: from pa_proj_element_versions pev, pa_object_relationships por, pa_proj_elem_ver_structure ppevs
2109: where pev.parent_structure_version_id = c_object_id_from
2110: and pev.element_version_id = por.object_id_from1
2111: and por.object_id_to1 = ppevs.element_version_id
2112: -- Bug Fix 5077552

Line 2130: ,pa_proj_elem_ver_structure ppevs

2126: and relationship_type in (c_relationship_type, 'S')
2127: start with por.object_id_from1 = c_object_id_from
2128: connect by prior por.object_id_to1 = por.object_id_from1
2129: and prior relationship_type in (c_relationship_type, 'S')) por
2130: ,pa_proj_elem_ver_structure ppevs
2131: where
2132: por.object_id_to1 = ppevs.element_version_id (+);
2133:
2134: select ppevs.status_code status_code

Line 2135: from pa_object_relationships por, pa_proj_elem_ver_structure ppevs

2131: where
2132: por.object_id_to1 = ppevs.element_version_id (+);
2133:
2134: select ppevs.status_code status_code
2135: from pa_object_relationships por, pa_proj_elem_ver_structure ppevs
2136: where por.object_id_to1 = ppevs.element_version_id (+)
2137: and por.object_type_to = 'PA_STRUCTURES'
2138: and relationship_type in (c_relationship_type, 'S')
2139: start with por.object_id_from1 = c_object_id_from