APPS.PJI_FM_SUM_PSI dependencies on PJI_FM_AGGR_FIN7

Line 150: from PJI_FM_AGGR_FIN7 fin7

146:
147: if (l_extraction_type = 'PARTIAL') then
148:
149: delete
150: from PJI_FM_AGGR_FIN7 fin7
151: where fin7.RECORD_TYPE = 'A' and
152: fin7.PROJECT_ID in (select map.PROJECT_ID
153: from PJI_FM_PROJ_BATCH_MAP map
154: where map.WORKER_ID = p_worker_id);

Line 218: from PJI_FM_AGGR_FIN7 fin7

214:
215: if (l_extraction_type <> 'FULL' and l_extract_commitments = 'Y') then
216:
217: delete
218: from PJI_FM_AGGR_FIN7 fin7
219: where fin7.RECORD_TYPE = 'M' and
220: fin7.PROJECT_ID in (select map.PROJECT_ID
221: from PJI_FM_PROJ_BATCH_MAP map
222: where map.WORKER_ID = p_worker_id);

Line 2703: insert /*+ append parallel(tmp7) */ into PJI_FM_AGGR_FIN7 tmp7

2699: elsif (l_extraction_type = 'INCREMENTAL') then
2700:
2701: -- insert both commitments and actuals into delta table
2702:
2703: insert /*+ append parallel(tmp7) */ into PJI_FM_AGGR_FIN7 tmp7
2704: (
2705: WORKER_ID,
2706: TXN_ACCUM_HEADER_ID,
2707: RECORD_TYPE,

Line 4174: PJI_FM_AGGR_FIN7 tmp7,

4170: psi.ROWID TXN_ROWID,
4171: tmp7.RECORD_TYPE
4172: from
4173: PJI_PJP_PROJ_BATCH_MAP map,
4174: PJI_FM_AGGR_FIN7 tmp7,
4175: PJI_FP_TXN_ACCUM psi
4176: where
4177: map.WORKER_ID = p_worker_id and
4178: tmp7.PROJECT_ID = map.PROJECT_ID and

Line 4210: PJI_FM_AGGR_FIN7 tmp7

4206: null TXN_ROWID,
4207: tmp7.RECORD_TYPE
4208: from
4209: PJI_PJP_PROJ_BATCH_MAP map,
4210: PJI_FM_AGGR_FIN7 tmp7
4211: where
4212: map.WORKER_ID = p_worker_id and
4213: tmp7.PROJECT_ID = map.PROJECT_ID and
4214: tmp7.RECORD_TYPE = 'M';

Line 4396: PJI_FM_AGGR_FIN7 tmp7

4392: l_last_updated_by,
4393: l_last_update_login
4394: from
4395: PJI_PJP_RMAP_FPR tmp7_r,
4396: PJI_FM_AGGR_FIN7 tmp7
4397: where
4398: tmp7_r.WORKER_ID = p_worker_id and
4399: tmp7_r.RECORD_TYPE = 'A' and
4400: tmp7_r.TXN_ROWID is not null and

Line 4569: PJI_FM_AGGR_FIN7 tmp7

4565: l_last_update_login LAST_UPDATE_LOGIN,
4566: cbs_element_id cbs_element_id
4567: from
4568: PJI_PJP_RMAP_FPR tmp7_r,
4569: PJI_FM_AGGR_FIN7 tmp7
4570: where
4571: tmp7_r.WORKER_ID = p_worker_id and
4572: tmp7_r.TXN_ROWID is null and
4573: tmp7_r.RECORD_TYPE = 'A' and

Line 4629: delete from PJI_FM_AGGR_FIN7

4625: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
4626:
4627: if (l_extraction_type = 'INCREMENTAL') then
4628:
4629: delete from PJI_FM_AGGR_FIN7
4630: where ROWID in (select STG_ROWID
4631: from PJI_PJP_RMAP_FPR
4632: where WORKER_ID = p_worker_id);
4633:

Line 4678: PJI_FM_AGGR_FIN7 fin7

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
4679: where tmp7_r.WORKER_ID = p_worker_id and
4680: tmp7_r.RECORD_TYPE = 'M' and
4681: fin7.ROWID = tmp7_r.STG_ROWID);
4682:

Line 4816: PJI_FM_AGGR_FIN7 tmp7

4812: l_last_update_login LAST_UPDATE_LOGIN,
4813: cbs_element_id cbs_element_id
4814: from
4815: PJI_PJP_RMAP_FPR tmp7_r,
4816: PJI_FM_AGGR_FIN7 tmp7
4817: where
4818: tmp7_r.WORKER_ID = p_worker_id and
4819: tmp7_r.TXN_ROWID is null and
4820: tmp7_r.RECORD_TYPE = 'M' and