APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PJI_FP_AGGR_PJP1_T

Line 5962: pji_fp_aggr_pjp1 tmp

5958: ,tmp.PLAN_TYPE_CODE PLAN_TYPE_CODE /*4471527 */
5959: FROM
5960: --Commented for 5927368
5961: -- PJI_FP_RMAP_FPR rwid
5962: pji_fp_aggr_pjp1 tmp
5963: , pji_pjp_wbs_header ver3 -- replaced ver3 with wbs header for project-to-program association event.
5964: WHERE 1 = 1
5965: AND tmp.worker_id = g_worker_id
5966: --commented for 5927368 and added tmp.RECORD_TYPE <> 'U' condition

Line 7324: delete from pji_fp_aggr_pjp1_t; -- 5309891

7320: BEGIN
7321:
7322: print_time ( ' Before update wbs header ' );
7323:
7324: delete from pji_fp_aggr_pjp1_t; -- 5309891
7325:
7326: INSERT INTO pji_fp_aggr_pjp1_t
7327: ( WORKER_ID
7328: , PROJECT_ID, PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID, PROJECT_ELEMENT_ID

Line 7326: INSERT INTO pji_fp_aggr_pjp1_t

7322: print_time ( ' Before update wbs header ' );
7323:
7324: delete from pji_fp_aggr_pjp1_t; -- 5309891
7325:
7326: INSERT INTO pji_fp_aggr_pjp1_t
7327: ( WORKER_ID
7328: , PROJECT_ID, PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID, PROJECT_ELEMENT_ID
7329: , TIME_ID, PERIOD_TYPE_ID, CALENDAR_TYPE, RBS_AGGR_LEVEL
7330: , WBS_ROLLUP_FLAG, PRG_ROLLUP_FLAG , CURR_RECORD_TYPE_ID ,CURRENCY_CODE

Line 7367: FROM pji_fp_aggr_pjp1_t dates

7363: , end_date
7364: , l_last_update_date
7365: , l_last_updated_by
7366: , l_last_update_login
7367: FROM pji_fp_aggr_pjp1_t dates
7368: WHERE
7369: dates.plan_version_id = whdr.plan_version_id
7370: AND dates.project_id = whdr.project_id
7371: AND dates.plan_type_id = NVL(whdr.plan_type_id, -1)

Line 7376: FROM PJI_FP_AGGR_PJP1_T ver

7372: AND dates.plan_type_code = whdr.plan_type_code
7373: )
7374: WHERE (project_id, NVL(plan_type_id, -1), plan_version_id, plan_type_code) IN (
7375: SELECT project_id, plan_type_id, plan_version_id , plan_type_code
7376: FROM PJI_FP_AGGR_PJP1_T ver
7377: );
7378:
7379: delete from pji_fp_aggr_pjp1_t;
7380:

Line 7379: delete from pji_fp_aggr_pjp1_t;

7375: SELECT project_id, plan_type_id, plan_version_id , plan_type_code
7376: FROM PJI_FP_AGGR_PJP1_T ver
7377: );
7378:
7379: delete from pji_fp_aggr_pjp1_t;
7380:
7381:
7382: print_time ( ' After update wbs header ' );
7383: