APPS.OKE_PA_CHECKS_PUB dependencies on PA_OBJECT_RELATIONSHIPS

Line 163: FROM pa_object_relationships

159: SELECT 'x' FROM dual
160: WHERE p_to_proj IN (
161: SELECT object_id_to1 prj_id FROM (
162: SELECT *
163: FROM pa_object_relationships
164: WHERE NOT (object_id_from2=p_delf_proj AND object_id_from1=p_delf_task AND object_id_to1=p_delt_proj)
165: )
166: WHERE object_type_from = 'PA_TASKS'
167: AND object_type_to = 'PA_PROJECTS'

Line 177: FROM pa_object_relationships p

173: CONNECT BY object_id_from2 = PRIOR object_id_to1
174: UNION ALL
175: SELECT object_id_to2 prj_id FROM (
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

Line 265: FROM pa_object_relationships

261: UNION ALL
262: SELECT k_header_id header_id, NULL, bill_project_id FROM oke_k_billing_events
263: ) WHERE project_id IN (
264: SELECT to_number(object_id_to1) project_id
265: FROM pa_object_relationships
266: WHERE object_type_from = 'PA_TASKS'
267: AND object_type_to = 'PA_PROJECTS'
268: AND relationship_type = 'H'
269: START WITH object_id_from2 = p_project_ID

Line 273: FROM PA_OBJECT_RELATIONSHIPS p

269: START WITH object_id_from2 = p_project_ID
270: CONNECT BY object_id_from2 = PRIOR object_id_to1
271: UNION ALL
272: SELECT TO_NUMBER(OBJECT_ID_TO2) PROJECT_ID
273: FROM PA_OBJECT_RELATIONSHIPS p
274: START WITH OBJECT_TYPE_FROM = 'PA_STRUCTURES' AND object_id_from1 IN
275: (SELECT element_version_id
276: FROM pa_proj_elem_ver_structure ppevs
277: WHERE ppevs.project_id=p_project_ID