APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PJI_FP_AGGR_PJP1_T

Line 7166: pji_fp_aggr_pjp1 tmp

7162: ,tmp.PLAN_TYPE_CODE PLAN_TYPE_CODE /*4471527 */
7163: FROM
7164: --Commented for 5927368
7165: -- PJI_FP_RMAP_FPR rwid
7166: pji_fp_aggr_pjp1 tmp
7167: , pji_pjp_wbs_header ver3 -- replaced ver3 with wbs header for project-to-program association event.
7168: WHERE 1 = 1
7169: AND tmp.worker_id = g_worker_id
7170: --commented for 5927368 and added tmp.RECORD_TYPE <> 'U' condition

Line 8551: delete from pji_fp_aggr_pjp1_t; -- 5309891

8547: else
8548:
8549: print_time ( ' Before update wbs header ' );
8550:
8551: delete from pji_fp_aggr_pjp1_t; -- 5309891
8552: -- commit; /* Commented for Bug 14735308 */
8553: INSERT INTO pji_fp_aggr_pjp1_t
8554: ( WORKER_ID
8555: , PROJECT_ID, PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID, PROJECT_ELEMENT_ID

Line 8553: INSERT INTO pji_fp_aggr_pjp1_t

8549: print_time ( ' Before update wbs header ' );
8550:
8551: delete from pji_fp_aggr_pjp1_t; -- 5309891
8552: -- commit; /* Commented for Bug 14735308 */
8553: INSERT INTO pji_fp_aggr_pjp1_t
8554: ( WORKER_ID
8555: , PROJECT_ID, PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID, PROJECT_ELEMENT_ID
8556: , TIME_ID, PERIOD_TYPE_ID, CALENDAR_TYPE, RBS_AGGR_LEVEL
8557: , WBS_ROLLUP_FLAG, PRG_ROLLUP_FLAG , CURR_RECORD_TYPE_ID ,CURRENCY_CODE

Line 8594: FROM pji_fp_aggr_pjp1_t dates

8590: , end_date
8591: , l_last_update_date
8592: , l_last_updated_by
8593: , l_last_update_login
8594: FROM pji_fp_aggr_pjp1_t dates
8595: WHERE
8596: dates.plan_version_id = whdr.plan_version_id
8597: AND dates.project_id = whdr.project_id
8598: AND dates.plan_type_id = NVL(whdr.plan_type_id, -1)

Line 8603: FROM PJI_FP_AGGR_PJP1_T ver

8599: AND dates.plan_type_code = whdr.plan_type_code
8600: )
8601: WHERE (project_id, NVL(plan_type_id, -1), plan_version_id, plan_type_code) IN (
8602: SELECT project_id, plan_type_id, plan_version_id , plan_type_code
8603: FROM PJI_FP_AGGR_PJP1_T ver
8604: );
8605: -- commit; /* Commented for Bug 14735308 */
8606: delete from pji_fp_aggr_pjp1_t;
8607: -- commit; /* Commented for Bug 14735308 */

Line 8606: delete from pji_fp_aggr_pjp1_t;

8602: SELECT project_id, plan_type_id, plan_version_id , plan_type_code
8603: FROM PJI_FP_AGGR_PJP1_T ver
8604: );
8605: -- commit; /* Commented for Bug 14735308 */
8606: delete from pji_fp_aggr_pjp1_t;
8607: -- commit; /* Commented for Bug 14735308 */
8608:
8609: print_time ( ' After update wbs header ' );
8610: