eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PPR_ROLLUP_PERIOD_PVT dependencies on PA_TASKS

Line 944: and a.object_type = 'PA_TASKS' -- SRI_BUG2

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 (+)
947: and b.object_type_From (+) = 'PA_TASKS'
948: and b.relationship_type (+) = 'S'

Line 947: and b.object_type_From (+) = 'PA_TASKS'

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 (+)
947: and b.object_type_From (+) = 'PA_TASKS'
948: and b.relationship_type (+) = 'S'
949: and b.object_id_from1 = c.element_version_id (+) ;
950:
951: elsif ( l_version_type = 'FINANCIAL' ) then

Line 954: -- For budgets pa_tasks can be used directly

950:
951: elsif ( l_version_type = 'FINANCIAL' ) then
952:
953: -- For financial tasks and fully shared.
954: -- For budgets pa_tasks can be used directly
955:
956: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )
957: select /*+ ordered */
958: p.task_id , nvl(p.parent_task_id, l_struct_elem_id )

Line 959: from pa_tasks p

955:
956: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )
957: select /*+ ordered */
958: p.task_id , nvl(p.parent_task_id, l_struct_elem_id )
959: from pa_tasks p
960: where p.project_id = l_project_id ;
961:
962: end if;
963:

Line 1030: and a.object_type = 'PA_TASKS' -- SRI_BUG2

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 (+)
1033: and b.object_type_From (+) = 'PA_TASKS'
1034: and b.relationship_type (+) = 'S'

Line 1033: and b.object_type_From (+) = 'PA_TASKS'

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 (+)
1033: and b.object_type_From (+) = 'PA_TASKS'
1034: and b.relationship_type (+) = 'S'
1035: and b.object_id_from1 = c.element_version_id (+) ;
1036:
1037: elsif ( l_version_type = 'FINANCIAL' ) then

Line 1040: -- For budgets pa_tasks can be used directly

1036:
1037: elsif ( l_version_type = 'FINANCIAL' ) then
1038:
1039: -- For financial tasks and fully shared.
1040: -- For budgets pa_tasks can be used directly
1041:
1042: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
1043: select /*+ ordered */
1044: p.task_id , nvl(p.parent_task_id, l_struct_elem_id )

Line 1045: from pa_tasks p

1041:
1042: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
1043: select /*+ ordered */
1044: p.task_id , nvl(p.parent_task_id, l_struct_elem_id )
1045: from pa_tasks p
1046: where p.project_id = l_project_id ;
1047:
1048: end if;
1049: