APPS.PJI_FM_SUM_PSI dependencies on PJI_FM_PROJ_BATCH_MAP

Line 153: from PJI_FM_PROJ_BATCH_MAP map

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);
155:
156: delete
157: from PJI_FP_TXN_ACCUM bal

Line 159: from PJI_FM_PROJ_BATCH_MAP map

155:
156: delete
157: from PJI_FP_TXN_ACCUM bal
158: where bal.PROJECT_ID in (select map.PROJECT_ID
159: from PJI_FM_PROJ_BATCH_MAP map
160: where map.WORKER_ID = p_worker_id);
161: /*
162:
163: delete

Line 167: from PJI_FM_PROJ_BATCH_MAP map

163: delete
164: from PA_FIN7_OLAP fin7
165: where fin7.RECORD_TYPE = 'A' and
166: fin7.PROJECT_ID in (select map.PROJECT_ID
167: from PJI_FM_PROJ_BATCH_MAP map
168: where map.WORKER_ID = p_worker_id);
169:
170: delete
171: from PA_STAGE1_BATCH_OLAP bal

Line 173: from PJI_FM_PROJ_BATCH_MAP map

169:
170: delete
171: from PA_STAGE1_BATCH_OLAP bal
172: where bal.PROJECT_ID in (select map.PROJECT_ID
173: from PJI_FM_PROJ_BATCH_MAP map
174: where map.WORKER_ID = p_worker_id);
175: */ -- COMMENTED TO REVERT OLAP CHANGES FOR 15900841
176:
177: end if;

Line 221: from PJI_FM_PROJ_BATCH_MAP map

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);
223:
224: delete
225: from PJI_FP_TXN_ACCUM1 bal

Line 227: from PJI_FM_PROJ_BATCH_MAP map

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:
230: end if;
231:

Line 268: from PJI_FM_PROJ_BATCH_MAP map

264:
265: delete
266: from PJI_FM_AGGR_ACT4 act4
267: where act4.PROJECT_ID in (select map.PROJECT_ID
268: from PJI_FM_PROJ_BATCH_MAP map
269: where map.WORKER_ID = p_worker_id);
270:
271: elsif (l_extraction_type = 'INCREMENTAL') then
272:

Line 324: from PJI_FM_PROJ_BATCH_MAP map

320: act4.G2_AR_APPR_INVOICE_AMOUNT = to_number(null),
321: act4.G2_AR_AMOUNT_DUE = to_number(null),
322: act4.G2_AR_AMOUNT_OVERDUE = to_number(null)
323: where act4.PROJECT_ID in (select map.PROJECT_ID
324: from PJI_FM_PROJ_BATCH_MAP map
325: where map.WORKER_ID = p_worker_id) and
326: not (nvl(act4.TXN_AR_INVOICE_AMOUNT , 0) = 0 and
327: nvl(act4.TXN_AR_CASH_APPLIED_AMOUNT , 0) = 0 and
328: nvl(act4.TXN_AR_INVOICE_WRITEOFF_AMOUNT , 0) = 0 and

Line 377: from PJI_FM_PROJ_BATCH_MAP map

373:
374: delete
375: from PJI_FM_AGGR_ACT4 act4
376: where act4.PROJECT_ID in (select map.PROJECT_ID
377: from PJI_FM_PROJ_BATCH_MAP map
378: where map.WORKER_ID = p_worker_id) and
379: nvl(act4.TXN_REVENUE , 0) = 0 and
380: nvl(act4.TXN_FUNDING , 0) = 0 and
381: nvl(act4.TXN_INITIAL_FUNDING_AMOUNT , 0) = 0 and