APPS.PJI_FM_SUM_PSI dependencies on PJI_FP_TXN_ACCUM1

Line 210: from PJI_FP_TXN_ACCUM1 bal

206: from PJI_FM_PROJ_BATCH_MAP map
207: where map.WORKER_ID = p_worker_id);
208:
209: delete
210: from PJI_FP_TXN_ACCUM1 bal
211: where bal.PROJECT_ID in (select map.PROJECT_ID
212: from PJI_FM_PROJ_BATCH_MAP map
213: where map.WORKER_ID = p_worker_id);
214:

Line 3108: insert /*+ append parallel(bal) */ into PJI_FP_TXN_ACCUM1 bal

3104:
3105: -- Only insert commitments during FULL run since INCREMENTAL commitments
3106: -- data is handled at the same time as INCREMETNAL actuals data above.
3107:
3108: insert /*+ append parallel(bal) */ into PJI_FP_TXN_ACCUM1 bal
3109: (
3110: TXN_ACCUM_HEADER_ID,
3111: PROJECT_ID,
3112: PROJECT_ORG_ID,

Line 3281: insert /*+ append parallel(bal) */ into PJI_FP_TXN_ACCUM1 bal

3277: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3278:
3279: if (l_extraction_type = 'INCREMENTAL' and l_extract_commitments = 'Y') then
3280:
3281: insert /*+ append parallel(bal) */ into PJI_FP_TXN_ACCUM1 bal
3282: (
3283: TXN_ACCUM_HEADER_ID,
3284: PROJECT_ID,
3285: PROJECT_ORG_ID,

Line 4185: from PJI_FP_TXN_ACCUM1 bal

4181:
4182: if (l_extraction_type = 'INCREMENTAL') then
4183:
4184: delete
4185: from PJI_FP_TXN_ACCUM1 bal
4186: where bal.PROJECT_ID in (select distinct
4187: fin7.PROJECT_ID
4188: from PJI_PJP_RMAP_FPR tmp7_r,
4189: PJI_FM_AGGR_FIN7 fin7

Line 4245: insert /*+ append parallel(bal_i) */ into PJI_FP_TXN_ACCUM1 bal_i

4241: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4242:
4243: if (l_extraction_type = 'INCREMENTAL') then
4244:
4245: insert /*+ append parallel(bal_i) */ into PJI_FP_TXN_ACCUM1 bal_i
4246: (
4247: TXN_ACCUM_HEADER_ID,
4248: PROJECT_ID,
4249: PROJECT_ORG_ID,