APPS.PJI_RM_SUM_ROLLUP_RES dependencies on PJI_RM_RES_F

Line 711: PJI_RM_RES_F rms

707: CALENDAR_TYPE,
708: GL_CALENDAR_ID,
709: PA_CALENDAR_ID
710: ) tmp1,
711: PJI_RM_RES_F rms
712: where
713: tmp1.PERSON_ID = rms.PERSON_ID (+) and
714: tmp1.EXPENDITURE_ORG_ID = rms.EXPENDITURE_ORG_ID (+) and
715: tmp1.EXPENDITURE_ORGANIZATION_ID = rms.EXPENDITURE_ORGANIZATION_ID(+) and

Line 2443: insert /*+ append parallel(rms_i) */ into PJI_RM_RES_F rms_i

2439: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2440:
2441: if (l_extraction_type = 'FULL') then
2442:
2443: insert /*+ append parallel(rms_i) */ into PJI_RM_RES_F rms_i
2444: (
2445: PERSON_ID,
2446: EXPENDITURE_ORG_ID,
2447: EXPENDITURE_ORGANIZATION_ID,

Line 2569: merge /*+ parallel(rms) */ into PJI_RM_RES_F rms

2565: CALENDAR_TYPE;
2566:
2567: else
2568:
2569: merge /*+ parallel(rms) */ into PJI_RM_RES_F rms
2570: using
2571: (
2572: select /*+ parallel(res2) */
2573: PERSON_ID,

Line 3084: from PJI_RM_RES_F

3080: return;
3081: end if;
3082:
3083: delete
3084: from PJI_RM_RES_F
3085: where (PERSON_ID,
3086: EXPENDITURE_ORG_ID,
3087: EXPENDITURE_ORGANIZATION_ID,
3088: JOB_ID,

Line 3281: TABNAME => 'MLOG$_PJI_RM_RES_F',

3277: 'C',
3278: 'N');
3279: else
3280: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,
3281: TABNAME => 'MLOG$_PJI_RM_RES_F',
3282: PERCENT => 10,
3283: DEGREE => l_p_degree);
3284: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,
3285: l_retcode,