DBA Data[Home] [Help]

APPS.OKE_PA_CHECKS_PUB dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 180: FROM pa_tasks pt, pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs

176: SELECT *
177: FROM pa_object_relationships p
178: WHERE NOT (object_id_to2=p_delt_proj AND object_type_from = 'PA_TASKS'
179: AND object_id_from1 IN (SELECT ppev.element_version_id
180: FROM pa_tasks pt, pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
181: WHERE ppev.proj_element_id = pt.task_id
182: AND pt.top_task_id = nvl(p_delf_task, pt.top_task_id)
183: AND pt.task_id = pt.top_task_id
184: AND pt.project_id = p_delf_proj

Line 192: FROM pa_tasks pt, pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs

188: AND ppevs.latest_eff_published_flag = 'Y' ))
189: )
190: START WITH object_type_from = 'PA_TASKS' AND object_id_from1
191: IN (SELECT ppev.element_version_id
192: FROM pa_tasks pt, pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
193: WHERE ppev.proj_element_id = pt.task_id
194: AND pt.top_task_id = nvl(p_from_task, pt.top_task_id)
195: AND pt.task_id = pt.top_task_id
196: AND pt.project_id = p_from_proj