APPS.PJI_FM_SUM_EXTR dependencies on PJI_FM_AGGR_ACT2

Line 1845: insert /*+ append parallel(act2_i) */ into PJI_FM_AGGR_ACT2 act2_i -- in DANGLING_ACT_ROWS

1841:
1842: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
1843: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
1844:
1845: insert /*+ append parallel(act2_i) */ into PJI_FM_AGGR_ACT2 act2_i -- in DANGLING_ACT_ROWS
1846: (
1847: WORKER_ID,
1848: DANGLING_GL_RATE_FLAG,
1849: DANGLING_GL_RATE2_FLAG,

Line 3240: from PJI_FM_AGGR_ACT2

3236: delete /*+ parallel(act) */
3237: from PJI_FM_DNGL_ACT act
3238: where WORKER_ID = 0 and
3239: ROWID in (select ROW_ID
3240: from PJI_FM_AGGR_ACT2
3241: where WORKER_ID = p_worker_id);
3242:
3243: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.PURGE_DANGLING_ACT_ROWS(p_worker_id);');
3244:

Line 4722: insert /*+ append parallel(act2_i) */ into PJI_FM_AGGR_ACT2 act2_i -- in ACT_SUMMARY

4718:
4719: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
4720: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
4721:
4722: insert /*+ append parallel(act2_i) */ into PJI_FM_AGGR_ACT2 act2_i -- in ACT_SUMMARY
4723: (
4724: WORKER_ID,
4725: DANGLING_GL_RATE_FLAG,
4726: DANGLING_GL_RATE2_FLAG,

Line 6036: PJI_FM_AGGR_ACT2

6032: GP2_AR_APPR_INVOICE_AMOUNT,
6033: GP2_AR_AMOUNT_DUE,
6034: GP2_AR_AMOUNT_OVERDUE
6035: from
6036: PJI_FM_AGGR_ACT2
6037: where
6038: WORKER_ID = p_worker_id and
6039: (DANGLING_GL_RATE_FLAG is not null or
6040: DANGLING_GL_RATE2_FLAG is not null or

Line 6048: from PJI_FM_AGGR_ACT2

6044: DANGLING_GL_TIME_FLAG is not null or
6045: DANGLING_PA_TIME_FLAG is not null);
6046:
6047: delete
6048: from PJI_FM_AGGR_ACT2
6049: where WORKER_ID = p_worker_id and
6050: (DANGLING_GL_RATE_FLAG is not null or
6051: DANGLING_GL_RATE2_FLAG is not null or
6052: DANGLING_PA_RATE_FLAG is not null or

Line 7349: PJI_FM_AGGR_ACT2 tmp2

7345: (
7346: select 'GL' INVERT_ID from DUAL union all
7347: select 'PA' INVERT_ID from DUAL
7348: ) invert,
7349: PJI_FM_AGGR_ACT2 tmp2
7350: where
7351: tmp2.WORKER_ID = p_worker_id
7352: group by
7353: tmp2.PROJECT_ID,

Line 7370: -- PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_AGGR_ACT2' , 'NORMAL',null);

7366: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.AGGREGATE_ACT_SLICES(p_worker_id);');
7367:
7368: -- truncate intermediate tables no longer required
7369: -- l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
7370: -- PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_AGGR_ACT2' , 'NORMAL',null);
7371:
7372: commit;
7373:
7374: end AGGREGATE_ACT_SLICES;

Line 7660: 'PJI_FM_AGGR_ACT2',

7656: 'NORMAL',
7657: null);
7658:
7659: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
7660: 'PJI_FM_AGGR_ACT2',
7661: 'NORMAL',
7662: null);
7663:
7664: commit;