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

Line 206: from PJI_FM_PROJ_BATCH_MAP map

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);
208:
209: delete
210: from PJI_FP_TXN_ACCUM1 bal

Line 212: from PJI_FM_PROJ_BATCH_MAP map

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:
215: end if;
216:

Line 253: from PJI_FM_PROJ_BATCH_MAP map

249:
250: delete
251: from PJI_FM_AGGR_ACT4 act4
252: where act4.PROJECT_ID in (select map.PROJECT_ID
253: from PJI_FM_PROJ_BATCH_MAP map
254: where map.WORKER_ID = p_worker_id);
255:
256: elsif (l_extraction_type = 'INCREMENTAL') then
257:

Line 309: from PJI_FM_PROJ_BATCH_MAP map

305: act4.G2_AR_APPR_INVOICE_AMOUNT = to_number(null),
306: act4.G2_AR_AMOUNT_DUE = to_number(null),
307: act4.G2_AR_AMOUNT_OVERDUE = to_number(null)
308: where act4.PROJECT_ID in (select map.PROJECT_ID
309: from PJI_FM_PROJ_BATCH_MAP map
310: where map.WORKER_ID = p_worker_id) and
311: not (nvl(act4.TXN_AR_INVOICE_AMOUNT , 0) = 0 and
312: nvl(act4.TXN_AR_CASH_APPLIED_AMOUNT , 0) = 0 and
313: nvl(act4.TXN_AR_INVOICE_WRITEOFF_AMOUNT , 0) = 0 and

Line 362: from PJI_FM_PROJ_BATCH_MAP map

358:
359: delete
360: from PJI_FM_AGGR_ACT4 act4
361: where act4.PROJECT_ID in (select map.PROJECT_ID
362: from PJI_FM_PROJ_BATCH_MAP map
363: where map.WORKER_ID = p_worker_id) and
364: nvl(act4.TXN_REVENUE , 0) = 0 and
365: nvl(act4.TXN_FUNDING , 0) = 0 and
366: nvl(act4.TXN_INITIAL_FUNDING_AMOUNT , 0) = 0 and