APPS.PJI_PJP_PRG_PERF_ALL dependencies on PJI_FP_AGGR_PJP1_T

Line 3004: delete from pji_fp_aggr_pjp1_t; -- 5309891

3000:
3001: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
3002:
3003: commit;
3004: delete from pji_fp_aggr_pjp1_t; -- 5309891
3005:
3006: commit;
3007: INSERT INTO pji_fp_aggr_pjp1_t
3008: ( WORKER_ID

Line 3007: INSERT INTO pji_fp_aggr_pjp1_t

3003: commit;
3004: delete from pji_fp_aggr_pjp1_t; -- 5309891
3005:
3006: commit;
3007: INSERT INTO pji_fp_aggr_pjp1_t
3008: ( WORKER_ID
3009: , PROJECT_ID, PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID, PROJECT_ELEMENT_ID
3010: , TIME_ID, PERIOD_TYPE_ID, CALENDAR_TYPE, RBS_AGGR_LEVEL
3011: , WBS_ROLLUP_FLAG, PRG_ROLLUP_FLAG , CURR_RECORD_TYPE_ID ,CURRENCY_CODE

Line 3050: FROM pji_fp_aggr_pjp1_t dates

3046: , end_date
3047: , l_last_update_date
3048: , l_last_updated_by
3049: , l_last_update_login
3050: FROM pji_fp_aggr_pjp1_t dates
3051: WHERE
3052: dates.plan_version_id = whdr.plan_version_id
3053: AND dates.project_id = whdr.project_id
3054: AND dates.plan_type_id = NVL(whdr.plan_type_id, -1)

Line 3059: FROM PJI_FP_AGGR_PJP1_T ver

3055: AND dates.plan_type_code = whdr.plan_type_code
3056: )
3057: WHERE (project_id, NVL(plan_type_id, -1), plan_version_id, plan_type_code) IN (
3058: SELECT project_id, plan_type_id, plan_version_id , plan_type_code
3059: FROM PJI_FP_AGGR_PJP1_T ver
3060: );
3061: commit;
3062: delete from pji_fp_aggr_pjp1_t;
3063: commit;

Line 3062: delete from pji_fp_aggr_pjp1_t;

3058: SELECT project_id, plan_type_id, plan_version_id , plan_type_code
3059: FROM PJI_FP_AGGR_PJP1_T ver
3060: );
3061: commit;
3062: delete from pji_fp_aggr_pjp1_t;
3063: commit;
3064:
3065: EXCEPTION
3066: WHEN OTHERS THEN