DBA Data[Home] [Help]

APPS.PA_PPR_ROLLUP_ACTUAL_PVT dependencies on PA_OBJECT_RELATIONSHIPS

Line 771: from PA_PROJ_ELEMENT_VERSIONS a , pa_tasks c , pa_object_relationships b , PA_PROJ_ELEMENT_VERSIONS c

767:
768: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
769: select /*+ ordered */
770: a.proj_element_id , nvl(c.proj_element_id,0)
771: from PA_PROJ_ELEMENT_VERSIONS a , pa_tasks c , pa_object_relationships b , PA_PROJ_ELEMENT_VERSIONS c
772: where a.project_id = l_project_id
773: and a.object_type = 'PA_TASK' -- SRI_BUG add this new condition
774: and a.parent_structure_version_id = l_struct_ver_id
775: and a.proj_element_id = c.task_id