eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_PJP_WBS_HEADER_T

Line 39: insert into PJI_PJP_WBS_HEADER_T

35: lv_level number := l_level;
36:
37: begin
38:
39: insert into PJI_PJP_WBS_HEADER_T
40: (
41: PROJECT_ID,
42: PLAN_VERSION_ID,
43: WBS_VERSION_ID,

Line 122: -- join to PJI_PJP_PROJ_BATCH_MAP is not needed since PJI_PJP_WBS_HEADER_T has

118: STRUCT_EMT_ID,
119: RELATIONSHIP_TYPE
120: from PA_XBS_DENORM a
121: -- Bug 12763391 - a.struct_type join should be outside the bracket
122: -- join to PJI_PJP_PROJ_BATCH_MAP is not needed since PJI_PJP_WBS_HEADER_T has
123: -- the rows filtered based on join to PJI_PJP_PROJ_BATCH_MAP and the worker_id
124: where a.STRUCT_VERSION_ID in ( select b.wbs_VERSION_ID
125: from PJI_PJP_WBS_HEADER_T b
126: )

Line 125: from PJI_PJP_WBS_HEADER_T b

121: -- Bug 12763391 - a.struct_type join should be outside the bracket
122: -- join to PJI_PJP_PROJ_BATCH_MAP is not needed since PJI_PJP_WBS_HEADER_T has
123: -- the rows filtered based on join to PJI_PJP_PROJ_BATCH_MAP and the worker_id
124: where a.STRUCT_VERSION_ID in ( select b.wbs_VERSION_ID
125: from PJI_PJP_WBS_HEADER_T b
126: )
127: and a.struct_type||'' = 'WBS'||'';
128: -- End Bug 12763391
129:

Line 1025: PJI_PJP_WBS_HEADER_T wbs_hdr,

1021: from
1022: PJI_FP_AGGR_PJP1 pjp1,
1023: -- Commenting and adding code for testing 0802
1024: --PJI_PJP_WBS_HEADER wbs_hdr,
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,

Line 1184: PJI_PJP_WBS_HEADER_T wbs_hdr,

1180: from
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: (

Line 1338: PJI_PJP_WBS_HEADER_T wbs_hdr,

1334: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
1335: from
1336: PJI_PA_PROJ_EVENTS_LOG log,
1337: -- Commenting and adding code for testing 0802
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,

Line 1464: PJI_PJP_WBS_HEADER_T wbs_hdr,

1460: prg_delta.SUP_PROJECT_ID is null
1461: ) prg,
1462: -- Commenting and adding code for testing 0802
1463: --PJI_PJP_WBS_HEADER wbs_hdr,
1464: PJI_PJP_WBS_HEADER_T wbs_hdr,
1465: -- End of Commenting and adding code for testing 0802
1466: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
1467: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
1468: PA_PROJ_WORKPLAN_ATTR sup_wpa