APPS.PJI_FM_SUM_PSI dependencies on PJI_FP_TXN_ACCUM1

Line 225: from PJI_FP_TXN_ACCUM1 bal

221: from PJI_FM_PROJ_BATCH_MAP map
222: where map.WORKER_ID = p_worker_id);
223:
224: delete
225: from PJI_FP_TXN_ACCUM1 bal
226: where bal.PROJECT_ID in (select map.PROJECT_ID
227: from PJI_FM_PROJ_BATCH_MAP map
228: where map.WORKER_ID = p_worker_id);
229:

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

3456:
3457: -- Only insert commitments during FULL run since INCREMENTAL commitments
3458: -- data is handled at the same time as INCREMETNAL actuals data above.
3459:
3460: insert /*+ append parallel(bal) */ into PJI_FP_TXN_ACCUM1 bal
3461: (
3462: TXN_ACCUM_HEADER_ID,
3463: PROJECT_ID,
3464: PROJECT_ORG_ID,

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

3696: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3697:
3698: if (l_extraction_type = 'INCREMENTAL' and l_extract_commitments = 'Y') then
3699:
3700: insert /*+ append parallel(bal) */ into PJI_FP_TXN_ACCUM1 bal
3701: (
3702: TXN_ACCUM_HEADER_ID,
3703: PROJECT_ID,
3704: PROJECT_ORG_ID,

Line 4674: from PJI_FP_TXN_ACCUM1 bal

4670:
4671: if (l_extraction_type = 'INCREMENTAL') then
4672:
4673: delete
4674: from PJI_FP_TXN_ACCUM1 bal
4675: where bal.PROJECT_ID in (select distinct
4676: fin7.PROJECT_ID
4677: from PJI_PJP_RMAP_FPR tmp7_r,
4678: PJI_FM_AGGR_FIN7 fin7

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

4730: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4731:
4732: if (l_extraction_type = 'INCREMENTAL') then
4733:
4734: insert /*+ append parallel(bal_i) */ into PJI_FP_TXN_ACCUM1 bal_i
4735: (
4736: TXN_ACCUM_HEADER_ID,
4737: PROJECT_ID,
4738: PROJECT_ORG_ID,