APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_XBS_DENORM_DELTA_T

Line 2975: insert into PJI_XBS_DENORM_DELTA_T

2971: else -- online mode
2972:
2973: -- get WBS delta for online processing
2974:
2975: insert into PJI_XBS_DENORM_DELTA_T
2976: (
2977: WORKER_ID,
2978: STRUCT_TYPE,
2979: PRG_GROUP,

Line 10085: PJI_XBS_DENORM_DELTA_T wbs,

10081: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
10082: from
10083: PA_PJI_PROJ_EVENTS_LOG log,
10084: PJI_PJP_WBS_HEADER wbs_hdr,
10085: PJI_XBS_DENORM_DELTA_T wbs,
10086: PJI_XBS_DENORM prg,
10087: PJI_FP_XBS_ACCUM_F fpr,
10088: (
10089: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 13238: PJI_XBS_DENORM_DELTA_T wbs,

13234: wbs.SIGN * acr.CUSTOM15 CUSTOM15
13235: from
13236: PA_PJI_PROJ_EVENTS_LOG log,
13237: PJI_PJP_WBS_HEADER wbs_hdr,
13238: PJI_XBS_DENORM_DELTA_T wbs,
13239: PJI_XBS_DENORM prg,
13240: PJI_AC_XBS_ACCUM_F acr,
13241: (
13242: select 1 WBS_SUP_LEVEL,

Line 16784: delete from PJI_XBS_DENORM_DELTA_T;

16780: -- g_new_struct_version);
16781:
16782: end if;
16783:
16784: delete from PJI_XBS_DENORM_DELTA_T;
16785:
16786: end if;
16787:
16788: end UPDATE_XBS_DENORM;

Line 18069: delete from PJI_XBS_DENORM_DELTA_T;

18065: commit;
18066:
18067: else -- online mode
18068:
18069: delete from PJI_XBS_DENORM_DELTA_T;
18070:
18071: delete from PJI_FP_AGGR_PJP1_T;
18072:
18073: delete from PJI_AC_AGGR_PJP1_T;