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_PJP_WBS_HEADER

Line 8484: PJI_PJP_WBS_HEADER wbs_hdr,

8480: pjp1.CUSTOM14,
8481: pjp1.CUSTOM15
8482: from
8483: PJI_FP_AGGR_PJP1 pjp1,
8484: PJI_PJP_WBS_HEADER wbs_hdr,
8485: PA_XBS_DENORM wbs,
8486: PJI_XBS_DENORM prg,
8487: (
8488: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 8638: PJI_PJP_WBS_HEADER wbs_hdr,

8634: pjp1.CUSTOM14,
8635: pjp1.CUSTOM15
8636: from
8637: PJI_FP_AGGR_PJP1 pjp1,
8638: PJI_PJP_WBS_HEADER wbs_hdr,
8639: PJI_XBS_DENORM prg,
8640: (
8641: select 'Y' CB_FLAG,
8642: 'N' CO_FLAG,

Line 8789: PJI_PJP_WBS_HEADER wbs_hdr,

8785: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
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: (

Line 8907: PJI_PJP_WBS_HEADER wbs_hdr,

8903: prg.RELATIONSHIP_TYPE = prg_delta.RELATIONSHIP_TYPE (+) and
8904: -1 = prg_delta.SIGN (+) and
8905: prg_delta.SUP_PROJECT_ID is null
8906: ) prg,
8907: PJI_PJP_WBS_HEADER wbs_hdr,
8908: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
8909: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
8910: PA_PROJ_WORKPLAN_ATTR sup_wpa
8911: where

Line 9805: PJI_PJP_WBS_HEADER wbs_hdr,

9801: pjp1.CUSTOM14,
9802: pjp1.CUSTOM15
9803: from
9804: PJI_FP_AGGR_PJP1 pjp1,
9805: PJI_PJP_WBS_HEADER wbs_hdr,
9806: PA_XBS_DENORM wbs,
9807: PJI_XBS_DENORM prg,
9808: (
9809: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 9959: PJI_PJP_WBS_HEADER wbs_hdr,

9955: pjp1.CUSTOM14,
9956: pjp1.CUSTOM15
9957: from
9958: PJI_FP_AGGR_PJP1 pjp1,
9959: PJI_PJP_WBS_HEADER wbs_hdr,
9960: PJI_XBS_DENORM prg,
9961: (
9962: select 'Y' CB_FLAG,
9963: 'N' CO_FLAG,

Line 10110: PJI_PJP_WBS_HEADER wbs_hdr,

10106: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
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: (

Line 10228: PJI_PJP_WBS_HEADER wbs_hdr,

10224: prg.RELATIONSHIP_TYPE = prg_delta.RELATIONSHIP_TYPE (+) and
10225: -1 = prg_delta.SIGN (+) and
10226: prg_delta.SUP_PROJECT_ID is null
10227: ) prg,
10228: PJI_PJP_WBS_HEADER wbs_hdr,
10229: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
10230: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
10231: PA_PROJ_WORKPLAN_ATTR sup_wpa
10232: where

Line 11124: PJI_PJP_WBS_HEADER wbs_hdr,

11120: pjp1.CUSTOM14,
11121: pjp1.CUSTOM15
11122: from
11123: PJI_FP_AGGR_PJP1 pjp1,
11124: PJI_PJP_WBS_HEADER wbs_hdr,
11125: PA_XBS_DENORM wbs,
11126: PJI_XBS_DENORM prg,
11127: (
11128: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 11278: PJI_PJP_WBS_HEADER wbs_hdr,

11274: pjp1.CUSTOM14,
11275: pjp1.CUSTOM15
11276: from
11277: PJI_FP_AGGR_PJP1 pjp1,
11278: PJI_PJP_WBS_HEADER wbs_hdr,
11279: PJI_XBS_DENORM prg,
11280: (
11281: select 'Y' CB_FLAG,
11282: 'N' CO_FLAG,

Line 11429: PJI_PJP_WBS_HEADER wbs_hdr,

11425: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
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: (

Line 11547: PJI_PJP_WBS_HEADER wbs_hdr,

11543: prg.RELATIONSHIP_TYPE = prg_delta.RELATIONSHIP_TYPE (+) and
11544: -1 = prg_delta.SIGN (+) and
11545: prg_delta.SUP_PROJECT_ID is null
11546: ) prg,
11547: PJI_PJP_WBS_HEADER wbs_hdr,
11548: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
11549: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
11550: PA_PROJ_WORKPLAN_ATTR sup_wpa
11551: where

Line 12442: PJI_PJP_WBS_HEADER wbs_hdr,

12438: pjp1.CUSTOM14,
12439: pjp1.CUSTOM15
12440: from
12441: PJI_FP_AGGR_PJP1 pjp1,
12442: PJI_PJP_WBS_HEADER wbs_hdr,
12443: PA_XBS_DENORM wbs,
12444: PJI_XBS_DENORM prg,
12445: (
12446: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 12596: PJI_PJP_WBS_HEADER wbs_hdr,

12592: pjp1.CUSTOM14,
12593: pjp1.CUSTOM15
12594: from
12595: PJI_FP_AGGR_PJP1 pjp1,
12596: PJI_PJP_WBS_HEADER wbs_hdr,
12597: PJI_XBS_DENORM prg,
12598: (
12599: select 'Y' CB_FLAG,
12600: 'N' CO_FLAG,

Line 12747: PJI_PJP_WBS_HEADER wbs_hdr,

12743: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
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: (

Line 12865: PJI_PJP_WBS_HEADER wbs_hdr,

12861: prg.RELATIONSHIP_TYPE = prg_delta.RELATIONSHIP_TYPE (+) and
12862: -1 = prg_delta.SIGN (+) and
12863: prg_delta.SUP_PROJECT_ID is null
12864: ) prg,
12865: PJI_PJP_WBS_HEADER wbs_hdr,
12866: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
12867: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
12868: PA_PROJ_WORKPLAN_ATTR sup_wpa
12869: where

Line 13760: PJI_PJP_WBS_HEADER wbs_hdr,

13756: pjp1.CUSTOM14,
13757: pjp1.CUSTOM15
13758: from
13759: PJI_FP_AGGR_PJP1 pjp1,
13760: PJI_PJP_WBS_HEADER wbs_hdr,
13761: PA_XBS_DENORM wbs,
13762: PJI_XBS_DENORM prg,
13763: (
13764: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 13914: PJI_PJP_WBS_HEADER wbs_hdr,

13910: pjp1.CUSTOM14,
13911: pjp1.CUSTOM15
13912: from
13913: PJI_FP_AGGR_PJP1 pjp1,
13914: PJI_PJP_WBS_HEADER wbs_hdr,
13915: PJI_XBS_DENORM prg,
13916: (
13917: select 'Y' CB_FLAG,
13918: 'N' CO_FLAG,

Line 14065: PJI_PJP_WBS_HEADER wbs_hdr,

14061: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
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: (

Line 14183: PJI_PJP_WBS_HEADER wbs_hdr,

14179: prg.RELATIONSHIP_TYPE = prg_delta.RELATIONSHIP_TYPE (+) and
14180: -1 = prg_delta.SIGN (+) and
14181: prg_delta.SUP_PROJECT_ID is null
14182: ) prg,
14183: PJI_PJP_WBS_HEADER wbs_hdr,
14184: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
14185: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
14186: PA_PROJ_WORKPLAN_ATTR sup_wpa
14187: where

Line 15078: PJI_PJP_WBS_HEADER wbs_hdr,

15074: pjp1.CUSTOM14,
15075: pjp1.CUSTOM15
15076: from
15077: PJI_FP_AGGR_PJP1 pjp1,
15078: PJI_PJP_WBS_HEADER wbs_hdr,
15079: PA_XBS_DENORM wbs,
15080: PJI_XBS_DENORM prg,
15081: (
15082: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 15232: PJI_PJP_WBS_HEADER wbs_hdr,

15228: pjp1.CUSTOM14,
15229: pjp1.CUSTOM15
15230: from
15231: PJI_FP_AGGR_PJP1 pjp1,
15232: PJI_PJP_WBS_HEADER wbs_hdr,
15233: PJI_XBS_DENORM prg,
15234: (
15235: select 'Y' CB_FLAG,
15236: 'N' CO_FLAG,

Line 15383: PJI_PJP_WBS_HEADER wbs_hdr,

15379: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
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: (

Line 15501: PJI_PJP_WBS_HEADER wbs_hdr,

15497: prg.RELATIONSHIP_TYPE = prg_delta.RELATIONSHIP_TYPE (+) and
15498: -1 = prg_delta.SIGN (+) and
15499: prg_delta.SUP_PROJECT_ID is null
15500: ) prg,
15501: PJI_PJP_WBS_HEADER wbs_hdr,
15502: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
15503: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
15504: PA_PROJ_WORKPLAN_ATTR sup_wpa
15505: where

Line 16396: PJI_PJP_WBS_HEADER wbs_hdr,

16392: pjp1.CUSTOM14,
16393: pjp1.CUSTOM15
16394: from
16395: PJI_FP_AGGR_PJP1 pjp1,
16396: PJI_PJP_WBS_HEADER wbs_hdr,
16397: PA_XBS_DENORM wbs,
16398: PJI_XBS_DENORM prg,
16399: (
16400: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 16550: PJI_PJP_WBS_HEADER wbs_hdr,

16546: pjp1.CUSTOM14,
16547: pjp1.CUSTOM15
16548: from
16549: PJI_FP_AGGR_PJP1 pjp1,
16550: PJI_PJP_WBS_HEADER wbs_hdr,
16551: PJI_XBS_DENORM prg,
16552: (
16553: select 'Y' CB_FLAG,
16554: 'N' CO_FLAG,

Line 16701: PJI_PJP_WBS_HEADER wbs_hdr,

16697: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
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: (

Line 16819: PJI_PJP_WBS_HEADER wbs_hdr,

16815: prg.RELATIONSHIP_TYPE = prg_delta.RELATIONSHIP_TYPE (+) and
16816: -1 = prg_delta.SIGN (+) and
16817: prg_delta.SUP_PROJECT_ID is null
16818: ) prg,
16819: PJI_PJP_WBS_HEADER wbs_hdr,
16820: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
16821: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
16822: PA_PROJ_WORKPLAN_ATTR sup_wpa
16823: where

Line 17714: PJI_PJP_WBS_HEADER wbs_hdr,

17710: pjp1.CUSTOM14,
17711: pjp1.CUSTOM15
17712: from
17713: PJI_FP_AGGR_PJP1 pjp1,
17714: PJI_PJP_WBS_HEADER wbs_hdr,
17715: PA_XBS_DENORM wbs,
17716: PJI_XBS_DENORM prg,
17717: (
17718: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 17868: PJI_PJP_WBS_HEADER wbs_hdr,

17864: pjp1.CUSTOM14,
17865: pjp1.CUSTOM15
17866: from
17867: PJI_FP_AGGR_PJP1 pjp1,
17868: PJI_PJP_WBS_HEADER wbs_hdr,
17869: PJI_XBS_DENORM prg,
17870: (
17871: select 'Y' CB_FLAG,
17872: 'N' CO_FLAG,

Line 18019: PJI_PJP_WBS_HEADER wbs_hdr,

18015: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
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: (

Line 18137: PJI_PJP_WBS_HEADER wbs_hdr,

18133: prg.RELATIONSHIP_TYPE = prg_delta.RELATIONSHIP_TYPE (+) and
18134: -1 = prg_delta.SIGN (+) and
18135: prg_delta.SUP_PROJECT_ID is null
18136: ) prg,
18137: PJI_PJP_WBS_HEADER wbs_hdr,
18138: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
18139: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
18140: PA_PROJ_WORKPLAN_ATTR sup_wpa
18141: where

Line 19032: PJI_PJP_WBS_HEADER wbs_hdr,

19028: pjp1.CUSTOM14,
19029: pjp1.CUSTOM15
19030: from
19031: PJI_FP_AGGR_PJP1 pjp1,
19032: PJI_PJP_WBS_HEADER wbs_hdr,
19033: PA_XBS_DENORM wbs,
19034: PJI_XBS_DENORM prg,
19035: (
19036: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 19186: PJI_PJP_WBS_HEADER wbs_hdr,

19182: pjp1.CUSTOM14,
19183: pjp1.CUSTOM15
19184: from
19185: PJI_FP_AGGR_PJP1 pjp1,
19186: PJI_PJP_WBS_HEADER wbs_hdr,
19187: PJI_XBS_DENORM prg,
19188: (
19189: select 'Y' CB_FLAG,
19190: 'N' CO_FLAG,

Line 19337: PJI_PJP_WBS_HEADER wbs_hdr,

19333: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
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: (

Line 19455: PJI_PJP_WBS_HEADER wbs_hdr,

19451: prg.RELATIONSHIP_TYPE = prg_delta.RELATIONSHIP_TYPE (+) and
19452: -1 = prg_delta.SIGN (+) and
19453: prg_delta.SUP_PROJECT_ID is null
19454: ) prg,
19455: PJI_PJP_WBS_HEADER wbs_hdr,
19456: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
19457: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
19458: PA_PROJ_WORKPLAN_ATTR sup_wpa
19459: where

Line 20350: PJI_PJP_WBS_HEADER wbs_hdr,

20346: pjp1.CUSTOM14,
20347: pjp1.CUSTOM15
20348: from
20349: PJI_FP_AGGR_PJP1 pjp1,
20350: PJI_PJP_WBS_HEADER wbs_hdr,
20351: PA_XBS_DENORM wbs,
20352: PJI_XBS_DENORM prg,
20353: (
20354: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 20504: PJI_PJP_WBS_HEADER wbs_hdr,

20500: pjp1.CUSTOM14,
20501: pjp1.CUSTOM15
20502: from
20503: PJI_FP_AGGR_PJP1 pjp1,
20504: PJI_PJP_WBS_HEADER wbs_hdr,
20505: PJI_XBS_DENORM prg,
20506: (
20507: select 'Y' CB_FLAG,
20508: 'N' CO_FLAG,

Line 20655: PJI_PJP_WBS_HEADER wbs_hdr,

20651: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
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: (

Line 20773: PJI_PJP_WBS_HEADER wbs_hdr,

20769: prg.RELATIONSHIP_TYPE = prg_delta.RELATIONSHIP_TYPE (+) and
20770: -1 = prg_delta.SIGN (+) and
20771: prg_delta.SUP_PROJECT_ID is null
20772: ) prg,
20773: PJI_PJP_WBS_HEADER wbs_hdr,
20774: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
20775: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
20776: PA_PROJ_WORKPLAN_ATTR sup_wpa
20777: where

Line 21171: PJI_PJP_WBS_HEADER wbs_hdr,

21167: pjp1.CUSTOM14,
21168: pjp1.CUSTOM15
21169: from
21170: PJI_AC_AGGR_PJP1 pjp1,
21171: PJI_PJP_WBS_HEADER wbs_hdr,
21172: PA_XBS_DENORM wbs,
21173: PJI_XBS_DENORM prg,
21174: (
21175: select 1 WBS_SUP_LEVEL,

Line 21267: PJI_PJP_WBS_HEADER wbs_hdr,

21263: pjp1.CUSTOM14,
21264: pjp1.CUSTOM15
21265: from
21266: PJI_AC_AGGR_PJP1 pjp1,
21267: PJI_PJP_WBS_HEADER wbs_hdr,
21268: PJI_XBS_DENORM prg
21269: where
21270: prg.STRUCT_TYPE = 'PRG' and
21271: prg.SUP_LEVEL = l_level and

Line 21360: PJI_PJP_WBS_HEADER wbs_hdr,

21356: wbs.SIGN * acr.CUSTOM14 CUSTOM14,
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: (

Line 21753: PJI_PJP_WBS_HEADER wbs_hdr,

21749: pjp1.CUSTOM14,
21750: pjp1.CUSTOM15
21751: from
21752: PJI_AC_AGGR_PJP1 pjp1,
21753: PJI_PJP_WBS_HEADER wbs_hdr,
21754: PA_XBS_DENORM wbs,
21755: PJI_XBS_DENORM prg,
21756: (
21757: select 1 WBS_SUP_LEVEL,

Line 21849: PJI_PJP_WBS_HEADER wbs_hdr,

21845: pjp1.CUSTOM14,
21846: pjp1.CUSTOM15
21847: from
21848: PJI_AC_AGGR_PJP1 pjp1,
21849: PJI_PJP_WBS_HEADER wbs_hdr,
21850: PJI_XBS_DENORM prg
21851: where
21852: prg.STRUCT_TYPE = 'PRG' and
21853: prg.SUP_LEVEL = l_level and

Line 21942: PJI_PJP_WBS_HEADER wbs_hdr,

21938: wbs.SIGN * acr.CUSTOM14 CUSTOM14,
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: (

Line 22335: PJI_PJP_WBS_HEADER wbs_hdr,

22331: pjp1.CUSTOM14,
22332: pjp1.CUSTOM15
22333: from
22334: PJI_AC_AGGR_PJP1 pjp1,
22335: PJI_PJP_WBS_HEADER wbs_hdr,
22336: PA_XBS_DENORM wbs,
22337: PJI_XBS_DENORM prg,
22338: (
22339: select 1 WBS_SUP_LEVEL,

Line 22431: PJI_PJP_WBS_HEADER wbs_hdr,

22427: pjp1.CUSTOM14,
22428: pjp1.CUSTOM15
22429: from
22430: PJI_AC_AGGR_PJP1 pjp1,
22431: PJI_PJP_WBS_HEADER wbs_hdr,
22432: PJI_XBS_DENORM prg
22433: where
22434: prg.STRUCT_TYPE = 'PRG' and
22435: prg.SUP_LEVEL = l_level and

Line 22524: PJI_PJP_WBS_HEADER wbs_hdr,

22520: wbs.SIGN * acr.CUSTOM14 CUSTOM14,
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: (

Line 22917: PJI_PJP_WBS_HEADER wbs_hdr,

22913: pjp1.CUSTOM14,
22914: pjp1.CUSTOM15
22915: from
22916: PJI_AC_AGGR_PJP1 pjp1,
22917: PJI_PJP_WBS_HEADER wbs_hdr,
22918: PA_XBS_DENORM wbs,
22919: PJI_XBS_DENORM prg,
22920: (
22921: select 1 WBS_SUP_LEVEL,

Line 23013: PJI_PJP_WBS_HEADER wbs_hdr,

23009: pjp1.CUSTOM14,
23010: pjp1.CUSTOM15
23011: from
23012: PJI_AC_AGGR_PJP1 pjp1,
23013: PJI_PJP_WBS_HEADER wbs_hdr,
23014: PJI_XBS_DENORM prg
23015: where
23016: prg.STRUCT_TYPE = 'PRG' and
23017: prg.SUP_LEVEL = l_level and

Line 23106: PJI_PJP_WBS_HEADER wbs_hdr,

23102: wbs.SIGN * acr.CUSTOM14 CUSTOM14,
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: (

Line 23499: PJI_PJP_WBS_HEADER wbs_hdr,

23495: pjp1.CUSTOM14,
23496: pjp1.CUSTOM15
23497: from
23498: PJI_AC_AGGR_PJP1 pjp1,
23499: PJI_PJP_WBS_HEADER wbs_hdr,
23500: PA_XBS_DENORM wbs,
23501: PJI_XBS_DENORM prg,
23502: (
23503: select 1 WBS_SUP_LEVEL,

Line 23595: PJI_PJP_WBS_HEADER wbs_hdr,

23591: pjp1.CUSTOM14,
23592: pjp1.CUSTOM15
23593: from
23594: PJI_AC_AGGR_PJP1 pjp1,
23595: PJI_PJP_WBS_HEADER wbs_hdr,
23596: PJI_XBS_DENORM prg
23597: where
23598: prg.STRUCT_TYPE = 'PRG' and
23599: prg.SUP_LEVEL = l_level and

Line 23688: PJI_PJP_WBS_HEADER wbs_hdr,

23684: wbs.SIGN * acr.CUSTOM14 CUSTOM14,
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: (

Line 24081: PJI_PJP_WBS_HEADER wbs_hdr,

24077: pjp1.CUSTOM14,
24078: pjp1.CUSTOM15
24079: from
24080: PJI_AC_AGGR_PJP1 pjp1,
24081: PJI_PJP_WBS_HEADER wbs_hdr,
24082: PA_XBS_DENORM wbs,
24083: PJI_XBS_DENORM prg,
24084: (
24085: select 1 WBS_SUP_LEVEL,

Line 24177: PJI_PJP_WBS_HEADER wbs_hdr,

24173: pjp1.CUSTOM14,
24174: pjp1.CUSTOM15
24175: from
24176: PJI_AC_AGGR_PJP1 pjp1,
24177: PJI_PJP_WBS_HEADER wbs_hdr,
24178: PJI_XBS_DENORM prg
24179: where
24180: prg.STRUCT_TYPE = 'PRG' and
24181: prg.SUP_LEVEL = l_level and

Line 24270: PJI_PJP_WBS_HEADER wbs_hdr,

24266: wbs.SIGN * acr.CUSTOM14 CUSTOM14,
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: (

Line 24663: PJI_PJP_WBS_HEADER wbs_hdr,

24659: pjp1.CUSTOM14,
24660: pjp1.CUSTOM15
24661: from
24662: PJI_AC_AGGR_PJP1 pjp1,
24663: PJI_PJP_WBS_HEADER wbs_hdr,
24664: PA_XBS_DENORM wbs,
24665: PJI_XBS_DENORM prg,
24666: (
24667: select 1 WBS_SUP_LEVEL,

Line 24759: PJI_PJP_WBS_HEADER wbs_hdr,

24755: pjp1.CUSTOM14,
24756: pjp1.CUSTOM15
24757: from
24758: PJI_AC_AGGR_PJP1 pjp1,
24759: PJI_PJP_WBS_HEADER wbs_hdr,
24760: PJI_XBS_DENORM prg
24761: where
24762: prg.STRUCT_TYPE = 'PRG' and
24763: prg.SUP_LEVEL = l_level and

Line 24852: PJI_PJP_WBS_HEADER wbs_hdr,

24848: wbs.SIGN * acr.CUSTOM14 CUSTOM14,
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: (

Line 25245: PJI_PJP_WBS_HEADER wbs_hdr,

25241: pjp1.CUSTOM14,
25242: pjp1.CUSTOM15
25243: from
25244: PJI_AC_AGGR_PJP1 pjp1,
25245: PJI_PJP_WBS_HEADER wbs_hdr,
25246: PA_XBS_DENORM wbs,
25247: PJI_XBS_DENORM prg,
25248: (
25249: select 1 WBS_SUP_LEVEL,

Line 25341: PJI_PJP_WBS_HEADER wbs_hdr,

25337: pjp1.CUSTOM14,
25338: pjp1.CUSTOM15
25339: from
25340: PJI_AC_AGGR_PJP1 pjp1,
25341: PJI_PJP_WBS_HEADER wbs_hdr,
25342: PJI_XBS_DENORM prg
25343: where
25344: prg.STRUCT_TYPE = 'PRG' and
25345: prg.SUP_LEVEL = l_level and

Line 25434: PJI_PJP_WBS_HEADER wbs_hdr,

25430: wbs.SIGN * acr.CUSTOM14 CUSTOM14,
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: (

Line 25827: PJI_PJP_WBS_HEADER wbs_hdr,

25823: pjp1.CUSTOM14,
25824: pjp1.CUSTOM15
25825: from
25826: PJI_AC_AGGR_PJP1 pjp1,
25827: PJI_PJP_WBS_HEADER wbs_hdr,
25828: PA_XBS_DENORM wbs,
25829: PJI_XBS_DENORM prg,
25830: (
25831: select 1 WBS_SUP_LEVEL,

Line 25923: PJI_PJP_WBS_HEADER wbs_hdr,

25919: pjp1.CUSTOM14,
25920: pjp1.CUSTOM15
25921: from
25922: PJI_AC_AGGR_PJP1 pjp1,
25923: PJI_PJP_WBS_HEADER wbs_hdr,
25924: PJI_XBS_DENORM prg
25925: where
25926: prg.STRUCT_TYPE = 'PRG' and
25927: prg.SUP_LEVEL = l_level and

Line 26016: PJI_PJP_WBS_HEADER wbs_hdr,

26012: wbs.SIGN * acr.CUSTOM14 CUSTOM14,
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: (

Line 26409: PJI_PJP_WBS_HEADER wbs_hdr,

26405: pjp1.CUSTOM14,
26406: pjp1.CUSTOM15
26407: from
26408: PJI_AC_AGGR_PJP1 pjp1,
26409: PJI_PJP_WBS_HEADER wbs_hdr,
26410: PA_XBS_DENORM wbs,
26411: PJI_XBS_DENORM prg,
26412: (
26413: select 1 WBS_SUP_LEVEL,

Line 26505: PJI_PJP_WBS_HEADER wbs_hdr,

26501: pjp1.CUSTOM14,
26502: pjp1.CUSTOM15
26503: from
26504: PJI_AC_AGGR_PJP1 pjp1,
26505: PJI_PJP_WBS_HEADER wbs_hdr,
26506: PJI_XBS_DENORM prg
26507: where
26508: prg.STRUCT_TYPE = 'PRG' and
26509: prg.SUP_LEVEL = l_level and

Line 26598: PJI_PJP_WBS_HEADER wbs_hdr,

26594: wbs.SIGN * acr.CUSTOM14 CUSTOM14,
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: (

Line 27235: PJI_PJP_WBS_HEADER wbs_hdr,

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,
27238: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
27239: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

Line 27237: PJI_PJP_WBS_HEADER sup_wbs_hdr,

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,
27238: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
27239: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
27240: (
27241: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID

Line 27634: PJI_PJP_WBS_HEADER wbs_hdr,

27630: pjp1.CUSTOM14,
27631: pjp1.CUSTOM15
27632: from
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,

Line 27638: PJI_PJP_WBS_HEADER sup_wbs_hdr,

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: (
27642: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID

Line 28280: PJI_PJP_WBS_HEADER wbs_hdr,

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,
28283: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
28284: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

Line 28282: PJI_PJP_WBS_HEADER sup_wbs_hdr,

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,
28283: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
28284: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
28285: (
28286: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID

Line 28679: PJI_PJP_WBS_HEADER wbs_hdr,

28675: pjp1.CUSTOM14,
28676: pjp1.CUSTOM15
28677: from
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,

Line 28683: PJI_PJP_WBS_HEADER sup_wbs_hdr,

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: (
28687: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID

Line 29325: PJI_PJP_WBS_HEADER wbs_hdr,

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,
29328: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
29329: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

Line 29327: PJI_PJP_WBS_HEADER sup_wbs_hdr,

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,
29328: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
29329: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
29330: (
29331: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID

Line 29724: PJI_PJP_WBS_HEADER wbs_hdr,

29720: pjp1.CUSTOM14,
29721: pjp1.CUSTOM15
29722: from
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,

Line 29728: PJI_PJP_WBS_HEADER sup_wbs_hdr,

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: (
29732: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID

Line 30370: PJI_PJP_WBS_HEADER wbs_hdr,

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,
30373: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
30374: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

Line 30372: PJI_PJP_WBS_HEADER sup_wbs_hdr,

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,
30373: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
30374: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
30375: (
30376: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID

Line 30769: PJI_PJP_WBS_HEADER wbs_hdr,

30765: pjp1.CUSTOM14,
30766: pjp1.CUSTOM15
30767: from
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,

Line 30773: PJI_PJP_WBS_HEADER sup_wbs_hdr,

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: (
30777: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID

Line 31415: PJI_PJP_WBS_HEADER wbs_hdr,

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,
31418: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
31419: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

Line 31417: PJI_PJP_WBS_HEADER sup_wbs_hdr,

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,
31418: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
31419: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
31420: (
31421: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID

Line 31814: PJI_PJP_WBS_HEADER wbs_hdr,

31810: pjp1.CUSTOM14,
31811: pjp1.CUSTOM15
31812: from
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,

Line 31818: PJI_PJP_WBS_HEADER sup_wbs_hdr,

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: (
31822: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID

Line 32460: PJI_PJP_WBS_HEADER wbs_hdr,

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,
32463: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
32464: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

Line 32462: PJI_PJP_WBS_HEADER sup_wbs_hdr,

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,
32463: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
32464: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
32465: (
32466: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID

Line 32859: PJI_PJP_WBS_HEADER wbs_hdr,

32855: pjp1.CUSTOM14,
32856: pjp1.CUSTOM15
32857: from
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,

Line 32863: PJI_PJP_WBS_HEADER sup_wbs_hdr,

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: (
32867: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID

Line 33505: PJI_PJP_WBS_HEADER wbs_hdr,

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,
33508: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
33509: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

Line 33507: PJI_PJP_WBS_HEADER sup_wbs_hdr,

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,
33508: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
33509: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
33510: (
33511: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID

Line 33904: PJI_PJP_WBS_HEADER wbs_hdr,

33900: pjp1.CUSTOM14,
33901: pjp1.CUSTOM15
33902: from
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,

Line 33908: PJI_PJP_WBS_HEADER sup_wbs_hdr,

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: (
33912: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID

Line 34550: PJI_PJP_WBS_HEADER wbs_hdr,

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,
34553: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
34554: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

Line 34552: PJI_PJP_WBS_HEADER sup_wbs_hdr,

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,
34553: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
34554: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
34555: (
34556: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID

Line 34949: PJI_PJP_WBS_HEADER wbs_hdr,

34945: pjp1.CUSTOM14,
34946: pjp1.CUSTOM15
34947: from
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,

Line 34953: PJI_PJP_WBS_HEADER sup_wbs_hdr,

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: (
34957: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID

Line 35595: PJI_PJP_WBS_HEADER wbs_hdr,

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,
35598: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
35599: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

Line 35597: PJI_PJP_WBS_HEADER sup_wbs_hdr,

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,
35598: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
35599: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
35600: (
35601: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID

Line 35994: PJI_PJP_WBS_HEADER wbs_hdr,

35990: pjp1.CUSTOM14,
35991: pjp1.CUSTOM15
35992: from
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,

Line 35998: PJI_PJP_WBS_HEADER sup_wbs_hdr,

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: (
36002: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID

Line 36640: PJI_PJP_WBS_HEADER wbs_hdr,

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,
36643: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
36644: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

Line 36642: PJI_PJP_WBS_HEADER sup_wbs_hdr,

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,
36643: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
36644: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
36645: (
36646: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID

Line 37039: PJI_PJP_WBS_HEADER wbs_hdr,

37035: pjp1.CUSTOM14,
37036: pjp1.CUSTOM15
37037: from
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,

Line 37043: PJI_PJP_WBS_HEADER sup_wbs_hdr,

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: (
37047: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID

Line 37405: PJI_PJP_WBS_HEADER wbs_hdr,

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
37408: prg.WORKER_ID = p_worker_id and
37409: prg.STRUCT_TYPE = 'PRG' and

Line 37480: PJI_PJP_WBS_HEADER wbs_hdr,

37476: pjp1.CUSTOM14,
37477: pjp1.CUSTOM15
37478: from
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

Line 37748: PJI_PJP_WBS_HEADER wbs_hdr,

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
37751: prg.WORKER_ID = p_worker_id and
37752: prg.STRUCT_TYPE = 'PRG' and

Line 37823: PJI_PJP_WBS_HEADER wbs_hdr,

37819: pjp1.CUSTOM14,
37820: pjp1.CUSTOM15
37821: from
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

Line 38090: PJI_PJP_WBS_HEADER wbs_hdr,

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
38093: prg.WORKER_ID = p_worker_id and
38094: prg.STRUCT_TYPE = 'PRG' and

Line 38165: PJI_PJP_WBS_HEADER wbs_hdr,

38161: pjp1.CUSTOM14,
38162: pjp1.CUSTOM15
38163: from
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

Line 38432: PJI_PJP_WBS_HEADER wbs_hdr,

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
38435: prg.WORKER_ID = p_worker_id and
38436: prg.STRUCT_TYPE = 'PRG' and

Line 38507: PJI_PJP_WBS_HEADER wbs_hdr,

38503: pjp1.CUSTOM14,
38504: pjp1.CUSTOM15
38505: from
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

Line 38774: PJI_PJP_WBS_HEADER wbs_hdr,

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
38777: prg.WORKER_ID = p_worker_id and
38778: prg.STRUCT_TYPE = 'PRG' and

Line 38849: PJI_PJP_WBS_HEADER wbs_hdr,

38845: pjp1.CUSTOM14,
38846: pjp1.CUSTOM15
38847: from
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

Line 39116: PJI_PJP_WBS_HEADER wbs_hdr,

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
39119: prg.WORKER_ID = p_worker_id and
39120: prg.STRUCT_TYPE = 'PRG' and

Line 39191: PJI_PJP_WBS_HEADER wbs_hdr,

39187: pjp1.CUSTOM14,
39188: pjp1.CUSTOM15
39189: from
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

Line 39458: PJI_PJP_WBS_HEADER wbs_hdr,

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
39461: prg.WORKER_ID = p_worker_id and
39462: prg.STRUCT_TYPE = 'PRG' and

Line 39533: PJI_PJP_WBS_HEADER wbs_hdr,

39529: pjp1.CUSTOM14,
39530: pjp1.CUSTOM15
39531: from
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

Line 39800: PJI_PJP_WBS_HEADER wbs_hdr,

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
39803: prg.WORKER_ID = p_worker_id and
39804: prg.STRUCT_TYPE = 'PRG' and

Line 39875: PJI_PJP_WBS_HEADER wbs_hdr,

39871: pjp1.CUSTOM14,
39872: pjp1.CUSTOM15
39873: from
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

Line 40142: PJI_PJP_WBS_HEADER wbs_hdr,

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
40145: prg.WORKER_ID = p_worker_id and
40146: prg.STRUCT_TYPE = 'PRG' and

Line 40217: PJI_PJP_WBS_HEADER wbs_hdr,

40213: pjp1.CUSTOM14,
40214: pjp1.CUSTOM15
40215: from
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

Line 40484: PJI_PJP_WBS_HEADER wbs_hdr,

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
40487: prg.WORKER_ID = p_worker_id and
40488: prg.STRUCT_TYPE = 'PRG' and

Line 40559: PJI_PJP_WBS_HEADER wbs_hdr,

40555: pjp1.CUSTOM14,
40556: pjp1.CUSTOM15
40557: from
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

Line 45068: insert into PJI_PJP_WBS_HEADER_T

45064: OPEN c1(p_batch_id);
45065: FETCH c1 into p_worker_id, l_level, l_partial_mode, l_fpm_upgrade;
45066: close c1;
45067:
45068: insert into PJI_PJP_WBS_HEADER_T
45069: (
45070: PROJECT_ID,
45071: PLAN_VERSION_ID,
45072: WBS_VERSION_ID,

Line 45103: from PJI_PJP_WBS_HEADER a

45099: CREATION_DATE,
45100: CREATED_BY,
45101: LAST_UPDATE_LOGIN,
45102: PLAN_TYPE_CODE
45103: from PJI_PJP_WBS_HEADER a
45104: where a.project_id in ( select b.project_id from PJI_PJP_PROJ_BATCH_MAP b
45105: where b.worker_id = p_worker_id );
45106:
45107: insert into PJI_PA_XBS_DENORM_T

Line 45151: from PJI_PJP_WBS_HEADER_T b, PJI_PJP_PROJ_BATCH_MAP c

45147: STRUCT_EMT_ID,
45148: RELATIONSHIP_TYPE
45149: from PA_XBS_DENORM a
45150: where a.STRUCT_VERSION_ID in ( select /*+ cardinality(b,1) */ b.wbs_VERSION_ID -- Hint added for bug 11694228
45151: from PJI_PJP_WBS_HEADER_T b, PJI_PJP_PROJ_BATCH_MAP c
45152: where c.worker_id = p_worker_id
45153: and b.project_id = c.project_id)
45154: and a.struct_type||'' = 'WBS'||'';
45155: -- Bug 13097931 - Forward port bugfix 12879208

Line 46045: PJI_PJP_WBS_HEADER_T wbs_hdr,

46041: pjp1.CUSTOM15
46042: from
46043: PJI_FP_AGGR_PJP1 pjp1,
46044: PJI_HELPER_420 helper,
46045: PJI_PJP_WBS_HEADER_T wbs_hdr,
46046: PA_XBS_DENORM wbs,
46047: PJI_XBS_DENORM_T prg,
46048: (
46049: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 46202: PJI_PJP_WBS_HEADER_T wbs_hdr,

46198: pjp1.CUSTOM15
46199: from
46200: PJI_FP_AGGR_PJP1 pjp1,
46201: PJI_HELPER_420 helper, -- order in the From clause should not be changed unless recommended by perf team
46202: PJI_PJP_WBS_HEADER_T wbs_hdr,
46203: PJI_XBS_DENORM_T prg,
46204: (
46205: select 'Y' CB_FLAG,
46206: 'N' CO_FLAG,

Line 46356: PJI_PJP_WBS_HEADER_T wbs_hdr,

46352: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
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: (

Line 46476: PJI_PJP_WBS_HEADER_T wbs_hdr,

46472: prg.RELATIONSHIP_TYPE = prg_delta.RELATIONSHIP_TYPE (+) and
46473: -1 = prg_delta.SIGN (+) and
46474: prg_delta.SUP_PROJECT_ID is null
46475: ) prg,
46476: PJI_PJP_WBS_HEADER_T wbs_hdr,
46477: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
46478: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
46479: PA_PROJ_WORKPLAN_ATTR sup_wpa
46480: where