APPS.PJI_FM_SUM_PSI dependencies on PJI_FM_AGGR_ACT4

Line 251: from PJI_FM_AGGR_ACT4 act4

247:
248: if (l_extraction_type = 'PARTIAL') then
249:
250: delete
251: from PJI_FM_AGGR_ACT4 act4
252: where act4.PROJECT_ID in (select map.PROJECT_ID
253: from PJI_FM_PROJ_BATCH_MAP map
254: where map.WORKER_ID = p_worker_id);
255:

Line 260: update PJI_FM_AGGR_ACT4 act4

256: elsif (l_extraction_type = 'INCREMENTAL') then
257:
258: -- clean up snapshots and activities
259:
260: update PJI_FM_AGGR_ACT4 act4
261: set act4.TXN_AR_INVOICE_AMOUNT = to_number(null),
262: act4.TXN_AR_CASH_APPLIED_AMOUNT = to_number(null),
263: act4.TXN_AR_INVOICE_WRITEOFF_AMOUNT = to_number(null),
264: act4.TXN_AR_CREDIT_MEMO_AMOUNT = to_number(null),

Line 360: from PJI_FM_AGGR_ACT4 act4

356: nvl(act4.G2_AR_AMOUNT_DUE , 0) = 0 and
357: nvl(act4.G2_AR_AMOUNT_OVERDUE , 0) = 0);
358:
359: delete
360: from PJI_FM_AGGR_ACT4 act4
361: where act4.PROJECT_ID in (select map.PROJECT_ID
362: from PJI_FM_PROJ_BATCH_MAP map
363: where map.WORKER_ID = p_worker_id) and
364: nvl(act4.TXN_REVENUE , 0) = 0 and

Line 1450: insert /*+ append parallel(tmp4_i) */ into PJI_FM_AGGR_ACT4 tmp4_i

1446: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.AGGREGATE_ACR_PERIODS(p_worker_id);')) then
1447: return;
1448: end if;
1449:
1450: insert /*+ append parallel(tmp4_i) */ into PJI_FM_AGGR_ACT4 tmp4_i
1451: (
1452: WORKER_ID,
1453: PROJECT_ID,
1454: PROJECT_ORG_ID,

Line 4388: PJI_FM_AGGR_ACT4 act4

4384: p_worker_id WORKER_ID,
4385: act4.ROWID STG_ROWID
4386: from
4387: PJI_PJP_PROJ_BATCH_MAP map,
4388: PJI_FM_AGGR_ACT4 act4
4389: where
4390: map.WORKER_ID = p_worker_id and
4391: act4.PROJECT_ID = map.PROJECT_ID;
4392:

Line 4433: from PJI_FM_AGGR_ACT4

4429: l_extraction_type = 'INCREMENTAL' or
4430: l_extraction_type = 'PARTIAL') then
4431:
4432: delete
4433: from PJI_FM_AGGR_ACT4
4434: where ROWID in (select STG_ROWID
4435: from PJI_PJP_RMAP_ACR
4436: where WORKER_ID = p_worker_id);
4437: