213: , -1 created_by
214: , -1 last_update_login
215: FROM DUAL;
216:
217: INSERT INTO pji_fp_aggr_pjp1
218: (
219: WORKER_ID,
220: PROJECT_ID
221: , PROJECT_ORG_ID
459: AND b1.version_type IN ( 'ALL' , 'COST' , 'REVENUE')
460: AND bl.budget_version_id = b.budget_version_id;
461:
462:
463: INSERT INTO pji_fp_aggr_pjp1
464: (
465: WORKER_ID,
466: PROJECT_ID
467: , PROJECT_ORG_ID
849: -1 ,
850: sysdate ,
851: -1 ,
852: -1
853: from pji_fp_aggr_pjp1 bv, pa_projects_all p
854: where bv.project_id = p.project_id;
855:
856: delete from pji_time_cal_period where cal_period_id = -1;
857: