APPS.PJI_RM_SUM_ROLLUP_RES dependencies on PJI_RM_RES_WT_F

Line 677: PJI_RM_RES_WT_F rmr,

673: 0 PROV_OVERCOM_HRS_S
674: from
675: PJI_RM_WORK_TYPE_INFO wt_old,
676: PJI_RM_WORK_TYPE_INFO wt_new,
677: PJI_RM_RES_WT_F rmr,
678: PJI_ORG_EXTR_INFO info
679: where
680: l_extraction_type = 'INCREMENTAL' and
681: l_work_type_change = 'CHANGE_EXISTS' and

Line 2093: insert /*+ append parallel(rmr_i) */ into PJI_RM_RES_WT_F rmr_i

2089: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2090:
2091: if (l_extraction_type = 'FULL') then
2092:
2093: insert /*+ append parallel(rmr_i) */ into PJI_RM_RES_WT_F rmr_i
2094: (
2095: RECORD_TYPE,
2096: PROJECT_ID,
2097: PERSON_ID,

Line 2163: merge /*+ parallel(rmr) */ into PJI_RM_RES_WT_F rmr

2159: CALENDAR_TYPE;
2160:
2161: else
2162:
2163: merge /*+ parallel(rmr) */ into PJI_RM_RES_WT_F rmr
2164: using
2165: (
2166: select /*+ parallel(res1) */
2167: RECORD_TYPE,

Line 2359: from PJI_RM_RES_WT_F

2355: return;
2356: end if;
2357:
2358: delete
2359: from PJI_RM_RES_WT_F
2360: where (RECORD_TYPE,
2361: PROJECT_ID,
2362: PERSON_ID,
2363: EXPENDITURE_ORG_ID,

Line 3186: TABNAME => 'MLOG$_PJI_RM_RES_WT_F',

3182: 'C',
3183: 'N');
3184: else
3185: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,
3186: TABNAME => 'MLOG$_PJI_RM_RES_WT_F',
3187: PERCENT => 10,
3188: DEGREE => l_p_degree);
3189: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
3190: l_retcode,