[Home] [Help]
1144: ppr_log('inserting into pa_ppr_obj_tmp2 workplan '|| p_fact_slice);
1145: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
1146: select /*+ ordered */
1147: a.proj_element_id , nvl(c.proj_element_id,l_struct_elem_id)
1148: from PA_PROJ_ELEMENT_VERSIONS a , pa_object_relationships b , PA_PROJ_ELEMENT_VERSIONS c
1149: where a.project_id = l_project_id
1150: and a.parent_structure_version_id = l_struct_ver_id
1151: and a.element_version_id = b.object_id_to1 (+)
1152: and b.object_type_From (+) = 'PA_TASKS'
1260:
1261: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )
1262: select /*+ ordered */
1263: a.proj_element_id , nvl(c.proj_element_id,l_struct_elem_id)
1264: from PA_PROJ_ELEMENT_VERSIONS a , pa_object_relationships b , PA_PROJ_ELEMENT_VERSIONS c
1265: where a.project_id = l_project_id
1266: and a.object_type = 'PA_TASKS'
1267: and a.parent_structure_version_id = l_struct_ver_id
1268: and a.element_version_id = b.object_id_to1 (+)