DBA Data[Home] [Help]

APPS.PJI_PJP_GEN_PERF_ALL dependencies on PJI_XBS_DENORM_DELTA

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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