APPS.PA_PPR_CONCURRENT_PROGRAM dependencies on PA_PPR_OBJ_TMP

Line 1021: FROM pa_ppr_obj_tmp r

1017:
1018: cursor c1 is
1019: SELECT object_id ,
1020: SYS_CONNECT_BY_PATH(object_id, '/') connect_path
1021: FROM pa_ppr_obj_tmp r
1022: START WITH r.parent_object_id is null CONNECT BY
1023: PRIOR r.object_id = r.parent_object_id ;
1024:
1025: l_object_id_arr PA_PLSQL_DATATYPES.NumTabTyp;

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: