APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_RES_LIST_MAP_TMP1

Line 2361: DELETE FROM PA_RES_LIST_MAP_TMP1;

2357: END;
2358: END IF;
2359: END LOOP;
2360:
2361: DELETE FROM PA_RES_LIST_MAP_TMP1;
2362: DELETE FROM PA_RES_LIST_MAP_TMP4;
2363:
2364: l_TXN_SOURCE_ID_tab := l_proj_assignment_id;
2365: l_PERSON_ID_tab := l_proj_person_id;

Line 4977: DELETE from pa_res_list_map_tmp1;

4973: END IF;
4974: --dbms_output.put_line('before res_list_map');
4975: /* we need to pass only distinct
4976: RLM ids to the get res defa API */
4977: DELETE from pa_res_list_map_tmp1;
4978:
4979: FORALL pp in 1 .. l_res_list_member_id.count
4980: INSERT INTO pa_res_list_map_tmp1
4981: (txn_resource_list_member_id)

Line 4980: INSERT INTO pa_res_list_map_tmp1

4976: RLM ids to the get res defa API */
4977: DELETE from pa_res_list_map_tmp1;
4978:
4979: FORALL pp in 1 .. l_res_list_member_id.count
4980: INSERT INTO pa_res_list_map_tmp1
4981: (txn_resource_list_member_id)
4982: VALUES
4983: (l_res_list_member_id(pp));
4984:

Line 4990: FROM pa_res_list_map_tmp1;

4986:
4987: SELECT DISTINCT txn_resource_list_member_id
4988: BULK COLLECT
4989: INTO l_unique_rlm_id_tab
4990: FROM pa_res_list_map_tmp1;
4991:
4992: DELETE FROM pa_res_list_map_tmp1;
4993:
4994: FOR kk in 1 .. l_unique_rlm_id_tab.count LOOP

Line 4992: DELETE FROM pa_res_list_map_tmp1;

4988: BULK COLLECT
4989: INTO l_unique_rlm_id_tab
4990: FROM pa_res_list_map_tmp1;
4991:
4992: DELETE FROM pa_res_list_map_tmp1;
4993:
4994: FOR kk in 1 .. l_unique_rlm_id_tab.count LOOP
4995: l_da_resource_list_members_tab.extend;
4996: l_da_resource_list_members_tab(kk) := l_unique_rlm_id_tab(kk);