APPS.PJI_FM_SUM_BKLG dependencies on PJI_FM_RMAP_ACT

Line 133: insert /*+ append */ into PJI_FM_RMAP_ACT

129: return;
130: end if;
131:
132: -- Get minimum funding dates for each project in the current batch
133: insert /*+ append */ into PJI_FM_RMAP_ACT
134: (
135: WORKER_ID
136: , MAP_ROWID
137: , PROJECT_ID

Line 195: from PJI_FM_RMAP_ACT scope

191: UPDATE /*+ index(map, PJI_PJI_PROJ_BATCH_MAP_N1) */
192: pji_pji_proj_batch_map map
193: SET ( map.FUNDING_MIN_DATE ) =
194: (select scope.FUNDING_MIN_DATE
195: from PJI_FM_RMAP_ACT scope
196: where scope.worker_id = p_worker_id
197: and scope.MAP_ROWID = map.rowid
198: )
199: WHERE 1 = 1

Line 202: from PJI_FM_RMAP_ACT scope2

198: )
199: WHERE 1 = 1
200: AND map.WORKER_ID = p_worker_id
201: AND map.PROJECT_ID in (select scope2.PROJECT_ID
202: from PJI_FM_RMAP_ACT scope2
203: where scope2.worker_id = p_worker_id
204: and ((l_extraction_type <> 'INCREMENTAL')
205: or
206: scope2.FUNDING <>0