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_PROCESS_UTIL dependencies on PJI_XBS_DENORM_DELTA

Line 8790: PJI_XBS_DENORM_DELTA wbs,

8786: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
8787: from
8788: PJI_PA_PROJ_EVENTS_LOG log,
8789: PJI_PJP_WBS_HEADER wbs_hdr,
8790: PJI_XBS_DENORM_DELTA wbs,
8791: PJI_XBS_DENORM prg,
8792: PJI_FP_XBS_ACCUM_F fpr,
8793: (
8794: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 8886: PJI_XBS_DENORM_DELTA prg_delta

8882: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8883: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8884: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
8885: ) invert,
8886: PJI_XBS_DENORM_DELTA prg_delta
8887: where
8888: prg.STRUCT_TYPE = 'PRG' and
8889: prg.SUB_ROLLUP_ID is not null and
8890: prg.SUB_LEVEL = l_level and

Line 10111: PJI_XBS_DENORM_DELTA wbs,

10107: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
10108: from
10109: PJI_PA_PROJ_EVENTS_LOG log,
10110: PJI_PJP_WBS_HEADER wbs_hdr,
10111: PJI_XBS_DENORM_DELTA wbs,
10112: PJI_XBS_DENORM prg,
10113: PJI_FP_XBS_ACCUM_F fpr,
10114: (
10115: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 10207: PJI_XBS_DENORM_DELTA prg_delta

10203: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
10204: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10205: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
10206: ) invert,
10207: PJI_XBS_DENORM_DELTA prg_delta
10208: where
10209: prg.STRUCT_TYPE = 'PRG' and
10210: prg.SUB_ROLLUP_ID is not null and
10211: prg.SUB_LEVEL = l_level and

Line 11430: PJI_XBS_DENORM_DELTA wbs,

11426: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
11427: from
11428: PJI_PA_PROJ_EVENTS_LOG log,
11429: PJI_PJP_WBS_HEADER wbs_hdr,
11430: PJI_XBS_DENORM_DELTA wbs,
11431: PJI_XBS_DENORM prg,
11432: PJI_FP_XBS_ACCUM_F fpr,
11433: (
11434: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 11526: PJI_XBS_DENORM_DELTA prg_delta

11522: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
11523: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11524: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
11525: ) invert,
11526: PJI_XBS_DENORM_DELTA prg_delta
11527: where
11528: prg.STRUCT_TYPE = 'PRG' and
11529: prg.SUB_ROLLUP_ID is not null and
11530: prg.SUB_LEVEL = l_level and

Line 12748: PJI_XBS_DENORM_DELTA wbs,

12744: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
12745: from
12746: PJI_PA_PROJ_EVENTS_LOG log,
12747: PJI_PJP_WBS_HEADER wbs_hdr,
12748: PJI_XBS_DENORM_DELTA wbs,
12749: PJI_XBS_DENORM prg,
12750: PJI_FP_XBS_ACCUM_F fpr,
12751: (
12752: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 12844: PJI_XBS_DENORM_DELTA prg_delta

12840: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
12841: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12842: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
12843: ) invert,
12844: PJI_XBS_DENORM_DELTA prg_delta
12845: where
12846: prg.STRUCT_TYPE = 'PRG' and
12847: prg.SUB_ROLLUP_ID is not null and
12848: prg.SUB_LEVEL = l_level and

Line 14066: PJI_XBS_DENORM_DELTA wbs,

14062: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
14063: from
14064: PJI_PA_PROJ_EVENTS_LOG log,
14065: PJI_PJP_WBS_HEADER wbs_hdr,
14066: PJI_XBS_DENORM_DELTA wbs,
14067: PJI_XBS_DENORM prg,
14068: PJI_FP_XBS_ACCUM_F fpr,
14069: (
14070: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 14162: PJI_XBS_DENORM_DELTA prg_delta

14158: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
14159: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14160: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
14161: ) invert,
14162: PJI_XBS_DENORM_DELTA prg_delta
14163: where
14164: prg.STRUCT_TYPE = 'PRG' and
14165: prg.SUB_ROLLUP_ID is not null and
14166: prg.SUB_LEVEL = l_level and

Line 15384: PJI_XBS_DENORM_DELTA wbs,

15380: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
15381: from
15382: PJI_PA_PROJ_EVENTS_LOG log,
15383: PJI_PJP_WBS_HEADER wbs_hdr,
15384: PJI_XBS_DENORM_DELTA wbs,
15385: PJI_XBS_DENORM prg,
15386: PJI_FP_XBS_ACCUM_F fpr,
15387: (
15388: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 15480: PJI_XBS_DENORM_DELTA prg_delta

15476: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
15477: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15478: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
15479: ) invert,
15480: PJI_XBS_DENORM_DELTA prg_delta
15481: where
15482: prg.STRUCT_TYPE = 'PRG' and
15483: prg.SUB_ROLLUP_ID is not null and
15484: prg.SUB_LEVEL = l_level and

Line 16702: PJI_XBS_DENORM_DELTA wbs,

16698: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
16699: from
16700: PJI_PA_PROJ_EVENTS_LOG log,
16701: PJI_PJP_WBS_HEADER wbs_hdr,
16702: PJI_XBS_DENORM_DELTA wbs,
16703: PJI_XBS_DENORM prg,
16704: PJI_FP_XBS_ACCUM_F fpr,
16705: (
16706: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 16798: PJI_XBS_DENORM_DELTA prg_delta

16794: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
16795: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16796: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
16797: ) invert,
16798: PJI_XBS_DENORM_DELTA prg_delta
16799: where
16800: prg.STRUCT_TYPE = 'PRG' and
16801: prg.SUB_ROLLUP_ID is not null and
16802: prg.SUB_LEVEL = l_level and

Line 18020: PJI_XBS_DENORM_DELTA wbs,

18016: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
18017: from
18018: PJI_PA_PROJ_EVENTS_LOG log,
18019: PJI_PJP_WBS_HEADER wbs_hdr,
18020: PJI_XBS_DENORM_DELTA wbs,
18021: PJI_XBS_DENORM prg,
18022: PJI_FP_XBS_ACCUM_F fpr,
18023: (
18024: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 18116: PJI_XBS_DENORM_DELTA prg_delta

18112: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
18113: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18114: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
18115: ) invert,
18116: PJI_XBS_DENORM_DELTA prg_delta
18117: where
18118: prg.STRUCT_TYPE = 'PRG' and
18119: prg.SUB_ROLLUP_ID is not null and
18120: prg.SUB_LEVEL = l_level and

Line 19338: PJI_XBS_DENORM_DELTA wbs,

19334: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
19335: from
19336: PJI_PA_PROJ_EVENTS_LOG log,
19337: PJI_PJP_WBS_HEADER wbs_hdr,
19338: PJI_XBS_DENORM_DELTA wbs,
19339: PJI_XBS_DENORM prg,
19340: PJI_FP_XBS_ACCUM_F fpr,
19341: (
19342: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 19434: PJI_XBS_DENORM_DELTA prg_delta

19430: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
19431: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19432: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
19433: ) invert,
19434: PJI_XBS_DENORM_DELTA prg_delta
19435: where
19436: prg.STRUCT_TYPE = 'PRG' and
19437: prg.SUB_ROLLUP_ID is not null and
19438: prg.SUB_LEVEL = l_level and

Line 20656: PJI_XBS_DENORM_DELTA wbs,

20652: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
20653: from
20654: PJI_PA_PROJ_EVENTS_LOG log,
20655: PJI_PJP_WBS_HEADER wbs_hdr,
20656: PJI_XBS_DENORM_DELTA wbs,
20657: PJI_XBS_DENORM prg,
20658: PJI_FP_XBS_ACCUM_F fpr,
20659: (
20660: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 20752: PJI_XBS_DENORM_DELTA prg_delta

20748: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
20749: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
20750: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
20751: ) invert,
20752: PJI_XBS_DENORM_DELTA prg_delta
20753: where
20754: prg.STRUCT_TYPE = 'PRG' and
20755: prg.SUB_ROLLUP_ID is not null and
20756: prg.SUB_LEVEL = l_level and

Line 21361: PJI_XBS_DENORM_DELTA wbs,

21357: wbs.SIGN * acr.CUSTOM15 CUSTOM15
21358: from
21359: PJI_PA_PROJ_EVENTS_LOG log,
21360: PJI_PJP_WBS_HEADER wbs_hdr,
21361: PJI_XBS_DENORM_DELTA wbs,
21362: PJI_XBS_DENORM prg,
21363: PJI_AC_XBS_ACCUM_F acr,
21364: (
21365: select 1 WBS_SUP_LEVEL,

Line 21419: PJI_XBS_DENORM_DELTA prg_delta

21415: 'Y' PUSHUP_FLAG
21416: from
21417: PJI_PJP_PROJ_BATCH_MAP map,
21418: PJI_XBS_DENORM prg,
21419: PJI_XBS_DENORM_DELTA prg_delta
21420: where
21421: prg.STRUCT_TYPE = 'PRG' and
21422: prg.RELATIONSHIP_TYPE = 'LF' and
21423: prg.SUB_ROLLUP_ID is not null and

Line 21943: PJI_XBS_DENORM_DELTA wbs,

21939: wbs.SIGN * acr.CUSTOM15 CUSTOM15
21940: from
21941: PJI_PA_PROJ_EVENTS_LOG log,
21942: PJI_PJP_WBS_HEADER wbs_hdr,
21943: PJI_XBS_DENORM_DELTA wbs,
21944: PJI_XBS_DENORM prg,
21945: PJI_AC_XBS_ACCUM_F acr,
21946: (
21947: select 1 WBS_SUP_LEVEL,

Line 22001: PJI_XBS_DENORM_DELTA prg_delta

21997: 'Y' PUSHUP_FLAG
21998: from
21999: PJI_PJP_PROJ_BATCH_MAP map,
22000: PJI_XBS_DENORM prg,
22001: PJI_XBS_DENORM_DELTA prg_delta
22002: where
22003: prg.STRUCT_TYPE = 'PRG' and
22004: prg.RELATIONSHIP_TYPE = 'LF' and
22005: prg.SUB_ROLLUP_ID is not null and

Line 22525: PJI_XBS_DENORM_DELTA wbs,

22521: wbs.SIGN * acr.CUSTOM15 CUSTOM15
22522: from
22523: PJI_PA_PROJ_EVENTS_LOG log,
22524: PJI_PJP_WBS_HEADER wbs_hdr,
22525: PJI_XBS_DENORM_DELTA wbs,
22526: PJI_XBS_DENORM prg,
22527: PJI_AC_XBS_ACCUM_F acr,
22528: (
22529: select 1 WBS_SUP_LEVEL,

Line 22583: PJI_XBS_DENORM_DELTA prg_delta

22579: 'Y' PUSHUP_FLAG
22580: from
22581: PJI_PJP_PROJ_BATCH_MAP map,
22582: PJI_XBS_DENORM prg,
22583: PJI_XBS_DENORM_DELTA prg_delta
22584: where
22585: prg.STRUCT_TYPE = 'PRG' and
22586: prg.RELATIONSHIP_TYPE = 'LF' and
22587: prg.SUB_ROLLUP_ID is not null and

Line 23107: PJI_XBS_DENORM_DELTA wbs,

23103: wbs.SIGN * acr.CUSTOM15 CUSTOM15
23104: from
23105: PJI_PA_PROJ_EVENTS_LOG log,
23106: PJI_PJP_WBS_HEADER wbs_hdr,
23107: PJI_XBS_DENORM_DELTA wbs,
23108: PJI_XBS_DENORM prg,
23109: PJI_AC_XBS_ACCUM_F acr,
23110: (
23111: select 1 WBS_SUP_LEVEL,

Line 23165: PJI_XBS_DENORM_DELTA prg_delta

23161: 'Y' PUSHUP_FLAG
23162: from
23163: PJI_PJP_PROJ_BATCH_MAP map,
23164: PJI_XBS_DENORM prg,
23165: PJI_XBS_DENORM_DELTA prg_delta
23166: where
23167: prg.STRUCT_TYPE = 'PRG' and
23168: prg.RELATIONSHIP_TYPE = 'LF' and
23169: prg.SUB_ROLLUP_ID is not null and

Line 23689: PJI_XBS_DENORM_DELTA wbs,

23685: wbs.SIGN * acr.CUSTOM15 CUSTOM15
23686: from
23687: PJI_PA_PROJ_EVENTS_LOG log,
23688: PJI_PJP_WBS_HEADER wbs_hdr,
23689: PJI_XBS_DENORM_DELTA wbs,
23690: PJI_XBS_DENORM prg,
23691: PJI_AC_XBS_ACCUM_F acr,
23692: (
23693: select 1 WBS_SUP_LEVEL,

Line 23747: PJI_XBS_DENORM_DELTA prg_delta

23743: 'Y' PUSHUP_FLAG
23744: from
23745: PJI_PJP_PROJ_BATCH_MAP map,
23746: PJI_XBS_DENORM prg,
23747: PJI_XBS_DENORM_DELTA prg_delta
23748: where
23749: prg.STRUCT_TYPE = 'PRG' and
23750: prg.RELATIONSHIP_TYPE = 'LF' and
23751: prg.SUB_ROLLUP_ID is not null and

Line 24271: PJI_XBS_DENORM_DELTA wbs,

24267: wbs.SIGN * acr.CUSTOM15 CUSTOM15
24268: from
24269: PJI_PA_PROJ_EVENTS_LOG log,
24270: PJI_PJP_WBS_HEADER wbs_hdr,
24271: PJI_XBS_DENORM_DELTA wbs,
24272: PJI_XBS_DENORM prg,
24273: PJI_AC_XBS_ACCUM_F acr,
24274: (
24275: select 1 WBS_SUP_LEVEL,

Line 24329: PJI_XBS_DENORM_DELTA prg_delta

24325: 'Y' PUSHUP_FLAG
24326: from
24327: PJI_PJP_PROJ_BATCH_MAP map,
24328: PJI_XBS_DENORM prg,
24329: PJI_XBS_DENORM_DELTA prg_delta
24330: where
24331: prg.STRUCT_TYPE = 'PRG' and
24332: prg.RELATIONSHIP_TYPE = 'LF' and
24333: prg.SUB_ROLLUP_ID is not null and

Line 24853: PJI_XBS_DENORM_DELTA wbs,

24849: wbs.SIGN * acr.CUSTOM15 CUSTOM15
24850: from
24851: PJI_PA_PROJ_EVENTS_LOG log,
24852: PJI_PJP_WBS_HEADER wbs_hdr,
24853: PJI_XBS_DENORM_DELTA wbs,
24854: PJI_XBS_DENORM prg,
24855: PJI_AC_XBS_ACCUM_F acr,
24856: (
24857: select 1 WBS_SUP_LEVEL,

Line 24911: PJI_XBS_DENORM_DELTA prg_delta

24907: 'Y' PUSHUP_FLAG
24908: from
24909: PJI_PJP_PROJ_BATCH_MAP map,
24910: PJI_XBS_DENORM prg,
24911: PJI_XBS_DENORM_DELTA prg_delta
24912: where
24913: prg.STRUCT_TYPE = 'PRG' and
24914: prg.RELATIONSHIP_TYPE = 'LF' and
24915: prg.SUB_ROLLUP_ID is not null and

Line 25435: PJI_XBS_DENORM_DELTA wbs,

25431: wbs.SIGN * acr.CUSTOM15 CUSTOM15
25432: from
25433: PJI_PA_PROJ_EVENTS_LOG log,
25434: PJI_PJP_WBS_HEADER wbs_hdr,
25435: PJI_XBS_DENORM_DELTA wbs,
25436: PJI_XBS_DENORM prg,
25437: PJI_AC_XBS_ACCUM_F acr,
25438: (
25439: select 1 WBS_SUP_LEVEL,

Line 25493: PJI_XBS_DENORM_DELTA prg_delta

25489: 'Y' PUSHUP_FLAG
25490: from
25491: PJI_PJP_PROJ_BATCH_MAP map,
25492: PJI_XBS_DENORM prg,
25493: PJI_XBS_DENORM_DELTA prg_delta
25494: where
25495: prg.STRUCT_TYPE = 'PRG' and
25496: prg.RELATIONSHIP_TYPE = 'LF' and
25497: prg.SUB_ROLLUP_ID is not null and

Line 26017: PJI_XBS_DENORM_DELTA wbs,

26013: wbs.SIGN * acr.CUSTOM15 CUSTOM15
26014: from
26015: PJI_PA_PROJ_EVENTS_LOG log,
26016: PJI_PJP_WBS_HEADER wbs_hdr,
26017: PJI_XBS_DENORM_DELTA wbs,
26018: PJI_XBS_DENORM prg,
26019: PJI_AC_XBS_ACCUM_F acr,
26020: (
26021: select 1 WBS_SUP_LEVEL,

Line 26075: PJI_XBS_DENORM_DELTA prg_delta

26071: 'Y' PUSHUP_FLAG
26072: from
26073: PJI_PJP_PROJ_BATCH_MAP map,
26074: PJI_XBS_DENORM prg,
26075: PJI_XBS_DENORM_DELTA prg_delta
26076: where
26077: prg.STRUCT_TYPE = 'PRG' and
26078: prg.RELATIONSHIP_TYPE = 'LF' and
26079: prg.SUB_ROLLUP_ID is not null and

Line 26599: PJI_XBS_DENORM_DELTA wbs,

26595: wbs.SIGN * acr.CUSTOM15 CUSTOM15
26596: from
26597: PJI_PA_PROJ_EVENTS_LOG log,
26598: PJI_PJP_WBS_HEADER wbs_hdr,
26599: PJI_XBS_DENORM_DELTA wbs,
26600: PJI_XBS_DENORM prg,
26601: PJI_AC_XBS_ACCUM_F acr,
26602: (
26603: select 1 WBS_SUP_LEVEL,

Line 26657: PJI_XBS_DENORM_DELTA prg_delta

26653: 'Y' PUSHUP_FLAG
26654: from
26655: PJI_PJP_PROJ_BATCH_MAP map,
26656: PJI_XBS_DENORM prg,
26657: PJI_XBS_DENORM_DELTA prg_delta
26658: where
26659: prg.STRUCT_TYPE = 'PRG' and
26660: prg.RELATIONSHIP_TYPE = 'LF' and
26661: prg.SUB_ROLLUP_ID is not null and

Line 27233: PJI_XBS_DENORM_DELTA prg,

27229: prg.SIGN * fpr.CUSTOM13 CUSTOM13,
27230: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
27231: prg.SIGN * fpr.CUSTOM15 CUSTOM15
27232: from
27233: PJI_XBS_DENORM_DELTA prg,
27234: PA_PROJ_ELEMENTS prj_emt,
27235: PJI_PJP_WBS_HEADER wbs_hdr,
27236: PJI_FP_XBS_ACCUM_F fpr,
27237: PJI_PJP_WBS_HEADER sup_wbs_hdr,

Line 27637: PJI_XBS_DENORM_DELTA prg_delta,

27633: PJI_FP_AGGR_PJP1 pjp1,
27634: PJI_PJP_WBS_HEADER wbs_hdr,
27635: PA_PROJ_ELEMENTS prj_emt,
27636: PA_XBS_DENORM prg,
27637: PJI_XBS_DENORM_DELTA prg_delta,
27638: PJI_PJP_WBS_HEADER sup_wbs_hdr,
27639: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
27640: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
27641: (

Line 28278: PJI_XBS_DENORM_DELTA prg,

28274: prg.SIGN * fpr.CUSTOM13 CUSTOM13,
28275: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
28276: prg.SIGN * fpr.CUSTOM15 CUSTOM15
28277: from
28278: PJI_XBS_DENORM_DELTA prg,
28279: PA_PROJ_ELEMENTS prj_emt,
28280: PJI_PJP_WBS_HEADER wbs_hdr,
28281: PJI_FP_XBS_ACCUM_F fpr,
28282: PJI_PJP_WBS_HEADER sup_wbs_hdr,

Line 28682: PJI_XBS_DENORM_DELTA prg_delta,

28678: PJI_FP_AGGR_PJP1 pjp1,
28679: PJI_PJP_WBS_HEADER wbs_hdr,
28680: PA_PROJ_ELEMENTS prj_emt,
28681: PA_XBS_DENORM prg,
28682: PJI_XBS_DENORM_DELTA prg_delta,
28683: PJI_PJP_WBS_HEADER sup_wbs_hdr,
28684: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
28685: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
28686: (

Line 29323: PJI_XBS_DENORM_DELTA prg,

29319: prg.SIGN * fpr.CUSTOM13 CUSTOM13,
29320: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
29321: prg.SIGN * fpr.CUSTOM15 CUSTOM15
29322: from
29323: PJI_XBS_DENORM_DELTA prg,
29324: PA_PROJ_ELEMENTS prj_emt,
29325: PJI_PJP_WBS_HEADER wbs_hdr,
29326: PJI_FP_XBS_ACCUM_F fpr,
29327: PJI_PJP_WBS_HEADER sup_wbs_hdr,

Line 29727: PJI_XBS_DENORM_DELTA prg_delta,

29723: PJI_FP_AGGR_PJP1 pjp1,
29724: PJI_PJP_WBS_HEADER wbs_hdr,
29725: PA_PROJ_ELEMENTS prj_emt,
29726: PA_XBS_DENORM prg,
29727: PJI_XBS_DENORM_DELTA prg_delta,
29728: PJI_PJP_WBS_HEADER sup_wbs_hdr,
29729: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
29730: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
29731: (

Line 30368: PJI_XBS_DENORM_DELTA prg,

30364: prg.SIGN * fpr.CUSTOM13 CUSTOM13,
30365: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
30366: prg.SIGN * fpr.CUSTOM15 CUSTOM15
30367: from
30368: PJI_XBS_DENORM_DELTA prg,
30369: PA_PROJ_ELEMENTS prj_emt,
30370: PJI_PJP_WBS_HEADER wbs_hdr,
30371: PJI_FP_XBS_ACCUM_F fpr,
30372: PJI_PJP_WBS_HEADER sup_wbs_hdr,

Line 30772: PJI_XBS_DENORM_DELTA prg_delta,

30768: PJI_FP_AGGR_PJP1 pjp1,
30769: PJI_PJP_WBS_HEADER wbs_hdr,
30770: PA_PROJ_ELEMENTS prj_emt,
30771: PA_XBS_DENORM prg,
30772: PJI_XBS_DENORM_DELTA prg_delta,
30773: PJI_PJP_WBS_HEADER sup_wbs_hdr,
30774: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
30775: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
30776: (

Line 31413: PJI_XBS_DENORM_DELTA prg,

31409: prg.SIGN * fpr.CUSTOM13 CUSTOM13,
31410: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
31411: prg.SIGN * fpr.CUSTOM15 CUSTOM15
31412: from
31413: PJI_XBS_DENORM_DELTA prg,
31414: PA_PROJ_ELEMENTS prj_emt,
31415: PJI_PJP_WBS_HEADER wbs_hdr,
31416: PJI_FP_XBS_ACCUM_F fpr,
31417: PJI_PJP_WBS_HEADER sup_wbs_hdr,

Line 31817: PJI_XBS_DENORM_DELTA prg_delta,

31813: PJI_FP_AGGR_PJP1 pjp1,
31814: PJI_PJP_WBS_HEADER wbs_hdr,
31815: PA_PROJ_ELEMENTS prj_emt,
31816: PA_XBS_DENORM prg,
31817: PJI_XBS_DENORM_DELTA prg_delta,
31818: PJI_PJP_WBS_HEADER sup_wbs_hdr,
31819: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
31820: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
31821: (

Line 32458: PJI_XBS_DENORM_DELTA prg,

32454: prg.SIGN * fpr.CUSTOM13 CUSTOM13,
32455: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
32456: prg.SIGN * fpr.CUSTOM15 CUSTOM15
32457: from
32458: PJI_XBS_DENORM_DELTA prg,
32459: PA_PROJ_ELEMENTS prj_emt,
32460: PJI_PJP_WBS_HEADER wbs_hdr,
32461: PJI_FP_XBS_ACCUM_F fpr,
32462: PJI_PJP_WBS_HEADER sup_wbs_hdr,

Line 32862: PJI_XBS_DENORM_DELTA prg_delta,

32858: PJI_FP_AGGR_PJP1 pjp1,
32859: PJI_PJP_WBS_HEADER wbs_hdr,
32860: PA_PROJ_ELEMENTS prj_emt,
32861: PA_XBS_DENORM prg,
32862: PJI_XBS_DENORM_DELTA prg_delta,
32863: PJI_PJP_WBS_HEADER sup_wbs_hdr,
32864: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
32865: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
32866: (

Line 33503: PJI_XBS_DENORM_DELTA prg,

33499: prg.SIGN * fpr.CUSTOM13 CUSTOM13,
33500: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
33501: prg.SIGN * fpr.CUSTOM15 CUSTOM15
33502: from
33503: PJI_XBS_DENORM_DELTA prg,
33504: PA_PROJ_ELEMENTS prj_emt,
33505: PJI_PJP_WBS_HEADER wbs_hdr,
33506: PJI_FP_XBS_ACCUM_F fpr,
33507: PJI_PJP_WBS_HEADER sup_wbs_hdr,

Line 33907: PJI_XBS_DENORM_DELTA prg_delta,

33903: PJI_FP_AGGR_PJP1 pjp1,
33904: PJI_PJP_WBS_HEADER wbs_hdr,
33905: PA_PROJ_ELEMENTS prj_emt,
33906: PA_XBS_DENORM prg,
33907: PJI_XBS_DENORM_DELTA prg_delta,
33908: PJI_PJP_WBS_HEADER sup_wbs_hdr,
33909: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
33910: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
33911: (

Line 34548: PJI_XBS_DENORM_DELTA prg,

34544: prg.SIGN * fpr.CUSTOM13 CUSTOM13,
34545: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
34546: prg.SIGN * fpr.CUSTOM15 CUSTOM15
34547: from
34548: PJI_XBS_DENORM_DELTA prg,
34549: PA_PROJ_ELEMENTS prj_emt,
34550: PJI_PJP_WBS_HEADER wbs_hdr,
34551: PJI_FP_XBS_ACCUM_F fpr,
34552: PJI_PJP_WBS_HEADER sup_wbs_hdr,

Line 34952: PJI_XBS_DENORM_DELTA prg_delta,

34948: PJI_FP_AGGR_PJP1 pjp1,
34949: PJI_PJP_WBS_HEADER wbs_hdr,
34950: PA_PROJ_ELEMENTS prj_emt,
34951: PA_XBS_DENORM prg,
34952: PJI_XBS_DENORM_DELTA prg_delta,
34953: PJI_PJP_WBS_HEADER sup_wbs_hdr,
34954: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
34955: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
34956: (

Line 35593: PJI_XBS_DENORM_DELTA prg,

35589: prg.SIGN * fpr.CUSTOM13 CUSTOM13,
35590: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
35591: prg.SIGN * fpr.CUSTOM15 CUSTOM15
35592: from
35593: PJI_XBS_DENORM_DELTA prg,
35594: PA_PROJ_ELEMENTS prj_emt,
35595: PJI_PJP_WBS_HEADER wbs_hdr,
35596: PJI_FP_XBS_ACCUM_F fpr,
35597: PJI_PJP_WBS_HEADER sup_wbs_hdr,

Line 35997: PJI_XBS_DENORM_DELTA prg_delta,

35993: PJI_FP_AGGR_PJP1 pjp1,
35994: PJI_PJP_WBS_HEADER wbs_hdr,
35995: PA_PROJ_ELEMENTS prj_emt,
35996: PA_XBS_DENORM prg,
35997: PJI_XBS_DENORM_DELTA prg_delta,
35998: PJI_PJP_WBS_HEADER sup_wbs_hdr,
35999: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
36000: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
36001: (

Line 36638: PJI_XBS_DENORM_DELTA prg,

36634: prg.SIGN * fpr.CUSTOM13 CUSTOM13,
36635: prg.SIGN * fpr.CUSTOM14 CUSTOM14,
36636: prg.SIGN * fpr.CUSTOM15 CUSTOM15
36637: from
36638: PJI_XBS_DENORM_DELTA prg,
36639: PA_PROJ_ELEMENTS prj_emt,
36640: PJI_PJP_WBS_HEADER wbs_hdr,
36641: PJI_FP_XBS_ACCUM_F fpr,
36642: PJI_PJP_WBS_HEADER sup_wbs_hdr,

Line 37042: PJI_XBS_DENORM_DELTA prg_delta,

37038: PJI_FP_AGGR_PJP1 pjp1,
37039: PJI_PJP_WBS_HEADER wbs_hdr,
37040: PA_PROJ_ELEMENTS prj_emt,
37041: PA_XBS_DENORM prg,
37042: PJI_XBS_DENORM_DELTA prg_delta,
37043: PJI_PJP_WBS_HEADER sup_wbs_hdr,
37044: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
37045: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
37046: (

Line 37403: PJI_XBS_DENORM_DELTA prg,

37399: prg.SIGN * acr.CUSTOM13 CUSTOM13,
37400: prg.SIGN * acr.CUSTOM14 CUSTOM14,
37401: prg.SIGN * acr.CUSTOM15 CUSTOM15
37402: from
37403: PJI_XBS_DENORM_DELTA prg,
37404: PA_PROJ_ELEMENTS prj_emt,
37405: PJI_PJP_WBS_HEADER wbs_hdr,
37406: PJI_AC_XBS_ACCUM_F acr
37407: where

Line 37483: PJI_XBS_DENORM_DELTA prg_delta

37479: PJI_AC_AGGR_PJP1 pjp1,
37480: PJI_PJP_WBS_HEADER wbs_hdr,
37481: PA_PROJ_ELEMENTS prj_emt,
37482: PA_XBS_DENORM prg,
37483: PJI_XBS_DENORM_DELTA prg_delta
37484: where
37485: prg.STRUCT_TYPE = 'PRG' and
37486: prg.SUP_LEVEL = l_level and
37487: nvl(prg.SUB_ROLLUP_ID,

Line 37746: PJI_XBS_DENORM_DELTA prg,

37742: prg.SIGN * acr.CUSTOM13 CUSTOM13,
37743: prg.SIGN * acr.CUSTOM14 CUSTOM14,
37744: prg.SIGN * acr.CUSTOM15 CUSTOM15
37745: from
37746: PJI_XBS_DENORM_DELTA prg,
37747: PA_PROJ_ELEMENTS prj_emt,
37748: PJI_PJP_WBS_HEADER wbs_hdr,
37749: PJI_AC_XBS_ACCUM_F acr
37750: where

Line 37826: PJI_XBS_DENORM_DELTA prg_delta

37822: PJI_AC_AGGR_PJP1 pjp1,
37823: PJI_PJP_WBS_HEADER wbs_hdr,
37824: PA_PROJ_ELEMENTS prj_emt,
37825: PA_XBS_DENORM prg,
37826: PJI_XBS_DENORM_DELTA prg_delta
37827: where
37828: prg.STRUCT_TYPE = 'PRG' and
37829: prg.SUP_LEVEL = l_level and
37830: nvl(prg.SUB_ROLLUP_ID,

Line 38088: PJI_XBS_DENORM_DELTA prg,

38084: prg.SIGN * acr.CUSTOM13 CUSTOM13,
38085: prg.SIGN * acr.CUSTOM14 CUSTOM14,
38086: prg.SIGN * acr.CUSTOM15 CUSTOM15
38087: from
38088: PJI_XBS_DENORM_DELTA prg,
38089: PA_PROJ_ELEMENTS prj_emt,
38090: PJI_PJP_WBS_HEADER wbs_hdr,
38091: PJI_AC_XBS_ACCUM_F acr
38092: where

Line 38168: PJI_XBS_DENORM_DELTA prg_delta

38164: PJI_AC_AGGR_PJP1 pjp1,
38165: PJI_PJP_WBS_HEADER wbs_hdr,
38166: PA_PROJ_ELEMENTS prj_emt,
38167: PA_XBS_DENORM prg,
38168: PJI_XBS_DENORM_DELTA prg_delta
38169: where
38170: prg.STRUCT_TYPE = 'PRG' and
38171: prg.SUP_LEVEL = l_level and
38172: nvl(prg.SUB_ROLLUP_ID,

Line 38430: PJI_XBS_DENORM_DELTA prg,

38426: prg.SIGN * acr.CUSTOM13 CUSTOM13,
38427: prg.SIGN * acr.CUSTOM14 CUSTOM14,
38428: prg.SIGN * acr.CUSTOM15 CUSTOM15
38429: from
38430: PJI_XBS_DENORM_DELTA prg,
38431: PA_PROJ_ELEMENTS prj_emt,
38432: PJI_PJP_WBS_HEADER wbs_hdr,
38433: PJI_AC_XBS_ACCUM_F acr
38434: where

Line 38510: PJI_XBS_DENORM_DELTA prg_delta

38506: PJI_AC_AGGR_PJP1 pjp1,
38507: PJI_PJP_WBS_HEADER wbs_hdr,
38508: PA_PROJ_ELEMENTS prj_emt,
38509: PA_XBS_DENORM prg,
38510: PJI_XBS_DENORM_DELTA prg_delta
38511: where
38512: prg.STRUCT_TYPE = 'PRG' and
38513: prg.SUP_LEVEL = l_level and
38514: nvl(prg.SUB_ROLLUP_ID,

Line 38772: PJI_XBS_DENORM_DELTA prg,

38768: prg.SIGN * acr.CUSTOM13 CUSTOM13,
38769: prg.SIGN * acr.CUSTOM14 CUSTOM14,
38770: prg.SIGN * acr.CUSTOM15 CUSTOM15
38771: from
38772: PJI_XBS_DENORM_DELTA prg,
38773: PA_PROJ_ELEMENTS prj_emt,
38774: PJI_PJP_WBS_HEADER wbs_hdr,
38775: PJI_AC_XBS_ACCUM_F acr
38776: where

Line 38852: PJI_XBS_DENORM_DELTA prg_delta

38848: PJI_AC_AGGR_PJP1 pjp1,
38849: PJI_PJP_WBS_HEADER wbs_hdr,
38850: PA_PROJ_ELEMENTS prj_emt,
38851: PA_XBS_DENORM prg,
38852: PJI_XBS_DENORM_DELTA prg_delta
38853: where
38854: prg.STRUCT_TYPE = 'PRG' and
38855: prg.SUP_LEVEL = l_level and
38856: nvl(prg.SUB_ROLLUP_ID,

Line 39114: PJI_XBS_DENORM_DELTA prg,

39110: prg.SIGN * acr.CUSTOM13 CUSTOM13,
39111: prg.SIGN * acr.CUSTOM14 CUSTOM14,
39112: prg.SIGN * acr.CUSTOM15 CUSTOM15
39113: from
39114: PJI_XBS_DENORM_DELTA prg,
39115: PA_PROJ_ELEMENTS prj_emt,
39116: PJI_PJP_WBS_HEADER wbs_hdr,
39117: PJI_AC_XBS_ACCUM_F acr
39118: where

Line 39194: PJI_XBS_DENORM_DELTA prg_delta

39190: PJI_AC_AGGR_PJP1 pjp1,
39191: PJI_PJP_WBS_HEADER wbs_hdr,
39192: PA_PROJ_ELEMENTS prj_emt,
39193: PA_XBS_DENORM prg,
39194: PJI_XBS_DENORM_DELTA prg_delta
39195: where
39196: prg.STRUCT_TYPE = 'PRG' and
39197: prg.SUP_LEVEL = l_level and
39198: nvl(prg.SUB_ROLLUP_ID,

Line 39456: PJI_XBS_DENORM_DELTA prg,

39452: prg.SIGN * acr.CUSTOM13 CUSTOM13,
39453: prg.SIGN * acr.CUSTOM14 CUSTOM14,
39454: prg.SIGN * acr.CUSTOM15 CUSTOM15
39455: from
39456: PJI_XBS_DENORM_DELTA prg,
39457: PA_PROJ_ELEMENTS prj_emt,
39458: PJI_PJP_WBS_HEADER wbs_hdr,
39459: PJI_AC_XBS_ACCUM_F acr
39460: where

Line 39536: PJI_XBS_DENORM_DELTA prg_delta

39532: PJI_AC_AGGR_PJP1 pjp1,
39533: PJI_PJP_WBS_HEADER wbs_hdr,
39534: PA_PROJ_ELEMENTS prj_emt,
39535: PA_XBS_DENORM prg,
39536: PJI_XBS_DENORM_DELTA prg_delta
39537: where
39538: prg.STRUCT_TYPE = 'PRG' and
39539: prg.SUP_LEVEL = l_level and
39540: nvl(prg.SUB_ROLLUP_ID,

Line 39798: PJI_XBS_DENORM_DELTA prg,

39794: prg.SIGN * acr.CUSTOM13 CUSTOM13,
39795: prg.SIGN * acr.CUSTOM14 CUSTOM14,
39796: prg.SIGN * acr.CUSTOM15 CUSTOM15
39797: from
39798: PJI_XBS_DENORM_DELTA prg,
39799: PA_PROJ_ELEMENTS prj_emt,
39800: PJI_PJP_WBS_HEADER wbs_hdr,
39801: PJI_AC_XBS_ACCUM_F acr
39802: where

Line 39878: PJI_XBS_DENORM_DELTA prg_delta

39874: PJI_AC_AGGR_PJP1 pjp1,
39875: PJI_PJP_WBS_HEADER wbs_hdr,
39876: PA_PROJ_ELEMENTS prj_emt,
39877: PA_XBS_DENORM prg,
39878: PJI_XBS_DENORM_DELTA prg_delta
39879: where
39880: prg.STRUCT_TYPE = 'PRG' and
39881: prg.SUP_LEVEL = l_level and
39882: nvl(prg.SUB_ROLLUP_ID,

Line 40140: PJI_XBS_DENORM_DELTA prg,

40136: prg.SIGN * acr.CUSTOM13 CUSTOM13,
40137: prg.SIGN * acr.CUSTOM14 CUSTOM14,
40138: prg.SIGN * acr.CUSTOM15 CUSTOM15
40139: from
40140: PJI_XBS_DENORM_DELTA prg,
40141: PA_PROJ_ELEMENTS prj_emt,
40142: PJI_PJP_WBS_HEADER wbs_hdr,
40143: PJI_AC_XBS_ACCUM_F acr
40144: where

Line 40220: PJI_XBS_DENORM_DELTA prg_delta

40216: PJI_AC_AGGR_PJP1 pjp1,
40217: PJI_PJP_WBS_HEADER wbs_hdr,
40218: PA_PROJ_ELEMENTS prj_emt,
40219: PA_XBS_DENORM prg,
40220: PJI_XBS_DENORM_DELTA prg_delta
40221: where
40222: prg.STRUCT_TYPE = 'PRG' and
40223: prg.SUP_LEVEL = l_level and
40224: nvl(prg.SUB_ROLLUP_ID,

Line 40482: PJI_XBS_DENORM_DELTA prg,

40478: prg.SIGN * acr.CUSTOM13 CUSTOM13,
40479: prg.SIGN * acr.CUSTOM14 CUSTOM14,
40480: prg.SIGN * acr.CUSTOM15 CUSTOM15
40481: from
40482: PJI_XBS_DENORM_DELTA prg,
40483: PA_PROJ_ELEMENTS prj_emt,
40484: PJI_PJP_WBS_HEADER wbs_hdr,
40485: PJI_AC_XBS_ACCUM_F acr
40486: where

Line 40562: PJI_XBS_DENORM_DELTA prg_delta

40558: PJI_AC_AGGR_PJP1 pjp1,
40559: PJI_PJP_WBS_HEADER wbs_hdr,
40560: PA_PROJ_ELEMENTS prj_emt,
40561: PA_XBS_DENORM prg,
40562: PJI_XBS_DENORM_DELTA prg_delta
40563: where
40564: prg.STRUCT_TYPE = 'PRG' and
40565: prg.SUP_LEVEL = l_level and
40566: nvl(prg.SUB_ROLLUP_ID,

Line 46357: PJI_XBS_DENORM_DELTA wbs,

46353: from
46354: PJI_PA_PROJ_EVENTS_LOG log,
46355: PJI_HELPER_420 helper,
46356: PJI_PJP_WBS_HEADER_T wbs_hdr,
46357: PJI_XBS_DENORM_DELTA wbs,
46358: PJI_XBS_DENORM_T prg,
46359: PJI_FP_XBS_ACCUM_F fpr,
46360: (
46361: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 46455: PJI_XBS_DENORM_DELTA prg_delta

46451: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
46452: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
46453: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
46454: ) invert,
46455: PJI_XBS_DENORM_DELTA prg_delta
46456: where
46457: prg.STRUCT_TYPE = 'PRG' and
46458: prg.SUB_ROLLUP_ID is not null and
46459: prg.SUB_LEVEL = l_level and