APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_XBS_DENORM_T

Line 130: insert into PJI_XBS_DENORM_T

126: )
127: and a.struct_type||'' = 'WBS'||'';
128: -- End Bug 12763391
129:
130: insert into PJI_XBS_DENORM_T
131: (STRUCT_TYPE,
132: PRG_GROUP,
133: STRUCT_VERSION_ID,
134: SUP_PROJECT_ID,

Line 178: insert into PJI_XBS_DENORM_T

174: from PJI_PA_XBS_DENORM_T b, PJI_PJP_PROJ_BATCH_MAP c
175: where c.worker_id = p_worker_id
176: and b.sup_project_id = c.project_id);
177:
178: insert into PJI_XBS_DENORM_T
179: (STRUCT_TYPE,
180: PRG_GROUP,
181: STRUCT_VERSION_ID,
182: SUP_PROJECT_ID,

Line 1029: PJI_XBS_DENORM_T prg,

1025: PJI_PJP_WBS_HEADER_T wbs_hdr,
1026: --PA_XBS_DENORM wbs,
1027: PJI_PA_XBS_DENORM_T wbs,
1028: --PJI_XBS_DENORM prg,
1029: PJI_XBS_DENORM_T prg,
1030: -- End of Commenting and adding code for testing 0802
1031: (
1032: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
1033: from DUAL union all

Line 1185: PJI_XBS_DENORM_T prg,

1181: PJI_FP_AGGR_PJP1 pjp1,
1182: -- Commenting and adding code for testing 0802
1183: --PJI_PJP_WBS_HEADER wbs_hdr,
1184: PJI_PJP_WBS_HEADER_T wbs_hdr,
1185: PJI_XBS_DENORM_T prg,
1186: --PJI_XBS_DENORM prg,
1187: -- End of Commenting and adding code for testing 0802
1188: (
1189: select 'Y' CB_FLAG,

Line 1342: PJI_XBS_DENORM_t prg,

1338: PJI_PJP_WBS_HEADER_T wbs_hdr,
1339: --PJI_PJP_WBS_HEADER wbs_hdr,
1340: PJI_XBS_DENORM_DELTA wbs,
1341: --PJI_XBS_DENORM prg,
1342: PJI_XBS_DENORM_t prg,
1343: -- End of Commenting and adding code for testing 0802
1344: PJI_FP_XBS_ACCUM_F fpr,
1345: (
1346: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 1432: PJI_XBS_DENORM_T prg,

1428: 'Y' PUSHUP_FLAG
1429: from
1430: PJI_PJP_PROJ_BATCH_MAP map,
1431: -- Commenting and adding code for testing 0802
1432: PJI_XBS_DENORM_T prg,
1433: --PJI_XBS_DENORM prg,
1434: -- End of Commenting and adding code for testing 0802
1435: (
1436: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all