APPS.PJI_FM_SUM_EXTR dependencies on PJI_FM_AGGR_ACT5

Line 6432: from PJI_FM_AGGR_ACT5

6428:
6429: if (l_extraction_type = 'PARTIAL') then
6430:
6431: delete
6432: from PJI_FM_AGGR_ACT5
6433: where PROJECT_ID in (select PROJECT_ID
6434: from PJI_FM_PROJ_BATCH_MAP
6435: where WORKER_ID = p_worker_id);
6436:

Line 6441: update PJI_FM_AGGR_ACT5 act5

6437: elsif (l_extraction_type = 'INCREMENTAL') then
6438:
6439: -- clean up snapshots and activities
6440:
6441: update PJI_FM_AGGR_ACT5 act5
6442: set act5.TXN_AR_INVOICE_AMOUNT = to_number(null),
6443: act5.TXN_AR_CASH_APPLIED_AMOUNT = to_number(null),
6444: act5.TXN_AR_INVOICE_WRITEOFF_AMOUNT = to_number(null),
6445: act5.TXN_AR_CREDIT_MEMO_AMOUNT = to_number(null),

Line 6541: from PJI_FM_AGGR_ACT5 act5

6537: nvl(act5.G2_AR_AMOUNT_DUE , 0) = 0 and
6538: nvl(act5.G2_AR_AMOUNT_OVERDUE , 0) = 0);
6539:
6540: delete
6541: from PJI_FM_AGGR_ACT5 act5
6542: where act5.PROJECT_ID in (select map.PROJECT_ID
6543: from PJI_FM_PROJ_BATCH_MAP map
6544: where map.WORKER_ID = p_worker_id) and
6545: nvl(act5.TXN_REVENUE , 0) = 0 and

Line 6645: insert into PJI_FM_AGGR_ACT5

6641: nvl(act5.G2_AR_AMOUNT_OVERDUE , 0) = 0;
6642:
6643: end if;
6644:
6645: insert into PJI_FM_AGGR_ACT5
6646: (
6647: WORKER_ID,
6648: PROJECT_ID,
6649: PROJECT_ORG_ID,