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 1385: from pa_proj_elem_ver_structure ppevs, pa_proj_element_versions ppev

1381: -- Begin Fix for Bug # 4297715.
1382:
1383: cursor cur_get_status_code(c_task_version_id NUMBER) is
1384: select ppevs.status_code
1385: from pa_proj_elem_ver_structure ppevs, pa_proj_element_versions ppev
1386: where ppev.element_version_id = c_task_version_id
1387: and ppev.project_id = ppevs.project_id -- Bug # 4868867.
1388: and ppev.parent_structure_version_id = ppevs.element_version_id;
1389:

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

2089:
2090: select 1
2091: from dual
2092: where exists (select 1
2093: from pa_proj_element_versions pev, pa_object_relationships por, pa_proj_elem_ver_structure ppevs
2094: where pev.parent_structure_version_id = c_object_id_from
2095: and pev.element_version_id = por.object_id_from1
2096: and por.object_id_to1 = ppevs.element_version_id
2097: -- Bug Fix 5077552

Line 2115: ,pa_proj_elem_ver_structure ppevs

2111: and relationship_type in (c_relationship_type, 'S')
2112: start with por.object_id_from1 = c_object_id_from
2113: connect by prior por.object_id_to1 = por.object_id_from1
2114: and prior relationship_type in (c_relationship_type, 'S')) por
2115: ,pa_proj_elem_ver_structure ppevs
2116: where
2117: por.object_id_to1 = ppevs.element_version_id (+);
2118:
2119: select ppevs.status_code status_code

Line 2120: from pa_object_relationships por, pa_proj_elem_ver_structure ppevs

2116: where
2117: por.object_id_to1 = ppevs.element_version_id (+);
2118:
2119: select ppevs.status_code status_code
2120: from pa_object_relationships por, pa_proj_elem_ver_structure ppevs
2121: where por.object_id_to1 = ppevs.element_version_id (+)
2122: and por.object_type_to = 'PA_STRUCTURES'
2123: and relationship_type in (c_relationship_type, 'S')
2124: start with por.object_id_from1 = c_object_id_from