APPS.PJI_FM_SUM_PSI dependencies on PJI_FM_AGGR_ACT4

Line 266: from PJI_FM_AGGR_ACT4 act4

262:
263: if (l_extraction_type = 'PARTIAL') then
264:
265: delete
266: from PJI_FM_AGGR_ACT4 act4
267: where act4.PROJECT_ID in (select map.PROJECT_ID
268: from PJI_FM_PROJ_BATCH_MAP map
269: where map.WORKER_ID = p_worker_id);
270:

Line 275: update PJI_FM_AGGR_ACT4 act4

271: elsif (l_extraction_type = 'INCREMENTAL') then
272:
273: -- clean up snapshots and activities
274:
275: update PJI_FM_AGGR_ACT4 act4
276: set act4.TXN_AR_INVOICE_AMOUNT = to_number(null),
277: act4.TXN_AR_CASH_APPLIED_AMOUNT = to_number(null),
278: act4.TXN_AR_INVOICE_WRITEOFF_AMOUNT = to_number(null),
279: act4.TXN_AR_CREDIT_MEMO_AMOUNT = to_number(null),

Line 375: from PJI_FM_AGGR_ACT4 act4

371: nvl(act4.G2_AR_AMOUNT_DUE , 0) = 0 and
372: nvl(act4.G2_AR_AMOUNT_OVERDUE , 0) = 0);
373:
374: delete
375: from PJI_FM_AGGR_ACT4 act4
376: where act4.PROJECT_ID in (select map.PROJECT_ID
377: from PJI_FM_PROJ_BATCH_MAP map
378: where map.WORKER_ID = p_worker_id) and
379: nvl(act4.TXN_REVENUE , 0) = 0 and

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

1468: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.AGGREGATE_ACR_PERIODS(p_worker_id);')) then
1469: return;
1470: end if;
1471:
1472: insert /*+ append parallel(tmp4_i) */ into PJI_FM_AGGR_ACT4 tmp4_i
1473: (
1474: WORKER_ID,
1475: PROJECT_ID,
1476: PROJECT_ORG_ID,

Line 4880: PJI_FM_AGGR_ACT4 act4

4876: p_worker_id WORKER_ID,
4877: act4.ROWID STG_ROWID
4878: from
4879: PJI_PJP_PROJ_BATCH_MAP map,
4880: PJI_FM_AGGR_ACT4 act4
4881: where
4882: map.WORKER_ID = p_worker_id and
4883: act4.PROJECT_ID = map.PROJECT_ID;
4884:

Line 4925: from PJI_FM_AGGR_ACT4

4921: l_extraction_type = 'INCREMENTAL' or
4922: l_extraction_type = 'PARTIAL') then
4923:
4924: delete
4925: from PJI_FM_AGGR_ACT4
4926: where ROWID in (select STG_ROWID
4927: from PJI_PJP_RMAP_ACR
4928: where WORKER_ID = p_worker_id);
4929: