DBA Data[Home] [Help]

APPS.PA_PPR_CONCURRENT_PROGRAM dependencies on PA_PPR_OBJ_TMP2

Line 1033: delete from pa_ppr_obj_tmp2;

1029: begin
1030:
1031: For i in 1..g_rbs_version_id_arr.count loop
1032:
1033: delete from pa_ppr_obj_tmp2;
1034:
1035: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
1036: select rbs_element_id , nvl(parent_element_id,0)
1037: from pa_rbs_elements

Line 1035: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )

1031: For i in 1..g_rbs_version_id_arr.count loop
1032:
1033: delete from pa_ppr_obj_tmp2;
1034:
1035: insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
1036: select rbs_element_id , nvl(parent_element_id,0)
1037: from pa_rbs_elements
1038: where rbs_version_id = g_rbs_version_id_arr(i) ;
1039: