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_GEN_PERF_ALL dependencies on PJI_XBS_DENORM

Line 3935: PJI_XBS_DENORM prg,

3931: from
3932: PJI_FP_AGGR_PJP1 pjp1,
3933: PJI_PJP_WBS_HEADER wbs_hdr,
3934: PA_XBS_DENORM wbs,
3935: PJI_XBS_DENORM prg,
3936: (
3937: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
3938: from DUAL union all
3939: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 4087: PJI_XBS_DENORM prg,

4083: pjp1.CUSTOM15
4084: from
4085: PJI_FP_AGGR_PJP1 pjp1,
4086: PJI_PJP_WBS_HEADER wbs_hdr,
4087: PJI_XBS_DENORM prg,
4088: (
4089: select 'Y' CB_FLAG,
4090: 'N' CO_FLAG,
4091: -3 PLAN_VERSION_ID

Line 4238: PJI_XBS_DENORM_DELTA wbs,

4234: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
4235: from
4236: PJI_PA_PROJ_EVENTS_LOG log,
4237: PJI_PJP_WBS_HEADER wbs_hdr,
4238: PJI_XBS_DENORM_DELTA wbs,
4239: PJI_XBS_DENORM prg,
4240: PJI_FP_XBS_ACCUM_F fpr,
4241: (
4242: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 4239: PJI_XBS_DENORM prg,

4235: from
4236: PJI_PA_PROJ_EVENTS_LOG log,
4237: PJI_PJP_WBS_HEADER wbs_hdr,
4238: PJI_XBS_DENORM_DELTA wbs,
4239: PJI_XBS_DENORM prg,
4240: PJI_FP_XBS_ACCUM_F fpr,
4241: (
4242: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
4243: from DUAL union all

Line 4327: PJI_XBS_DENORM prg,

4323: 'LF', 'N') WP_FLAG,
4324: 'Y' PUSHUP_FLAG
4325: from
4326: PJI_PJP_PROJ_BATCH_MAP map,
4327: PJI_XBS_DENORM prg,
4328: (
4329: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
4330: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
4331: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

Line 4334: PJI_XBS_DENORM_DELTA prg_delta

4330: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
4331: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
4332: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
4333: ) invert,
4334: PJI_XBS_DENORM_DELTA prg_delta
4335: where
4336: prg.STRUCT_TYPE = 'PRG' and
4337: prg.SUB_ROLLUP_ID is not null and
4338: prg.SUB_LEVEL = l_level and

Line 5250: PJI_XBS_DENORM prg,

5246: from
5247: PJI_FP_AGGR_PJP1 pjp1,
5248: PJI_PJP_WBS_HEADER wbs_hdr,
5249: PA_XBS_DENORM wbs,
5250: PJI_XBS_DENORM prg,
5251: (
5252: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
5253: from DUAL union all
5254: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 5402: PJI_XBS_DENORM prg,

5398: pjp1.CUSTOM15
5399: from
5400: PJI_FP_AGGR_PJP1 pjp1,
5401: PJI_PJP_WBS_HEADER wbs_hdr,
5402: PJI_XBS_DENORM prg,
5403: (
5404: select 'Y' CB_FLAG,
5405: 'N' CO_FLAG,
5406: -3 PLAN_VERSION_ID

Line 5553: PJI_XBS_DENORM_DELTA wbs,

5549: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
5550: from
5551: PJI_PA_PROJ_EVENTS_LOG log,
5552: PJI_PJP_WBS_HEADER wbs_hdr,
5553: PJI_XBS_DENORM_DELTA wbs,
5554: PJI_XBS_DENORM prg,
5555: PJI_FP_XBS_ACCUM_F fpr,
5556: (
5557: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 5554: PJI_XBS_DENORM prg,

5550: from
5551: PJI_PA_PROJ_EVENTS_LOG log,
5552: PJI_PJP_WBS_HEADER wbs_hdr,
5553: PJI_XBS_DENORM_DELTA wbs,
5554: PJI_XBS_DENORM prg,
5555: PJI_FP_XBS_ACCUM_F fpr,
5556: (
5557: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
5558: from DUAL union all

Line 5642: PJI_XBS_DENORM prg,

5638: 'LF', 'N') WP_FLAG,
5639: 'Y' PUSHUP_FLAG
5640: from
5641: PJI_PJP_PROJ_BATCH_MAP map,
5642: PJI_XBS_DENORM prg,
5643: (
5644: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
5645: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
5646: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

Line 5649: PJI_XBS_DENORM_DELTA prg_delta

5645: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
5646: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
5647: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
5648: ) invert,
5649: PJI_XBS_DENORM_DELTA prg_delta
5650: where
5651: prg.STRUCT_TYPE = 'PRG' and
5652: prg.SUB_ROLLUP_ID is not null and
5653: prg.SUB_LEVEL = l_level and

Line 6565: PJI_XBS_DENORM prg,

6561: from
6562: PJI_FP_AGGR_PJP1 pjp1,
6563: PJI_PJP_WBS_HEADER wbs_hdr,
6564: PA_XBS_DENORM wbs,
6565: PJI_XBS_DENORM prg,
6566: (
6567: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
6568: from DUAL union all
6569: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 6717: PJI_XBS_DENORM prg,

6713: pjp1.CUSTOM15
6714: from
6715: PJI_FP_AGGR_PJP1 pjp1,
6716: PJI_PJP_WBS_HEADER wbs_hdr,
6717: PJI_XBS_DENORM prg,
6718: (
6719: select 'Y' CB_FLAG,
6720: 'N' CO_FLAG,
6721: -3 PLAN_VERSION_ID

Line 6868: PJI_XBS_DENORM_DELTA wbs,

6864: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
6865: from
6866: PJI_PA_PROJ_EVENTS_LOG log,
6867: PJI_PJP_WBS_HEADER wbs_hdr,
6868: PJI_XBS_DENORM_DELTA wbs,
6869: PJI_XBS_DENORM prg,
6870: PJI_FP_XBS_ACCUM_F fpr,
6871: (
6872: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 6869: PJI_XBS_DENORM prg,

6865: from
6866: PJI_PA_PROJ_EVENTS_LOG log,
6867: PJI_PJP_WBS_HEADER wbs_hdr,
6868: PJI_XBS_DENORM_DELTA wbs,
6869: PJI_XBS_DENORM prg,
6870: PJI_FP_XBS_ACCUM_F fpr,
6871: (
6872: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
6873: from DUAL union all

Line 6957: PJI_XBS_DENORM prg,

6953: 'LF', 'N') WP_FLAG,
6954: 'Y' PUSHUP_FLAG
6955: from
6956: PJI_PJP_PROJ_BATCH_MAP map,
6957: PJI_XBS_DENORM prg,
6958: (
6959: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
6960: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
6961: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

Line 6964: PJI_XBS_DENORM_DELTA prg_delta

6960: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
6961: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
6962: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
6963: ) invert,
6964: PJI_XBS_DENORM_DELTA prg_delta
6965: where
6966: prg.STRUCT_TYPE = 'PRG' and
6967: prg.SUB_ROLLUP_ID is not null and
6968: prg.SUB_LEVEL = l_level and

Line 7879: PJI_XBS_DENORM prg,

7875: from
7876: PJI_FP_AGGR_PJP1 pjp1,
7877: PJI_PJP_WBS_HEADER wbs_hdr,
7878: PA_XBS_DENORM wbs,
7879: PJI_XBS_DENORM prg,
7880: (
7881: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7882: from DUAL union all
7883: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 8031: PJI_XBS_DENORM prg,

8027: pjp1.CUSTOM15
8028: from
8029: PJI_FP_AGGR_PJP1 pjp1,
8030: PJI_PJP_WBS_HEADER wbs_hdr,
8031: PJI_XBS_DENORM prg,
8032: (
8033: select 'Y' CB_FLAG,
8034: 'N' CO_FLAG,
8035: -3 PLAN_VERSION_ID

Line 8182: PJI_XBS_DENORM_DELTA wbs,

8178: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
8179: from
8180: PJI_PA_PROJ_EVENTS_LOG log,
8181: PJI_PJP_WBS_HEADER wbs_hdr,
8182: PJI_XBS_DENORM_DELTA wbs,
8183: PJI_XBS_DENORM prg,
8184: PJI_FP_XBS_ACCUM_F fpr,
8185: (
8186: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 8183: PJI_XBS_DENORM prg,

8179: from
8180: PJI_PA_PROJ_EVENTS_LOG log,
8181: PJI_PJP_WBS_HEADER wbs_hdr,
8182: PJI_XBS_DENORM_DELTA wbs,
8183: PJI_XBS_DENORM prg,
8184: PJI_FP_XBS_ACCUM_F fpr,
8185: (
8186: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8187: from DUAL union all

Line 8271: PJI_XBS_DENORM prg,

8267: 'LF', 'N') WP_FLAG,
8268: 'Y' PUSHUP_FLAG
8269: from
8270: PJI_PJP_PROJ_BATCH_MAP map,
8271: PJI_XBS_DENORM prg,
8272: (
8273: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8274: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8275: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

Line 8278: PJI_XBS_DENORM_DELTA prg_delta

8274: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8275: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8276: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
8277: ) invert,
8278: PJI_XBS_DENORM_DELTA prg_delta
8279: where
8280: prg.STRUCT_TYPE = 'PRG' and
8281: prg.SUB_ROLLUP_ID is not null and
8282: prg.SUB_LEVEL = l_level and

Line 9193: PJI_XBS_DENORM prg,

9189: from
9190: PJI_FP_AGGR_PJP1 pjp1,
9191: PJI_PJP_WBS_HEADER wbs_hdr,
9192: PA_XBS_DENORM wbs,
9193: PJI_XBS_DENORM prg,
9194: (
9195: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9196: from DUAL union all
9197: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 9345: PJI_XBS_DENORM prg,

9341: pjp1.CUSTOM15
9342: from
9343: PJI_FP_AGGR_PJP1 pjp1,
9344: PJI_PJP_WBS_HEADER wbs_hdr,
9345: PJI_XBS_DENORM prg,
9346: (
9347: select 'Y' CB_FLAG,
9348: 'N' CO_FLAG,
9349: -3 PLAN_VERSION_ID

Line 9496: PJI_XBS_DENORM_DELTA wbs,

9492: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
9493: from
9494: PJI_PA_PROJ_EVENTS_LOG log,
9495: PJI_PJP_WBS_HEADER wbs_hdr,
9496: PJI_XBS_DENORM_DELTA wbs,
9497: PJI_XBS_DENORM prg,
9498: PJI_FP_XBS_ACCUM_F fpr,
9499: (
9500: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 9497: PJI_XBS_DENORM prg,

9493: from
9494: PJI_PA_PROJ_EVENTS_LOG log,
9495: PJI_PJP_WBS_HEADER wbs_hdr,
9496: PJI_XBS_DENORM_DELTA wbs,
9497: PJI_XBS_DENORM prg,
9498: PJI_FP_XBS_ACCUM_F fpr,
9499: (
9500: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9501: from DUAL union all

Line 9585: PJI_XBS_DENORM prg,

9581: 'LF', 'N') WP_FLAG,
9582: 'Y' PUSHUP_FLAG
9583: from
9584: PJI_PJP_PROJ_BATCH_MAP map,
9585: PJI_XBS_DENORM prg,
9586: (
9587: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9588: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
9589: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

Line 9592: PJI_XBS_DENORM_DELTA prg_delta

9588: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
9589: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9590: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
9591: ) invert,
9592: PJI_XBS_DENORM_DELTA prg_delta
9593: where
9594: prg.STRUCT_TYPE = 'PRG' and
9595: prg.SUB_ROLLUP_ID is not null and
9596: prg.SUB_LEVEL = l_level and

Line 10507: PJI_XBS_DENORM prg,

10503: from
10504: PJI_FP_AGGR_PJP1 pjp1,
10505: PJI_PJP_WBS_HEADER wbs_hdr,
10506: PA_XBS_DENORM wbs,
10507: PJI_XBS_DENORM prg,
10508: (
10509: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10510: from DUAL union all
10511: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 10659: PJI_XBS_DENORM prg,

10655: pjp1.CUSTOM15
10656: from
10657: PJI_FP_AGGR_PJP1 pjp1,
10658: PJI_PJP_WBS_HEADER wbs_hdr,
10659: PJI_XBS_DENORM prg,
10660: (
10661: select 'Y' CB_FLAG,
10662: 'N' CO_FLAG,
10663: -3 PLAN_VERSION_ID

Line 10810: PJI_XBS_DENORM_DELTA wbs,

10806: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
10807: from
10808: PJI_PA_PROJ_EVENTS_LOG log,
10809: PJI_PJP_WBS_HEADER wbs_hdr,
10810: PJI_XBS_DENORM_DELTA wbs,
10811: PJI_XBS_DENORM prg,
10812: PJI_FP_XBS_ACCUM_F fpr,
10813: (
10814: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 10811: PJI_XBS_DENORM prg,

10807: from
10808: PJI_PA_PROJ_EVENTS_LOG log,
10809: PJI_PJP_WBS_HEADER wbs_hdr,
10810: PJI_XBS_DENORM_DELTA wbs,
10811: PJI_XBS_DENORM prg,
10812: PJI_FP_XBS_ACCUM_F fpr,
10813: (
10814: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10815: from DUAL union all

Line 10899: PJI_XBS_DENORM prg,

10895: 'LF', 'N') WP_FLAG,
10896: 'Y' PUSHUP_FLAG
10897: from
10898: PJI_PJP_PROJ_BATCH_MAP map,
10899: PJI_XBS_DENORM prg,
10900: (
10901: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10902: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
10903: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

Line 10906: PJI_XBS_DENORM_DELTA prg_delta

10902: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
10903: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10904: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
10905: ) invert,
10906: PJI_XBS_DENORM_DELTA prg_delta
10907: where
10908: prg.STRUCT_TYPE = 'PRG' and
10909: prg.SUB_ROLLUP_ID is not null and
10910: prg.SUB_LEVEL = l_level and

Line 11821: PJI_XBS_DENORM prg,

11817: from
11818: PJI_FP_AGGR_PJP1 pjp1,
11819: PJI_PJP_WBS_HEADER wbs_hdr,
11820: PA_XBS_DENORM wbs,
11821: PJI_XBS_DENORM prg,
11822: (
11823: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11824: from DUAL union all
11825: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 11973: PJI_XBS_DENORM prg,

11969: pjp1.CUSTOM15
11970: from
11971: PJI_FP_AGGR_PJP1 pjp1,
11972: PJI_PJP_WBS_HEADER wbs_hdr,
11973: PJI_XBS_DENORM prg,
11974: (
11975: select 'Y' CB_FLAG,
11976: 'N' CO_FLAG,
11977: -3 PLAN_VERSION_ID

Line 12124: PJI_XBS_DENORM_DELTA wbs,

12120: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
12121: from
12122: PJI_PA_PROJ_EVENTS_LOG log,
12123: PJI_PJP_WBS_HEADER wbs_hdr,
12124: PJI_XBS_DENORM_DELTA wbs,
12125: PJI_XBS_DENORM prg,
12126: PJI_FP_XBS_ACCUM_F fpr,
12127: (
12128: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 12125: PJI_XBS_DENORM prg,

12121: from
12122: PJI_PA_PROJ_EVENTS_LOG log,
12123: PJI_PJP_WBS_HEADER wbs_hdr,
12124: PJI_XBS_DENORM_DELTA wbs,
12125: PJI_XBS_DENORM prg,
12126: PJI_FP_XBS_ACCUM_F fpr,
12127: (
12128: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12129: from DUAL union all

Line 12213: PJI_XBS_DENORM prg,

12209: 'LF', 'N') WP_FLAG,
12210: 'Y' PUSHUP_FLAG
12211: from
12212: PJI_PJP_PROJ_BATCH_MAP map,
12213: PJI_XBS_DENORM prg,
12214: (
12215: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12216: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
12217: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

Line 12220: PJI_XBS_DENORM_DELTA prg_delta

12216: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
12217: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12218: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
12219: ) invert,
12220: PJI_XBS_DENORM_DELTA prg_delta
12221: where
12222: prg.STRUCT_TYPE = 'PRG' and
12223: prg.SUB_ROLLUP_ID is not null and
12224: prg.SUB_LEVEL = l_level and

Line 13135: PJI_XBS_DENORM prg,

13131: from
13132: PJI_FP_AGGR_PJP1 pjp1,
13133: PJI_PJP_WBS_HEADER wbs_hdr,
13134: PA_XBS_DENORM wbs,
13135: PJI_XBS_DENORM prg,
13136: (
13137: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13138: from DUAL union all
13139: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 13287: PJI_XBS_DENORM prg,

13283: pjp1.CUSTOM15
13284: from
13285: PJI_FP_AGGR_PJP1 pjp1,
13286: PJI_PJP_WBS_HEADER wbs_hdr,
13287: PJI_XBS_DENORM prg,
13288: (
13289: select 'Y' CB_FLAG,
13290: 'N' CO_FLAG,
13291: -3 PLAN_VERSION_ID

Line 13438: PJI_XBS_DENORM_DELTA wbs,

13434: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
13435: from
13436: PJI_PA_PROJ_EVENTS_LOG log,
13437: PJI_PJP_WBS_HEADER wbs_hdr,
13438: PJI_XBS_DENORM_DELTA wbs,
13439: PJI_XBS_DENORM prg,
13440: PJI_FP_XBS_ACCUM_F fpr,
13441: (
13442: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 13439: PJI_XBS_DENORM prg,

13435: from
13436: PJI_PA_PROJ_EVENTS_LOG log,
13437: PJI_PJP_WBS_HEADER wbs_hdr,
13438: PJI_XBS_DENORM_DELTA wbs,
13439: PJI_XBS_DENORM prg,
13440: PJI_FP_XBS_ACCUM_F fpr,
13441: (
13442: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13443: from DUAL union all

Line 13527: PJI_XBS_DENORM prg,

13523: 'LF', 'N') WP_FLAG,
13524: 'Y' PUSHUP_FLAG
13525: from
13526: PJI_PJP_PROJ_BATCH_MAP map,
13527: PJI_XBS_DENORM prg,
13528: (
13529: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
13530: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
13531: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

Line 13534: PJI_XBS_DENORM_DELTA prg_delta

13530: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
13531: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
13532: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
13533: ) invert,
13534: PJI_XBS_DENORM_DELTA prg_delta
13535: where
13536: prg.STRUCT_TYPE = 'PRG' and
13537: prg.SUB_ROLLUP_ID is not null and
13538: prg.SUB_LEVEL = l_level and

Line 14449: PJI_XBS_DENORM prg,

14445: from
14446: PJI_FP_AGGR_PJP1 pjp1,
14447: PJI_PJP_WBS_HEADER wbs_hdr,
14448: PA_XBS_DENORM wbs,
14449: PJI_XBS_DENORM prg,
14450: (
14451: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
14452: from DUAL union all
14453: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 14601: PJI_XBS_DENORM prg,

14597: pjp1.CUSTOM15
14598: from
14599: PJI_FP_AGGR_PJP1 pjp1,
14600: PJI_PJP_WBS_HEADER wbs_hdr,
14601: PJI_XBS_DENORM prg,
14602: (
14603: select 'Y' CB_FLAG,
14604: 'N' CO_FLAG,
14605: -3 PLAN_VERSION_ID

Line 14752: PJI_XBS_DENORM_DELTA wbs,

14748: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
14749: from
14750: PJI_PA_PROJ_EVENTS_LOG log,
14751: PJI_PJP_WBS_HEADER wbs_hdr,
14752: PJI_XBS_DENORM_DELTA wbs,
14753: PJI_XBS_DENORM prg,
14754: PJI_FP_XBS_ACCUM_F fpr,
14755: (
14756: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 14753: PJI_XBS_DENORM prg,

14749: from
14750: PJI_PA_PROJ_EVENTS_LOG log,
14751: PJI_PJP_WBS_HEADER wbs_hdr,
14752: PJI_XBS_DENORM_DELTA wbs,
14753: PJI_XBS_DENORM prg,
14754: PJI_FP_XBS_ACCUM_F fpr,
14755: (
14756: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
14757: from DUAL union all

Line 14841: PJI_XBS_DENORM prg,

14837: 'LF', 'N') WP_FLAG,
14838: 'Y' PUSHUP_FLAG
14839: from
14840: PJI_PJP_PROJ_BATCH_MAP map,
14841: PJI_XBS_DENORM prg,
14842: (
14843: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14844: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
14845: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

Line 14848: PJI_XBS_DENORM_DELTA prg_delta

14844: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
14845: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14846: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
14847: ) invert,
14848: PJI_XBS_DENORM_DELTA prg_delta
14849: where
14850: prg.STRUCT_TYPE = 'PRG' and
14851: prg.SUB_ROLLUP_ID is not null and
14852: prg.SUB_LEVEL = l_level and

Line 15763: PJI_XBS_DENORM prg,

15759: from
15760: PJI_FP_AGGR_PJP1 pjp1,
15761: PJI_PJP_WBS_HEADER wbs_hdr,
15762: PA_XBS_DENORM wbs,
15763: PJI_XBS_DENORM prg,
15764: (
15765: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15766: from DUAL union all
15767: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID

Line 15915: PJI_XBS_DENORM prg,

15911: pjp1.CUSTOM15
15912: from
15913: PJI_FP_AGGR_PJP1 pjp1,
15914: PJI_PJP_WBS_HEADER wbs_hdr,
15915: PJI_XBS_DENORM prg,
15916: (
15917: select 'Y' CB_FLAG,
15918: 'N' CO_FLAG,
15919: -3 PLAN_VERSION_ID

Line 16066: PJI_XBS_DENORM_DELTA wbs,

16062: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
16063: from
16064: PJI_PA_PROJ_EVENTS_LOG log,
16065: PJI_PJP_WBS_HEADER wbs_hdr,
16066: PJI_XBS_DENORM_DELTA wbs,
16067: PJI_XBS_DENORM prg,
16068: PJI_FP_XBS_ACCUM_F fpr,
16069: (
16070: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID

Line 16067: PJI_XBS_DENORM prg,

16063: from
16064: PJI_PA_PROJ_EVENTS_LOG log,
16065: PJI_PJP_WBS_HEADER wbs_hdr,
16066: PJI_XBS_DENORM_DELTA wbs,
16067: PJI_XBS_DENORM prg,
16068: PJI_FP_XBS_ACCUM_F fpr,
16069: (
16070: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16071: from DUAL union all

Line 16155: PJI_XBS_DENORM prg,

16151: 'LF', 'N') WP_FLAG,
16152: 'Y' PUSHUP_FLAG
16153: from
16154: PJI_PJP_PROJ_BATCH_MAP map,
16155: PJI_XBS_DENORM prg,
16156: (
16157: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16158: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
16159: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

Line 16162: PJI_XBS_DENORM_DELTA prg_delta

16158: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
16159: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16160: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
16161: ) invert,
16162: PJI_XBS_DENORM_DELTA prg_delta
16163: where
16164: prg.STRUCT_TYPE = 'PRG' and
16165: prg.SUB_ROLLUP_ID is not null and
16166: prg.SUB_LEVEL = l_level and