DBA Data[Home] [Help]

APPS.PA_PPR_ROLLUP_PERIOD_PVT dependencies on PA_OBJECT_RELATIONSHIPS

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

938:
939: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )
940: select /*+ ordered */
941: a.proj_element_id , nvl(c.proj_element_id,l_struct_elem_id)
942: from PA_PROJ_ELEMENT_VERSIONS a , pa_object_relationships b , PA_PROJ_ELEMENT_VERSIONS c
943: where a.project_id = l_project_id
944: and a.object_type = 'PA_TASKS' -- SRI_BUG2
945: and a.parent_structure_version_id = l_struct_ver_id
946: and a.element_version_id = b.object_id_to1 (+)

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

1024:
1025: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
1026: select /*+ ordered */
1027: a.proj_element_id , nvl(c.proj_element_id,l_struct_elem_id)
1028: from PA_PROJ_ELEMENT_VERSIONS a , pa_object_relationships b , PA_PROJ_ELEMENT_VERSIONS c
1029: where a.project_id = l_project_id
1030: and a.object_type = 'PA_TASKS' -- SRI_BUG2
1031: and a.parent_structure_version_id = l_struct_ver_id
1032: and a.element_version_id = b.object_id_to1 (+)