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 203: from PJI_FM_AGGR_FIN7 fin7

199:
200: if (l_extraction_type <> 'FULL' and l_extract_commitments = 'Y') then
201:
202: delete
203: from PJI_FM_AGGR_FIN7 fin7
204: where fin7.RECORD_TYPE = 'M' and
205: fin7.PROJECT_ID in (select map.PROJECT_ID
206: from PJI_FM_PROJ_BATCH_MAP map
207: where map.WORKER_ID = p_worker_id);

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

2666: elsif (l_extraction_type = 'INCREMENTAL') then
2667:
2668: -- insert both commitments and actuals into delta table
2669:
2670: insert /*+ append parallel(tmp7) */ into PJI_FM_AGGR_FIN7 tmp7
2671: (
2672: WORKER_ID,
2673: TXN_ACCUM_HEADER_ID,
2674: RECORD_TYPE,

Line 3690: PJI_FM_AGGR_FIN7 tmp7,

3686: psi.ROWID TXN_ROWID,
3687: tmp7.RECORD_TYPE
3688: from
3689: PJI_PJP_PROJ_BATCH_MAP map,
3690: PJI_FM_AGGR_FIN7 tmp7,
3691: PJI_FP_TXN_ACCUM psi
3692: where
3693: map.WORKER_ID = p_worker_id and
3694: tmp7.PROJECT_ID = map.PROJECT_ID and

Line 3724: PJI_FM_AGGR_FIN7 tmp7

3720: null TXN_ROWID,
3721: tmp7.RECORD_TYPE
3722: from
3723: PJI_PJP_PROJ_BATCH_MAP map,
3724: PJI_FM_AGGR_FIN7 tmp7
3725: where
3726: map.WORKER_ID = p_worker_id and
3727: tmp7.PROJECT_ID = map.PROJECT_ID and
3728: tmp7.RECORD_TYPE = 'M';

Line 3910: PJI_FM_AGGR_FIN7 tmp7

3906: l_last_updated_by,
3907: l_last_update_login
3908: from
3909: PJI_PJP_RMAP_FPR tmp7_r,
3910: PJI_FM_AGGR_FIN7 tmp7
3911: where
3912: tmp7_r.WORKER_ID = p_worker_id and
3913: tmp7_r.RECORD_TYPE = 'A' and
3914: tmp7_r.TXN_ROWID is not null and

Line 4081: PJI_FM_AGGR_FIN7 tmp7

4077: l_created_by CREATED_BY,
4078: l_last_update_login LAST_UPDATE_LOGIN
4079: from
4080: PJI_PJP_RMAP_FPR tmp7_r,
4081: PJI_FM_AGGR_FIN7 tmp7
4082: where
4083: tmp7_r.WORKER_ID = p_worker_id and
4084: tmp7_r.TXN_ROWID is null and
4085: tmp7_r.RECORD_TYPE = 'A' and

Line 4140: delete from PJI_FM_AGGR_FIN7

4136: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
4137:
4138: if (l_extraction_type = 'INCREMENTAL') then
4139:
4140: delete from PJI_FM_AGGR_FIN7
4141: where ROWID in (select STG_ROWID
4142: from PJI_PJP_RMAP_FPR
4143: where WORKER_ID = p_worker_id);
4144:

Line 4189: PJI_FM_AGGR_FIN7 fin7

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
4190: where tmp7_r.WORKER_ID = p_worker_id and
4191: tmp7_r.RECORD_TYPE = 'M' and
4192: fin7.ROWID = tmp7_r.STG_ROWID);
4193:

Line 4325: PJI_FM_AGGR_FIN7 tmp7

4321: l_created_by CREATED_BY,
4322: l_last_update_login LAST_UPDATE_LOGIN
4323: from
4324: PJI_PJP_RMAP_FPR tmp7_r,
4325: PJI_FM_AGGR_FIN7 tmp7
4326: where
4327: tmp7_r.WORKER_ID = p_worker_id and
4328: tmp7_r.TXN_ROWID is null and
4329: tmp7_r.RECORD_TYPE = 'M' and