[Home] [Help]
488: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.AGGREGATE_FPR_PERIODS(p_worker_id);')) then
489: return;
490: end if;
491:
492: insert /*+ append parallel(tmp6_i) */ into PJI_FM_AGGR_FIN6 tmp6_i
493: (
494: WORKER_ID,
495: RECORD_TYPE,
496: PERSON_ID,
2434: PROJECT_ROLE_ID,
2435: PERSON_TYPE,
2436: SYSTEM_LINKAGE_FUNCTION
2437: from
2438: PJI_FM_AGGR_FIN6 tmp6
2439: where
2440: WORKER_ID = p_worker_id
2441: ) tmp6
2442: where
2619: l_creation_date CREATION_DATE,
2620: l_created_by CREATED_BY,
2621: l_last_update_login LAST_UPDATE_LOGIN
2622: from
2623: PJI_FM_AGGR_FIN6 tmp6,
2624: PJI_FP_TXN_ACCUM_HEADER hdr
2625: where
2626: tmp6.WORKER_ID = p_worker_id and
2627: tmp6.RECORD_TYPE = 'A' and
2822: tmp6.G2_PO_COMMITTED_COST,
2823: tmp6.G2_PR_COMMITTED_COST,
2824: tmp6.G2_OTH_COMMITTED_COST
2825: from
2826: PJI_FM_AGGR_FIN6 tmp6,
2827: PJI_FP_TXN_ACCUM_HEADER hdr
2828: where
2829: tmp6.WORKER_ID = p_worker_id and
2830: tmp6.PERSON_ID = hdr.PERSON_ID and
3003: l_creation_date CREATION_DATE,
3004: l_created_by CREATED_BY,
3005: l_last_update_login LAST_UPDATE_LOGIN
3006: from
3007: PJI_FM_AGGR_FIN6 tmp6,
3008: PJI_FP_TXN_ACCUM_HEADER hdr
3009: where
3010: tmp6.WORKER_ID = p_worker_id and
3011: tmp6.RECORD_TYPE = 'A' and
3186: l_creation_date CREATION_DATE,
3187: l_created_by CREATED_BY,
3188: l_last_update_login LAST_UPDATE_LOGIN
3189: from
3190: PJI_FM_AGGR_FIN6 tmp6,
3191: PJI_FP_TXN_ACCUM_HEADER hdr
3192: where
3193: tmp6.WORKER_ID = p_worker_id and
3194: tmp6.RECORD_TYPE = 'M' and
3359: l_creation_date CREATION_DATE,
3360: l_created_by CREATED_BY,
3361: l_last_update_login LAST_UPDATE_LOGIN
3362: from
3363: PJI_FM_AGGR_FIN6 tmp6,
3364: PJI_FP_TXN_ACCUM_HEADER hdr
3365: where
3366: tmp6.WORKER_ID = p_worker_id and
3367: tmp6.RECORD_TYPE = 'M' and
4476: 'NORMAL',
4477: null);
4478:
4479: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
4480: 'PJI_FM_AGGR_FIN6',
4481: 'NORMAL',
4482: null);
4483:
4484: end CLEANUP;