APPS.PJI_FM_XBS_ACCUM_UTILS dependencies on PA_RES_LIST_MAP_TMP2

Line 405: DELETE FROM pa_res_list_map_tmp2; -- Bug#4726170

401: -- Cleanup tmp1 table for 3750147.
402: DELETE FROM pji_fm_xbs_accum_tmp1;
403:
404: DELETE FROM pa_res_list_map_tmp1; /* Uncommented for bug 9859199 */
405: DELETE FROM pa_res_list_map_tmp2; -- Bug#4726170
406:
407:
408: /* Commented for workplan progress
409: print_time ( ' get_summarized_data 0001 p_calendar_type ' || p_calendar_type ) ;

Line 561: DELETE FROM pa_res_list_map_tmp2; -- Bug#4726170

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:
565: INSERT INTO pa_res_list_map_tmp1 (

Line 654: INSERT INTO pa_res_list_map_tmp2

650:
651:
652: /* Added for bug 3729366 - Start */
653:
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,

Line 697: FROM pa_res_list_map_tmp2 t1

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
698: WHERE t1.TXN_SOURCE_ID=tmp.TXN_SOURCE_ID
699: AND t1.PERSON_ID=tmp.PERSON_ID
700: AND tmp.PERSON_ID IS NOT NULL
701: AND EXISTS

Line 704: FROM pa_res_list_map_tmp2 t1

700: AND tmp.PERSON_ID IS NOT NULL
701: AND EXISTS
702: (
703: SELECT NULL
704: FROM pa_res_list_map_tmp2 t1
705: WHERE t1.TXN_SOURCE_ID=tmp.TXN_SOURCE_ID
706: AND t1.PERSON_ID=tmp.PERSON_ID
707: )
708: )