APPS.PJI_FM_XBS_ACCUM_UTILS dependencies on PA_RES_LIST_MAP_TMP1

Line 404: --DELETE FROM pa_res_list_map_tmp1;

400:
401: -- Cleanup tmp1 table for 3750147.
402: DELETE FROM pji_fm_xbs_accum_tmp1;
403:
404: --DELETE FROM pa_res_list_map_tmp1;
405: DELETE FROM pa_res_list_map_tmp2; -- Bug#4726170
406:
407:
408: /* Commented for workplan progress

Line 560: --DELETE FROM pa_res_list_map_tmp1;

556: END IF;
557: */
558: IF l_planres_level_flag = 'Y' THEN
559:
560: --DELETE FROM pa_res_list_map_tmp1;
561: DELETE FROM pa_res_list_map_tmp2; -- Bug#4726170
562:
563: print_time ( ' get_summarized_data 0004 ' ) ;
564:

Line 565: INSERT INTO pa_res_list_map_tmp1 (

561: DELETE FROM pa_res_list_map_tmp2; -- Bug#4726170
562:
563: print_time ( ' get_summarized_data 0004 ' ) ;
564:
565: INSERT INTO pa_res_list_map_tmp1 (
566: PERSON_ID,
567: JOB_ID,
568: ORGANIZATION_ID,
569: VENDOR_ID,

Line 658: FROM pa_res_list_map_tmp1 t,

654: INSERT INTO pa_res_list_map_tmp2
655: (TXN_SOURCE_ID,VENDOR_ID,PERSON_ID)
656: SELECT /* + index(hr, per_assignments_f_n12) index(prd, pji_time_cal_period_u1) */
657: distinct T.TXN_SOURCE_ID,HR.VENDOR_ID,HR.PERSON_ID
658: FROM pa_res_list_map_tmp1 t,
659: per_all_assignments_f hr, --Bug#5356978
660: pji_time_cal_period_v prd,
661: ( SELECT txn_accum_header_id,max(recvr_period_id) recvr_period_id -- Bug#5262851
662: FROM

Line 693: UPDATE pa_res_list_map_tmp1 tmp

689:
690:
691: print_time ( ' get_summarized_data 0004.4 ' ) ;
692:
693: UPDATE pa_res_list_map_tmp1 tmp
694: SET VENDOR_ID =
695: (
696: SELECT t1.VENDOR_ID
697: FROM pa_res_list_map_tmp2 t1