DBA Data[Home] [Help]

APPS.PJI_FM_XBS_ACCUM_UTILS dependencies on PA_OBJECT_RELATIONSHIPS

Line 1988: from PA_PROJ_ELEMENT_VERSIONS a , pa_object_relationships b , PA_PROJ_ELEMENT_VERSIONS c

1984: DELETE FROM pa_ppr_obj_tmp_view; --16679474
1985: insert into pa_ppr_obj_tmp_view ( object_id , parent_object_id )
1986: select /*+ ordered */
1987: distinct a.proj_element_id , nvl(c.proj_element_id,l_new_elem_id ) -- BUG_00
1988: from PA_PROJ_ELEMENT_VERSIONS a , pa_object_relationships b , PA_PROJ_ELEMENT_VERSIONS c
1989: where a.project_id = p_project_id
1990: and a.object_type = 'PA_TASKS'
1991: and a.parent_structure_version_id = p_base_struct_ver_id -- BUG_00
1992: and a.element_version_id = b.object_id_to1 (+)