DBA Data[Home] [Help]

APPS.AHL_VWP_PROJ_PROD_PVT dependencies on PA_OBJECT_RELATIONSHIPS

Line 2422: FROM pa_proj_element_versions ppev, pa_object_relationships por,

2418: CURSOR get_project_tasks_csr (c_project_id IN NUMBER) IS
2419: SELECT ppe.pm_source_reference, ppe1.pm_source_reference PARENT_TASK_REFERENCE, ppe.proj_element_id TASK_ID
2420: , parent_p_tsks.task_id PARENT_TASK_ID, PPEV.DISPLAY_SEQUENCE
2421: --SELECT ppe.pm_source_reference, ppe1.pm_source_reference PARENT_TASK_REFERENCE, ppe.proj_element_id
2422: FROM pa_proj_element_versions ppev, pa_object_relationships por,
2423: pa_proj_element_versions ppev1, pa_proj_elements ppe,
2424: pa_proj_elements ppe1,
2425: pa_tasks parent_p_tsks
2426: WHERE ppev.element_version_id = por.object_id_to1