DBA Data[Home] [Help]

APPS.PJI_FM_SUM_ROLLUP_ACT dependencies on PJI_FM_AGGR_ACT5

Line 30: PJI_FM_AGGR_ACT5 act5

26: p_worker_id WORKER_ID,
27: act5.ROWID STG_ROWID
28: from
29: PJI_PJI_PROJ_BATCH_MAP map,
30: PJI_FM_AGGR_ACT5 act5
31: where
32: map.WORKER_ID = p_worker_id and
33: act5.PROJECT_ID = map.PROJECT_ID;
34:

Line 761: PJI_FM_AGGR_ACT5 act5,

757: sum(act5.G2_AR_AMOUNT_DUE) G2_AR_AMOUNT_DUE,
758: sum(act5.G2_AR_AMOUNT_OVERDUE) G2_AR_AMOUNT_OVERDUE
759: from
760: PJI_PJI_RMAP_ACT act5_r,
761: PJI_FM_AGGR_ACT5 act5,
762: (
763: select
764: map.PROJECT_ID,
765: map.NEW_PROJECT_ORGANIZATION_ID

Line 1097: from PJI_FM_AGGR_ACT5

1093: return;
1094: end if;
1095:
1096: delete
1097: from PJI_FM_AGGR_ACT5
1098: where ROWID in (select STG_ROWID
1099: from PJI_PJI_RMAP_ACT
1100: where WORKER_ID = p_worker_id);
1101: