APPS.PA_TASK_WORKFLOW_PKG dependencies on PA_OBJECT_RELATIONSHIPS

Line 1147: FROM PA_PROJ_ELEMENTS PPE, PA_OBJECT_RELATIONSHIPS POR, PA_PROJ_ELEMENT_VERSIONS PPEV

1143: SELECT ppe.proj_element_Id task_id,
1144: ppe.record_version_number,
1145: ppev.parent_structure_version_id,
1146: ppe.task_approver_id task_app_chg_id
1147: FROM PA_PROJ_ELEMENTS PPE, PA_OBJECT_RELATIONSHIPS POR, PA_PROJ_ELEMENT_VERSIONS PPEV
1148: WHERE ppe.project_id = p_project_id
1149: AND ppev.proj_element_id = ppe.proj_element_id
1150: AND ppev.financial_task_flag = 'Y'
1151: AND por.object_id_to1 = ppev.element_version_id

Line 1459: FROM pa_object_relationships

1455: AND ppev.financial_task_flag = 'Y'
1456: AND ppe.task_status IN ('NEW','SUBMITTED','PENDING')
1457: AND ppev.element_version_id in (
1458: SELECT object_id_to1
1459: FROM pa_object_relationships
1460: WHERE relationship_type = 'S'
1461: AND relationship_subtype = 'TASK_TO_TASK'
1462: START WITH object_id_from1 = p_element_version_id
1463: AND relationship_type = 'S'

Line 1567: pa_object_relationships por

1563: select budget_version_id from pa_budget_versions where ci_id = l_ci_id )
1564: and exists (select 1
1565: from pa_proj_elements ppe,
1566: pa_proj_element_versions ppev,
1567: pa_object_relationships por
1568: where ppe.proj_element_id = pra.task_id
1569: and ppe.project_id = pra.project_id
1570: and ppe.link_task_flag = 'Y'
1571: and ppe.type_id = 1