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_PVT dependencies on PA_TASKS

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

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'
1153: and b.relationship_type (+) = 'S'
1154: and b.object_id_from1 = c.element_version_id (+)
1155: AND ( p_wbs_rollup_flag = 'Y' or
1156: ( p_wbs_rollup_flag = 'N' and a.PROJ_element_id = p_proj_element_id ) ); --16767868 ;

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

1158: elsif ( l_version_type = 'FINANCIAL' ) then
1159:
1160: ppr_log('inserting into tmp2 financial '|| p_fact_slice);
1161: -- For financial tasks and fully shared.
1162: -- For budgets pa_tasks can be used directly
1163:
1164: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
1165: select /*+ ordered */
1166: p.task_id , nvl(p.parent_task_id, l_struct_elem_id )

Line 1167: from pa_tasks p

1163:
1164: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
1165: select /*+ ordered */
1166: p.task_id , nvl(p.parent_task_id, l_struct_elem_id )
1167: from pa_tasks p
1168: where p.project_id = l_project_id
1169: and ( p_wbs_rollup_flag = 'Y' or ( p_wbs_rollup_flag = 'N' and p.task_id = p_proj_element_id ) ); --16767868 ;
1170:
1171: end if;

Line 1266: and a.object_type = 'PA_TASKS'

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

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

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 (+)
1269: and b.object_type_From (+) = 'PA_TASKS'
1270: and b.relationship_type (+) = 'S'
1271: and b.object_id_from1 = c.element_version_id (+) ;
1272:
1273: insert into pa_ppr_obj_tmp ( object_id , parent_object_id ) values ( l_struct_elem_id , null );

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

1275:
1276: elsif ( l_version_type = 'FINANCIAL' ) then
1277:
1278: -- For financial tasks and fully shared.
1279: -- For budgets pa_tasks can be used directly
1280:
1281: ppr_log('TASKS INSERTED ',0);
1282:
1283: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )

Line 1286: from pa_tasks p

1282:
1283: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )
1284: select /*+ ordered */
1285: p.task_id , nvl(p.parent_task_id, l_struct_elem_id )
1286: from pa_tasks p
1287: where p.project_id = l_project_id ;
1288:
1289: insert into pa_ppr_obj_tmp ( object_id , parent_object_id ) values ( l_struct_elem_id , null );
1290: