APPS.PJI_FM_SUM_BKLG dependencies on PJI_FM_RMAP_FIN

Line 24: insert /*+ append */ into PJI_FM_RMAP_FIN

20: return;
21: end if;
22:
23: -- Get the minimum activity dates for each project in the current batch
24: insert /*+ append */ into PJI_FM_RMAP_FIN
25: (
26: WORKER_ID
27: , MAP_ROWID
28: , PROJECT_ID

Line 94: from PJI_FM_RMAP_FIN scope

90: SET ( map.ACTIVITY_MIN_GL_DATE
91: , map.ACTIVITY_MIN_PA_DATE) =
92: (select scope.ACTIVITY_MIN_GL_DATE
93: , scope.ACTIVITY_MIN_PA_DATE
94: from PJI_FM_RMAP_FIN scope
95: where scope.worker_id = p_worker_id
96: and scope.MAP_ROWID = map.rowid
97: )
98: WHERE 1 = 1

Line 101: from PJI_FM_RMAP_FIN scope2

97: )
98: WHERE 1 = 1
99: AND map.WORKER_ID = p_worker_id
100: AND map.PROJECT_ID in (select scope2.PROJECT_ID
101: from PJI_FM_RMAP_FIN scope2
102: where scope2.worker_id = p_worker_id
103: and ((l_extraction_type <> 'INCREMENTAL')
104: or
105: scope2.REVENUE <>0