[Home] [Help]
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
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
776: and a.element_version_id = b.object_id_to1 (+)
777: and b.object_type_From (+) = 'PA_TASKS'
778: and b.relationship_type (+) = 'S'
779: and b.object_id_from1 = c.element_version_id (+) ;
780:
781: elsif ( l_version_type = 'FINANCIAL' ) then
780:
781: elsif ( l_version_type = 'FINANCIAL' ) then
782:
783: -- For financial tasks and fully shared.
784: -- For budgets pa_tasks can be used directly
785:
786: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
787: select c.task_id , nvl(c.parent_task_id,0)
788: from pa_tasks c
784: -- For budgets pa_tasks can be used directly
785:
786: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
787: select c.task_id , nvl(c.parent_task_id,0)
788: from pa_tasks c
789: where c.project_id = l_project_id ;
790:
791: end if;
792:
852:
853: ppr_log('into WBS ');
854: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )
855: select c.task_id , nvl(c.parent_task_id,0)
856: from pa_tasks c
857: where c.project_id = l_project_id ;
858:
859:
860: elsif p_fact_slice in ( 'RBS' , 'CBS' ) then