DBA Data[Home] [Help]

APPS.PA_STATUS_PUB dependencies on PA_OBJECT_RELATIONSHIPS

Line 151: pa_object_relationships por

147:
148: CURSOR c_get_del_associated_task(c_project_id NUMBER, c_del_proj_element_id NUMBER, c_object_type VARCHAR2) IS
149: SELECT ppe.proj_element_id --, por.object_id_to1 (commented by rtarway for BUG 3746647)
150: FROM pa_proj_elements ppe,
151: pa_object_relationships por
152: WHERE
153: ppe.object_type = 'PA_TASKS'
154: and ppe.proj_element_id = por.object_id_from2
155: and por.object_id_to2 = c_del_proj_element_id