APPS.PA_PPR_ROLLUP_PVT dependencies on PA_RBS_ELEMENTS

Line 39: from pa_rbs_elements

35:
36: delete from pa_ppr_obj_tmp;
37: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )
38: select rbs_element_id , nvl(parent_element_id,p_rbs_version_id)
39: from pa_rbs_elements
40: where rbs_version_id = p_rbs_version_id;
41:
42: insert into pa_ppr_obj_tmp ( object_id , parent_object_id ) values ( p_rbs_version_id , null );
43:

Line 52: UPDATE pa_rbs_elements

48:
49: CLOSE c1;
50:
51: FORALL k IN 1..l_task_arr.COUNT
52: UPDATE pa_rbs_elements
53: SET connect_path = l_connect_path_arr(k),
54: leaf_node = l_leaf_node_arr(k)
55: WHERE rbs_element_id = l_task_arr(k);
56:

Line 1191: from pa_rbs_elements

1187:
1188: ppr_log( 'Inserting into pa_ppr_obj_tmp2');
1189: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
1190: select rbs_element_id , nvl(parent_element_id,l_rbs_cbs_version_id_2)
1191: from pa_rbs_elements
1192: where rbs_version_id = l_rbs_cbs_version_id_2;
1193:
1194: ppr_log( 'Inserted into pa_ppr_obj_tmp2 count '||SQL%rowcount);
1195: end if;

Line 1300: from pa_rbs_elements

1296:
1297: l_struct_elem_id := 0;
1298: insert into pa_ppr_obj_tmp ( object_id , parent_object_id )
1299: select rbs_element_id , nvl(parent_element_id,l_rbs_cbs_version_id)
1300: from pa_rbs_elements
1301: where rbs_version_id = l_rbs_cbs_version_id;
1302:
1303: ppr_log('first Insert into pa_ppr_obj_tmp '||SQL%rowcount,0);
1304: insert into pa_ppr_obj_tmp ( object_id , parent_object_id ) values ( l_rbs_cbs_version_id , null );