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 DUAL

Line 56: from DUAL;

52:
53: execute immediate 'begin
54: select PJI_RM_SUM_MAIN.g_process
55: into :l_stage2_pji_process
56: from DUAL;
57: end;'
58: using out l_stage2_pji_process;
59:
60: exception when others then

Line 214: -- This utility procedure is called from individual steps.

210:
211: -- ----------------------------------------------------------
212: -- procedure REGISTER_STEP_COMPLETION
213: --
214: -- This utility procedure is called from individual steps.
215: -- Procedure updates process log table with successful
216: -- completion status for a given step.
217: -- ----------------------------------------------------------
218: procedure REGISTER_STEP_COMPLETION

Line 613: from DUAL;

609:
610: execute immediate 'begin
611: select PJI_RM_SUM_MAIN.g_process
612: into :l_stage2_pji_process
613: from DUAL;
614: end;'
615: using out l_stage2_pji_process;
616:
617: if (p_process = l_stage2_pji_process) then

Line 8489: from DUAL union all

8485: PA_XBS_DENORM wbs,
8486: PJI_XBS_DENORM prg,
8487: (
8488: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8489: from DUAL union all
8490: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8491: from DUAL union all
8492: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8493: from DUAL union all

Line 8491: from DUAL union all

8487: (
8488: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8489: from DUAL union all
8490: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8491: from DUAL union all
8492: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8493: from DUAL union all
8494: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8495: from DUAL union all

Line 8493: from DUAL union all

8489: from DUAL union all
8490: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8491: from DUAL union all
8492: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8493: from DUAL union all
8494: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8495: from DUAL union all
8496: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8497: from DUAL union all

Line 8495: from DUAL union all

8491: from DUAL union all
8492: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8493: from DUAL union all
8494: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8495: from DUAL union all
8496: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8497: from DUAL union all
8498: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8499: from DUAL union all

Line 8497: from DUAL union all

8493: from DUAL union all
8494: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8495: from DUAL union all
8496: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8497: from DUAL union all
8498: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8499: from DUAL union all
8500: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8501: from DUAL union all

Line 8499: from DUAL union all

8495: from DUAL union all
8496: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8497: from DUAL union all
8498: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8499: from DUAL union all
8500: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8501: from DUAL union all
8502: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8503: from DUAL

Line 8501: from DUAL union all

8497: from DUAL union all
8498: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8499: from DUAL union all
8500: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8501: from DUAL union all
8502: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8503: from DUAL
8504: ) fin_plan,
8505: (

Line 8503: from DUAL

8499: from DUAL union all
8500: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8501: from DUAL union all
8502: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8503: from DUAL
8504: ) fin_plan,
8505: (
8506: select 1 WBS_SUP_LEVEL,
8507: 1 WBS_SUB_LEVEL,

Line 8509: from DUAL

8505: (
8506: select 1 WBS_SUP_LEVEL,
8507: 1 WBS_SUB_LEVEL,
8508: 'PRJ' INVERT_ID
8509: from DUAL
8510: union all
8511: select 1 WBS_SUP_LEVEL,
8512: 1 WBS_SUB_LEVEL,
8513: 'WBS' INVERT_ID

Line 8514: from DUAL

8510: union all
8511: select 1 WBS_SUP_LEVEL,
8512: 1 WBS_SUB_LEVEL,
8513: 'WBS' INVERT_ID
8514: from DUAL
8515: ) top_slice
8516: where
8517: prg.STRUCT_TYPE = 'PRG' and
8518: prg.SUP_LEVEL = l_level and

Line 8644: from DUAL union all

8640: (
8641: select 'Y' CB_FLAG,
8642: 'N' CO_FLAG,
8643: -3 PLAN_VERSION_ID
8644: from DUAL union all
8645: select 'N' CB_FLAG,
8646: 'Y' CO_FLAG,
8647: -4 PLAN_VERSION_ID
8648: from DUAL union all

Line 8648: from DUAL union all

8644: from DUAL union all
8645: select 'N' CB_FLAG,
8646: 'Y' CO_FLAG,
8647: -4 PLAN_VERSION_ID
8648: from DUAL union all
8649: select 'Y' CB_FLAG,
8650: 'Y' CO_FLAG,
8651: -3 PLAN_VERSION_ID
8652: from DUAL union all

Line 8652: from DUAL union all

8648: from DUAL union all
8649: select 'Y' CB_FLAG,
8650: 'Y' CO_FLAG,
8651: -3 PLAN_VERSION_ID
8652: from DUAL union all
8653: select 'Y' CB_FLAG,
8654: 'Y' CO_FLAG,
8655: -4 PLAN_VERSION_ID
8656: from DUAL

Line 8656: from DUAL

8652: from DUAL union all
8653: select 'Y' CB_FLAG,
8654: 'Y' CO_FLAG,
8655: -4 PLAN_VERSION_ID
8656: from DUAL
8657: ) fin_plan
8658: where
8659: prg.STRUCT_TYPE = 'PRG' and
8660: prg.SUP_LEVEL = l_level and

Line 8795: from DUAL union all

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
8795: from DUAL union all
8796: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8797: from DUAL union all
8798: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8799: from DUAL union all

Line 8797: from DUAL union all

8793: (
8794: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8795: from DUAL union all
8796: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8797: from DUAL union all
8798: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8799: from DUAL union all
8800: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8801: from DUAL union all

Line 8799: from DUAL union all

8795: from DUAL union all
8796: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8797: from DUAL union all
8798: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8799: from DUAL union all
8800: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8801: from DUAL union all
8802: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8803: from DUAL union all

Line 8801: from DUAL union all

8797: from DUAL union all
8798: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8799: from DUAL union all
8800: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8801: from DUAL union all
8802: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8803: from DUAL union all
8804: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8805: from DUAL union all

Line 8803: from DUAL union all

8799: from DUAL union all
8800: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8801: from DUAL union all
8802: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8803: from DUAL union all
8804: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8805: from DUAL union all
8806: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8807: from DUAL union all

Line 8805: from DUAL union all

8801: from DUAL union all
8802: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8803: from DUAL union all
8804: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8805: from DUAL union all
8806: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8807: from DUAL union all
8808: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8809: from DUAL

Line 8807: from DUAL union all

8803: from DUAL union all
8804: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8805: from DUAL union all
8806: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8807: from DUAL union all
8808: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8809: from DUAL
8810: ) fin_plan,
8811: (

Line 8809: from DUAL

8805: from DUAL union all
8806: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8807: from DUAL union all
8808: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8809: from DUAL
8810: ) fin_plan,
8811: (
8812: select 1 WBS_SUP_LEVEL,
8813: 1 WBS_SUB_LEVEL,

Line 8815: from DUAL

8811: (
8812: select 1 WBS_SUP_LEVEL,
8813: 1 WBS_SUB_LEVEL,
8814: 'PRJ' INVERT_ID
8815: from DUAL
8816: union all
8817: select 1 WBS_SUP_LEVEL,
8818: 1 WBS_SUB_LEVEL,
8819: 'WBS' INVERT_ID

Line 8820: from DUAL

8816: union all
8817: select 1 WBS_SUP_LEVEL,
8818: 1 WBS_SUB_LEVEL,
8819: 'WBS' INVERT_ID
8820: from DUAL
8821: ) top_slice
8822: where
8823: prg.STRUCT_TYPE = 'PRG' and
8824: prg.SUP_LEVEL = l_level and

Line 8881: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all

8877: from
8878: PJI_PJP_PROJ_BATCH_MAP map,
8879: PJI_XBS_DENORM prg,
8880: (
8881: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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,

Line 8882: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

8878: PJI_PJP_PROJ_BATCH_MAP map,
8879: PJI_XBS_DENORM prg,
8880: (
8881: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 8883: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

8879: PJI_XBS_DENORM prg,
8880: (
8881: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 8884: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual

8880: (
8881: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 9810: from DUAL union all

9806: PA_XBS_DENORM wbs,
9807: PJI_XBS_DENORM prg,
9808: (
9809: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9810: from DUAL union all
9811: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9812: from DUAL union all
9813: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9814: from DUAL union all

Line 9812: from DUAL union all

9808: (
9809: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9810: from DUAL union all
9811: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9812: from DUAL union all
9813: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9814: from DUAL union all
9815: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9816: from DUAL union all

Line 9814: from DUAL union all

9810: from DUAL union all
9811: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9812: from DUAL union all
9813: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9814: from DUAL union all
9815: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9816: from DUAL union all
9817: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9818: from DUAL union all

Line 9816: from DUAL union all

9812: from DUAL union all
9813: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9814: from DUAL union all
9815: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9816: from DUAL union all
9817: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9818: from DUAL union all
9819: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9820: from DUAL union all

Line 9818: from DUAL union all

9814: from DUAL union all
9815: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9816: from DUAL union all
9817: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9818: from DUAL union all
9819: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9820: from DUAL union all
9821: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9822: from DUAL union all

Line 9820: from DUAL union all

9816: from DUAL union all
9817: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9818: from DUAL union all
9819: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9820: from DUAL union all
9821: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9822: from DUAL union all
9823: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9824: from DUAL

Line 9822: from DUAL union all

9818: from DUAL union all
9819: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9820: from DUAL union all
9821: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9822: from DUAL union all
9823: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9824: from DUAL
9825: ) fin_plan,
9826: (

Line 9824: from DUAL

9820: from DUAL union all
9821: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9822: from DUAL union all
9823: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9824: from DUAL
9825: ) fin_plan,
9826: (
9827: select 1 WBS_SUP_LEVEL,
9828: 1 WBS_SUB_LEVEL,

Line 9830: from DUAL

9826: (
9827: select 1 WBS_SUP_LEVEL,
9828: 1 WBS_SUB_LEVEL,
9829: 'PRJ' INVERT_ID
9830: from DUAL
9831: union all
9832: select 1 WBS_SUP_LEVEL,
9833: 1 WBS_SUB_LEVEL,
9834: 'WBS' INVERT_ID

Line 9835: from DUAL

9831: union all
9832: select 1 WBS_SUP_LEVEL,
9833: 1 WBS_SUB_LEVEL,
9834: 'WBS' INVERT_ID
9835: from DUAL
9836: ) top_slice
9837: where
9838: prg.STRUCT_TYPE = 'PRG' and
9839: prg.SUP_LEVEL = l_level and

Line 9965: from DUAL union all

9961: (
9962: select 'Y' CB_FLAG,
9963: 'N' CO_FLAG,
9964: -3 PLAN_VERSION_ID
9965: from DUAL union all
9966: select 'N' CB_FLAG,
9967: 'Y' CO_FLAG,
9968: -4 PLAN_VERSION_ID
9969: from DUAL union all

Line 9969: from DUAL union all

9965: from DUAL union all
9966: select 'N' CB_FLAG,
9967: 'Y' CO_FLAG,
9968: -4 PLAN_VERSION_ID
9969: from DUAL union all
9970: select 'Y' CB_FLAG,
9971: 'Y' CO_FLAG,
9972: -3 PLAN_VERSION_ID
9973: from DUAL union all

Line 9973: from DUAL union all

9969: from DUAL union all
9970: select 'Y' CB_FLAG,
9971: 'Y' CO_FLAG,
9972: -3 PLAN_VERSION_ID
9973: from DUAL union all
9974: select 'Y' CB_FLAG,
9975: 'Y' CO_FLAG,
9976: -4 PLAN_VERSION_ID
9977: from DUAL

Line 9977: from DUAL

9973: from DUAL union all
9974: select 'Y' CB_FLAG,
9975: 'Y' CO_FLAG,
9976: -4 PLAN_VERSION_ID
9977: from DUAL
9978: ) fin_plan
9979: where
9980: prg.STRUCT_TYPE = 'PRG' and
9981: prg.SUP_LEVEL = l_level and

Line 10116: from DUAL union all

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
10116: from DUAL union all
10117: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10118: from DUAL union all
10119: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10120: from DUAL union all

Line 10118: from DUAL union all

10114: (
10115: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10116: from DUAL union all
10117: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10118: from DUAL union all
10119: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10120: from DUAL union all
10121: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10122: from DUAL union all

Line 10120: from DUAL union all

10116: from DUAL union all
10117: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10118: from DUAL union all
10119: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10120: from DUAL union all
10121: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10122: from DUAL union all
10123: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10124: from DUAL union all

Line 10122: from DUAL union all

10118: from DUAL union all
10119: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10120: from DUAL union all
10121: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10122: from DUAL union all
10123: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10124: from DUAL union all
10125: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10126: from DUAL union all

Line 10124: from DUAL union all

10120: from DUAL union all
10121: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10122: from DUAL union all
10123: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10124: from DUAL union all
10125: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10126: from DUAL union all
10127: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10128: from DUAL union all

Line 10126: from DUAL union all

10122: from DUAL union all
10123: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10124: from DUAL union all
10125: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10126: from DUAL union all
10127: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10128: from DUAL union all
10129: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10130: from DUAL

Line 10128: from DUAL union all

10124: from DUAL union all
10125: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10126: from DUAL union all
10127: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10128: from DUAL union all
10129: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10130: from DUAL
10131: ) fin_plan,
10132: (

Line 10130: from DUAL

10126: from DUAL union all
10127: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10128: from DUAL union all
10129: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10130: from DUAL
10131: ) fin_plan,
10132: (
10133: select 1 WBS_SUP_LEVEL,
10134: 1 WBS_SUB_LEVEL,

Line 10136: from DUAL

10132: (
10133: select 1 WBS_SUP_LEVEL,
10134: 1 WBS_SUB_LEVEL,
10135: 'PRJ' INVERT_ID
10136: from DUAL
10137: union all
10138: select 1 WBS_SUP_LEVEL,
10139: 1 WBS_SUB_LEVEL,
10140: 'WBS' INVERT_ID

Line 10141: from DUAL

10137: union all
10138: select 1 WBS_SUP_LEVEL,
10139: 1 WBS_SUB_LEVEL,
10140: 'WBS' INVERT_ID
10141: from DUAL
10142: ) top_slice
10143: where
10144: prg.STRUCT_TYPE = 'PRG' and
10145: prg.SUP_LEVEL = l_level and

Line 10202: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all

10198: from
10199: PJI_PJP_PROJ_BATCH_MAP map,
10200: PJI_XBS_DENORM prg,
10201: (
10202: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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,

Line 10203: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

10199: PJI_PJP_PROJ_BATCH_MAP map,
10200: PJI_XBS_DENORM prg,
10201: (
10202: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 10204: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

10200: PJI_XBS_DENORM prg,
10201: (
10202: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 10205: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual

10201: (
10202: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 11129: from DUAL union all

11125: PA_XBS_DENORM wbs,
11126: PJI_XBS_DENORM prg,
11127: (
11128: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11129: from DUAL union all
11130: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11131: from DUAL union all
11132: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11133: from DUAL union all

Line 11131: from DUAL union all

11127: (
11128: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11129: from DUAL union all
11130: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11131: from DUAL union all
11132: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11133: from DUAL union all
11134: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11135: from DUAL union all

Line 11133: from DUAL union all

11129: from DUAL union all
11130: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11131: from DUAL union all
11132: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11133: from DUAL union all
11134: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11135: from DUAL union all
11136: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11137: from DUAL union all

Line 11135: from DUAL union all

11131: from DUAL union all
11132: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11133: from DUAL union all
11134: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11135: from DUAL union all
11136: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11137: from DUAL union all
11138: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11139: from DUAL union all

Line 11137: from DUAL union all

11133: from DUAL union all
11134: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11135: from DUAL union all
11136: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11137: from DUAL union all
11138: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11139: from DUAL union all
11140: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11141: from DUAL union all

Line 11139: from DUAL union all

11135: from DUAL union all
11136: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11137: from DUAL union all
11138: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11139: from DUAL union all
11140: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11141: from DUAL union all
11142: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11143: from DUAL

Line 11141: from DUAL union all

11137: from DUAL union all
11138: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11139: from DUAL union all
11140: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11141: from DUAL union all
11142: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11143: from DUAL
11144: ) fin_plan,
11145: (

Line 11143: from DUAL

11139: from DUAL union all
11140: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11141: from DUAL union all
11142: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11143: from DUAL
11144: ) fin_plan,
11145: (
11146: select 1 WBS_SUP_LEVEL,
11147: 1 WBS_SUB_LEVEL,

Line 11149: from DUAL

11145: (
11146: select 1 WBS_SUP_LEVEL,
11147: 1 WBS_SUB_LEVEL,
11148: 'PRJ' INVERT_ID
11149: from DUAL
11150: union all
11151: select 1 WBS_SUP_LEVEL,
11152: 1 WBS_SUB_LEVEL,
11153: 'WBS' INVERT_ID

Line 11154: from DUAL

11150: union all
11151: select 1 WBS_SUP_LEVEL,
11152: 1 WBS_SUB_LEVEL,
11153: 'WBS' INVERT_ID
11154: from DUAL
11155: ) top_slice
11156: where
11157: prg.STRUCT_TYPE = 'PRG' and
11158: prg.SUP_LEVEL = l_level and

Line 11284: from DUAL union all

11280: (
11281: select 'Y' CB_FLAG,
11282: 'N' CO_FLAG,
11283: -3 PLAN_VERSION_ID
11284: from DUAL union all
11285: select 'N' CB_FLAG,
11286: 'Y' CO_FLAG,
11287: -4 PLAN_VERSION_ID
11288: from DUAL union all

Line 11288: from DUAL union all

11284: from DUAL union all
11285: select 'N' CB_FLAG,
11286: 'Y' CO_FLAG,
11287: -4 PLAN_VERSION_ID
11288: from DUAL union all
11289: select 'Y' CB_FLAG,
11290: 'Y' CO_FLAG,
11291: -3 PLAN_VERSION_ID
11292: from DUAL union all

Line 11292: from DUAL union all

11288: from DUAL union all
11289: select 'Y' CB_FLAG,
11290: 'Y' CO_FLAG,
11291: -3 PLAN_VERSION_ID
11292: from DUAL union all
11293: select 'Y' CB_FLAG,
11294: 'Y' CO_FLAG,
11295: -4 PLAN_VERSION_ID
11296: from DUAL

Line 11296: from DUAL

11292: from DUAL union all
11293: select 'Y' CB_FLAG,
11294: 'Y' CO_FLAG,
11295: -4 PLAN_VERSION_ID
11296: from DUAL
11297: ) fin_plan
11298: where
11299: prg.STRUCT_TYPE = 'PRG' and
11300: prg.SUP_LEVEL = l_level and

Line 11435: from DUAL union all

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
11435: from DUAL union all
11436: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11437: from DUAL union all
11438: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11439: from DUAL union all

Line 11437: from DUAL union all

11433: (
11434: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11435: from DUAL union all
11436: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11437: from DUAL union all
11438: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11439: from DUAL union all
11440: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11441: from DUAL union all

Line 11439: from DUAL union all

11435: from DUAL union all
11436: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11437: from DUAL union all
11438: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11439: from DUAL union all
11440: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11441: from DUAL union all
11442: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11443: from DUAL union all

Line 11441: from DUAL union all

11437: from DUAL union all
11438: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11439: from DUAL union all
11440: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11441: from DUAL union all
11442: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11443: from DUAL union all
11444: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11445: from DUAL union all

Line 11443: from DUAL union all

11439: from DUAL union all
11440: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11441: from DUAL union all
11442: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11443: from DUAL union all
11444: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11445: from DUAL union all
11446: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11447: from DUAL union all

Line 11445: from DUAL union all

11441: from DUAL union all
11442: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11443: from DUAL union all
11444: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11445: from DUAL union all
11446: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11447: from DUAL union all
11448: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11449: from DUAL

Line 11447: from DUAL union all

11443: from DUAL union all
11444: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11445: from DUAL union all
11446: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11447: from DUAL union all
11448: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11449: from DUAL
11450: ) fin_plan,
11451: (

Line 11449: from DUAL

11445: from DUAL union all
11446: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11447: from DUAL union all
11448: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11449: from DUAL
11450: ) fin_plan,
11451: (
11452: select 1 WBS_SUP_LEVEL,
11453: 1 WBS_SUB_LEVEL,

Line 11455: from DUAL

11451: (
11452: select 1 WBS_SUP_LEVEL,
11453: 1 WBS_SUB_LEVEL,
11454: 'PRJ' INVERT_ID
11455: from DUAL
11456: union all
11457: select 1 WBS_SUP_LEVEL,
11458: 1 WBS_SUB_LEVEL,
11459: 'WBS' INVERT_ID

Line 11460: from DUAL

11456: union all
11457: select 1 WBS_SUP_LEVEL,
11458: 1 WBS_SUB_LEVEL,
11459: 'WBS' INVERT_ID
11460: from DUAL
11461: ) top_slice
11462: where
11463: prg.STRUCT_TYPE = 'PRG' and
11464: prg.SUP_LEVEL = l_level and

Line 11521: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all

11517: from
11518: PJI_PJP_PROJ_BATCH_MAP map,
11519: PJI_XBS_DENORM prg,
11520: (
11521: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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,

Line 11522: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

11518: PJI_PJP_PROJ_BATCH_MAP map,
11519: PJI_XBS_DENORM prg,
11520: (
11521: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 11523: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

11519: PJI_XBS_DENORM prg,
11520: (
11521: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 11524: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual

11520: (
11521: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 12447: from DUAL union all

12443: PA_XBS_DENORM wbs,
12444: PJI_XBS_DENORM prg,
12445: (
12446: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12447: from DUAL union all
12448: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12449: from DUAL union all
12450: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12451: from DUAL union all

Line 12449: from DUAL union all

12445: (
12446: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12447: from DUAL union all
12448: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12449: from DUAL union all
12450: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12451: from DUAL union all
12452: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12453: from DUAL union all

Line 12451: from DUAL union all

12447: from DUAL union all
12448: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12449: from DUAL union all
12450: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12451: from DUAL union all
12452: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12453: from DUAL union all
12454: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12455: from DUAL union all

Line 12453: from DUAL union all

12449: from DUAL union all
12450: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12451: from DUAL union all
12452: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12453: from DUAL union all
12454: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12455: from DUAL union all
12456: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12457: from DUAL union all

Line 12455: from DUAL union all

12451: from DUAL union all
12452: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12453: from DUAL union all
12454: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12455: from DUAL union all
12456: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12457: from DUAL union all
12458: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12459: from DUAL union all

Line 12457: from DUAL union all

12453: from DUAL union all
12454: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12455: from DUAL union all
12456: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12457: from DUAL union all
12458: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12459: from DUAL union all
12460: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12461: from DUAL

Line 12459: from DUAL union all

12455: from DUAL union all
12456: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12457: from DUAL union all
12458: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12459: from DUAL union all
12460: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12461: from DUAL
12462: ) fin_plan,
12463: (

Line 12461: from DUAL

12457: from DUAL union all
12458: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12459: from DUAL union all
12460: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12461: from DUAL
12462: ) fin_plan,
12463: (
12464: select 1 WBS_SUP_LEVEL,
12465: 1 WBS_SUB_LEVEL,

Line 12467: from DUAL

12463: (
12464: select 1 WBS_SUP_LEVEL,
12465: 1 WBS_SUB_LEVEL,
12466: 'PRJ' INVERT_ID
12467: from DUAL
12468: union all
12469: select 1 WBS_SUP_LEVEL,
12470: 1 WBS_SUB_LEVEL,
12471: 'WBS' INVERT_ID

Line 12472: from DUAL

12468: union all
12469: select 1 WBS_SUP_LEVEL,
12470: 1 WBS_SUB_LEVEL,
12471: 'WBS' INVERT_ID
12472: from DUAL
12473: ) top_slice
12474: where
12475: prg.STRUCT_TYPE = 'PRG' and
12476: prg.SUP_LEVEL = l_level and

Line 12602: from DUAL union all

12598: (
12599: select 'Y' CB_FLAG,
12600: 'N' CO_FLAG,
12601: -3 PLAN_VERSION_ID
12602: from DUAL union all
12603: select 'N' CB_FLAG,
12604: 'Y' CO_FLAG,
12605: -4 PLAN_VERSION_ID
12606: from DUAL union all

Line 12606: from DUAL union all

12602: from DUAL union all
12603: select 'N' CB_FLAG,
12604: 'Y' CO_FLAG,
12605: -4 PLAN_VERSION_ID
12606: from DUAL union all
12607: select 'Y' CB_FLAG,
12608: 'Y' CO_FLAG,
12609: -3 PLAN_VERSION_ID
12610: from DUAL union all

Line 12610: from DUAL union all

12606: from DUAL union all
12607: select 'Y' CB_FLAG,
12608: 'Y' CO_FLAG,
12609: -3 PLAN_VERSION_ID
12610: from DUAL union all
12611: select 'Y' CB_FLAG,
12612: 'Y' CO_FLAG,
12613: -4 PLAN_VERSION_ID
12614: from DUAL

Line 12614: from DUAL

12610: from DUAL union all
12611: select 'Y' CB_FLAG,
12612: 'Y' CO_FLAG,
12613: -4 PLAN_VERSION_ID
12614: from DUAL
12615: ) fin_plan
12616: where
12617: prg.STRUCT_TYPE = 'PRG' and
12618: prg.SUP_LEVEL = l_level and

Line 12753: from DUAL union all

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
12753: from DUAL union all
12754: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12755: from DUAL union all
12756: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12757: from DUAL union all

Line 12755: from DUAL union all

12751: (
12752: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12753: from DUAL union all
12754: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12755: from DUAL union all
12756: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12757: from DUAL union all
12758: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12759: from DUAL union all

Line 12757: from DUAL union all

12753: from DUAL union all
12754: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12755: from DUAL union all
12756: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12757: from DUAL union all
12758: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12759: from DUAL union all
12760: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12761: from DUAL union all

Line 12759: from DUAL union all

12755: from DUAL union all
12756: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12757: from DUAL union all
12758: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12759: from DUAL union all
12760: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12761: from DUAL union all
12762: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12763: from DUAL union all

Line 12761: from DUAL union all

12757: from DUAL union all
12758: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12759: from DUAL union all
12760: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12761: from DUAL union all
12762: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12763: from DUAL union all
12764: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12765: from DUAL union all

Line 12763: from DUAL union all

12759: from DUAL union all
12760: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12761: from DUAL union all
12762: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12763: from DUAL union all
12764: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12765: from DUAL union all
12766: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12767: from DUAL

Line 12765: from DUAL union all

12761: from DUAL union all
12762: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12763: from DUAL union all
12764: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12765: from DUAL union all
12766: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12767: from DUAL
12768: ) fin_plan,
12769: (

Line 12767: from DUAL

12763: from DUAL union all
12764: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12765: from DUAL union all
12766: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12767: from DUAL
12768: ) fin_plan,
12769: (
12770: select 1 WBS_SUP_LEVEL,
12771: 1 WBS_SUB_LEVEL,

Line 12773: from DUAL

12769: (
12770: select 1 WBS_SUP_LEVEL,
12771: 1 WBS_SUB_LEVEL,
12772: 'PRJ' INVERT_ID
12773: from DUAL
12774: union all
12775: select 1 WBS_SUP_LEVEL,
12776: 1 WBS_SUB_LEVEL,
12777: 'WBS' INVERT_ID

Line 12778: from DUAL

12774: union all
12775: select 1 WBS_SUP_LEVEL,
12776: 1 WBS_SUB_LEVEL,
12777: 'WBS' INVERT_ID
12778: from DUAL
12779: ) top_slice
12780: where
12781: prg.STRUCT_TYPE = 'PRG' and
12782: prg.SUP_LEVEL = l_level and

Line 12839: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all

12835: from
12836: PJI_PJP_PROJ_BATCH_MAP map,
12837: PJI_XBS_DENORM prg,
12838: (
12839: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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,

Line 12840: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

12836: PJI_PJP_PROJ_BATCH_MAP map,
12837: PJI_XBS_DENORM prg,
12838: (
12839: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 12841: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

12837: PJI_XBS_DENORM prg,
12838: (
12839: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 12842: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual

12838: (
12839: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 13765: from DUAL union all

13761: PA_XBS_DENORM wbs,
13762: PJI_XBS_DENORM prg,
13763: (
13764: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13765: from DUAL union all
13766: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13767: from DUAL union all
13768: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13769: from DUAL union all

Line 13767: from DUAL union all

13763: (
13764: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13765: from DUAL union all
13766: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13767: from DUAL union all
13768: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13769: from DUAL union all
13770: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13771: from DUAL union all

Line 13769: from DUAL union all

13765: from DUAL union all
13766: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13767: from DUAL union all
13768: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13769: from DUAL union all
13770: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13771: from DUAL union all
13772: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13773: from DUAL union all

Line 13771: from DUAL union all

13767: from DUAL union all
13768: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13769: from DUAL union all
13770: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13771: from DUAL union all
13772: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13773: from DUAL union all
13774: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13775: from DUAL union all

Line 13773: from DUAL union all

13769: from DUAL union all
13770: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13771: from DUAL union all
13772: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13773: from DUAL union all
13774: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13775: from DUAL union all
13776: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13777: from DUAL union all

Line 13775: from DUAL union all

13771: from DUAL union all
13772: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13773: from DUAL union all
13774: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13775: from DUAL union all
13776: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13777: from DUAL union all
13778: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13779: from DUAL

Line 13777: from DUAL union all

13773: from DUAL union all
13774: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13775: from DUAL union all
13776: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13777: from DUAL union all
13778: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13779: from DUAL
13780: ) fin_plan,
13781: (

Line 13779: from DUAL

13775: from DUAL union all
13776: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13777: from DUAL union all
13778: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13779: from DUAL
13780: ) fin_plan,
13781: (
13782: select 1 WBS_SUP_LEVEL,
13783: 1 WBS_SUB_LEVEL,

Line 13785: from DUAL

13781: (
13782: select 1 WBS_SUP_LEVEL,
13783: 1 WBS_SUB_LEVEL,
13784: 'PRJ' INVERT_ID
13785: from DUAL
13786: union all
13787: select 1 WBS_SUP_LEVEL,
13788: 1 WBS_SUB_LEVEL,
13789: 'WBS' INVERT_ID

Line 13790: from DUAL

13786: union all
13787: select 1 WBS_SUP_LEVEL,
13788: 1 WBS_SUB_LEVEL,
13789: 'WBS' INVERT_ID
13790: from DUAL
13791: ) top_slice
13792: where
13793: prg.STRUCT_TYPE = 'PRG' and
13794: prg.SUP_LEVEL = l_level and

Line 13920: from DUAL union all

13916: (
13917: select 'Y' CB_FLAG,
13918: 'N' CO_FLAG,
13919: -3 PLAN_VERSION_ID
13920: from DUAL union all
13921: select 'N' CB_FLAG,
13922: 'Y' CO_FLAG,
13923: -4 PLAN_VERSION_ID
13924: from DUAL union all

Line 13924: from DUAL union all

13920: from DUAL union all
13921: select 'N' CB_FLAG,
13922: 'Y' CO_FLAG,
13923: -4 PLAN_VERSION_ID
13924: from DUAL union all
13925: select 'Y' CB_FLAG,
13926: 'Y' CO_FLAG,
13927: -3 PLAN_VERSION_ID
13928: from DUAL union all

Line 13928: from DUAL union all

13924: from DUAL union all
13925: select 'Y' CB_FLAG,
13926: 'Y' CO_FLAG,
13927: -3 PLAN_VERSION_ID
13928: from DUAL union all
13929: select 'Y' CB_FLAG,
13930: 'Y' CO_FLAG,
13931: -4 PLAN_VERSION_ID
13932: from DUAL

Line 13932: from DUAL

13928: from DUAL union all
13929: select 'Y' CB_FLAG,
13930: 'Y' CO_FLAG,
13931: -4 PLAN_VERSION_ID
13932: from DUAL
13933: ) fin_plan
13934: where
13935: prg.STRUCT_TYPE = 'PRG' and
13936: prg.SUP_LEVEL = l_level and

Line 14071: from DUAL union all

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
14071: from DUAL union all
14072: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14073: from DUAL union all
14074: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14075: from DUAL union all

Line 14073: from DUAL union all

14069: (
14070: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
14071: from DUAL union all
14072: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14073: from DUAL union all
14074: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14075: from DUAL union all
14076: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14077: from DUAL union all

Line 14075: from DUAL union all

14071: from DUAL union all
14072: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14073: from DUAL union all
14074: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14075: from DUAL union all
14076: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14077: from DUAL union all
14078: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
14079: from DUAL union all

Line 14077: from DUAL union all

14073: from DUAL union all
14074: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14075: from DUAL union all
14076: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14077: from DUAL union all
14078: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
14079: from DUAL union all
14080: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14081: from DUAL union all

Line 14079: from DUAL union all

14075: from DUAL union all
14076: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14077: from DUAL union all
14078: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
14079: from DUAL union all
14080: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14081: from DUAL union all
14082: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14083: from DUAL union all

Line 14081: from DUAL union all

14077: from DUAL union all
14078: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
14079: from DUAL union all
14080: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14081: from DUAL union all
14082: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14083: from DUAL union all
14084: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14085: from DUAL

Line 14083: from DUAL union all

14079: from DUAL union all
14080: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14081: from DUAL union all
14082: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14083: from DUAL union all
14084: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14085: from DUAL
14086: ) fin_plan,
14087: (

Line 14085: from DUAL

14081: from DUAL union all
14082: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14083: from DUAL union all
14084: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14085: from DUAL
14086: ) fin_plan,
14087: (
14088: select 1 WBS_SUP_LEVEL,
14089: 1 WBS_SUB_LEVEL,

Line 14091: from DUAL

14087: (
14088: select 1 WBS_SUP_LEVEL,
14089: 1 WBS_SUB_LEVEL,
14090: 'PRJ' INVERT_ID
14091: from DUAL
14092: union all
14093: select 1 WBS_SUP_LEVEL,
14094: 1 WBS_SUB_LEVEL,
14095: 'WBS' INVERT_ID

Line 14096: from DUAL

14092: union all
14093: select 1 WBS_SUP_LEVEL,
14094: 1 WBS_SUB_LEVEL,
14095: 'WBS' INVERT_ID
14096: from DUAL
14097: ) top_slice
14098: where
14099: prg.STRUCT_TYPE = 'PRG' and
14100: prg.SUP_LEVEL = l_level and

Line 14157: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all

14153: from
14154: PJI_PJP_PROJ_BATCH_MAP map,
14155: PJI_XBS_DENORM prg,
14156: (
14157: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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,

Line 14158: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

14154: PJI_PJP_PROJ_BATCH_MAP map,
14155: PJI_XBS_DENORM prg,
14156: (
14157: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 14159: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

14155: PJI_XBS_DENORM prg,
14156: (
14157: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 14160: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual

14156: (
14157: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 15083: from DUAL union all

15079: PA_XBS_DENORM wbs,
15080: PJI_XBS_DENORM prg,
15081: (
15082: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15083: from DUAL union all
15084: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15085: from DUAL union all
15086: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15087: from DUAL union all

Line 15085: from DUAL union all

15081: (
15082: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15083: from DUAL union all
15084: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15085: from DUAL union all
15086: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15087: from DUAL union all
15088: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15089: from DUAL union all

Line 15087: from DUAL union all

15083: from DUAL union all
15084: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15085: from DUAL union all
15086: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15087: from DUAL union all
15088: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15089: from DUAL union all
15090: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15091: from DUAL union all

Line 15089: from DUAL union all

15085: from DUAL union all
15086: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15087: from DUAL union all
15088: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15089: from DUAL union all
15090: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15091: from DUAL union all
15092: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15093: from DUAL union all

Line 15091: from DUAL union all

15087: from DUAL union all
15088: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15089: from DUAL union all
15090: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15091: from DUAL union all
15092: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15093: from DUAL union all
15094: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15095: from DUAL union all

Line 15093: from DUAL union all

15089: from DUAL union all
15090: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15091: from DUAL union all
15092: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15093: from DUAL union all
15094: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15095: from DUAL union all
15096: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15097: from DUAL

Line 15095: from DUAL union all

15091: from DUAL union all
15092: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15093: from DUAL union all
15094: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15095: from DUAL union all
15096: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15097: from DUAL
15098: ) fin_plan,
15099: (

Line 15097: from DUAL

15093: from DUAL union all
15094: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15095: from DUAL union all
15096: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15097: from DUAL
15098: ) fin_plan,
15099: (
15100: select 1 WBS_SUP_LEVEL,
15101: 1 WBS_SUB_LEVEL,

Line 15103: from DUAL

15099: (
15100: select 1 WBS_SUP_LEVEL,
15101: 1 WBS_SUB_LEVEL,
15102: 'PRJ' INVERT_ID
15103: from DUAL
15104: union all
15105: select 1 WBS_SUP_LEVEL,
15106: 1 WBS_SUB_LEVEL,
15107: 'WBS' INVERT_ID

Line 15108: from DUAL

15104: union all
15105: select 1 WBS_SUP_LEVEL,
15106: 1 WBS_SUB_LEVEL,
15107: 'WBS' INVERT_ID
15108: from DUAL
15109: ) top_slice
15110: where
15111: prg.STRUCT_TYPE = 'PRG' and
15112: prg.SUP_LEVEL = l_level and

Line 15238: from DUAL union all

15234: (
15235: select 'Y' CB_FLAG,
15236: 'N' CO_FLAG,
15237: -3 PLAN_VERSION_ID
15238: from DUAL union all
15239: select 'N' CB_FLAG,
15240: 'Y' CO_FLAG,
15241: -4 PLAN_VERSION_ID
15242: from DUAL union all

Line 15242: from DUAL union all

15238: from DUAL union all
15239: select 'N' CB_FLAG,
15240: 'Y' CO_FLAG,
15241: -4 PLAN_VERSION_ID
15242: from DUAL union all
15243: select 'Y' CB_FLAG,
15244: 'Y' CO_FLAG,
15245: -3 PLAN_VERSION_ID
15246: from DUAL union all

Line 15246: from DUAL union all

15242: from DUAL union all
15243: select 'Y' CB_FLAG,
15244: 'Y' CO_FLAG,
15245: -3 PLAN_VERSION_ID
15246: from DUAL union all
15247: select 'Y' CB_FLAG,
15248: 'Y' CO_FLAG,
15249: -4 PLAN_VERSION_ID
15250: from DUAL

Line 15250: from DUAL

15246: from DUAL union all
15247: select 'Y' CB_FLAG,
15248: 'Y' CO_FLAG,
15249: -4 PLAN_VERSION_ID
15250: from DUAL
15251: ) fin_plan
15252: where
15253: prg.STRUCT_TYPE = 'PRG' and
15254: prg.SUP_LEVEL = l_level and

Line 15389: from DUAL union all

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
15389: from DUAL union all
15390: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15391: from DUAL union all
15392: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15393: from DUAL union all

Line 15391: from DUAL union all

15387: (
15388: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15389: from DUAL union all
15390: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15391: from DUAL union all
15392: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15393: from DUAL union all
15394: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15395: from DUAL union all

Line 15393: from DUAL union all

15389: from DUAL union all
15390: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15391: from DUAL union all
15392: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15393: from DUAL union all
15394: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15395: from DUAL union all
15396: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15397: from DUAL union all

Line 15395: from DUAL union all

15391: from DUAL union all
15392: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15393: from DUAL union all
15394: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15395: from DUAL union all
15396: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15397: from DUAL union all
15398: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15399: from DUAL union all

Line 15397: from DUAL union all

15393: from DUAL union all
15394: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15395: from DUAL union all
15396: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15397: from DUAL union all
15398: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15399: from DUAL union all
15400: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15401: from DUAL union all

Line 15399: from DUAL union all

15395: from DUAL union all
15396: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15397: from DUAL union all
15398: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15399: from DUAL union all
15400: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15401: from DUAL union all
15402: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15403: from DUAL

Line 15401: from DUAL union all

15397: from DUAL union all
15398: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15399: from DUAL union all
15400: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15401: from DUAL union all
15402: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15403: from DUAL
15404: ) fin_plan,
15405: (

Line 15403: from DUAL

15399: from DUAL union all
15400: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15401: from DUAL union all
15402: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15403: from DUAL
15404: ) fin_plan,
15405: (
15406: select 1 WBS_SUP_LEVEL,
15407: 1 WBS_SUB_LEVEL,

Line 15409: from DUAL

15405: (
15406: select 1 WBS_SUP_LEVEL,
15407: 1 WBS_SUB_LEVEL,
15408: 'PRJ' INVERT_ID
15409: from DUAL
15410: union all
15411: select 1 WBS_SUP_LEVEL,
15412: 1 WBS_SUB_LEVEL,
15413: 'WBS' INVERT_ID

Line 15414: from DUAL

15410: union all
15411: select 1 WBS_SUP_LEVEL,
15412: 1 WBS_SUB_LEVEL,
15413: 'WBS' INVERT_ID
15414: from DUAL
15415: ) top_slice
15416: where
15417: prg.STRUCT_TYPE = 'PRG' and
15418: prg.SUP_LEVEL = l_level and

Line 15475: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all

15471: from
15472: PJI_PJP_PROJ_BATCH_MAP map,
15473: PJI_XBS_DENORM prg,
15474: (
15475: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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,

Line 15476: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

15472: PJI_PJP_PROJ_BATCH_MAP map,
15473: PJI_XBS_DENORM prg,
15474: (
15475: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 15477: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

15473: PJI_XBS_DENORM prg,
15474: (
15475: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 15478: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual

15474: (
15475: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 16401: from DUAL union all

16397: PA_XBS_DENORM wbs,
16398: PJI_XBS_DENORM prg,
16399: (
16400: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16401: from DUAL union all
16402: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16403: from DUAL union all
16404: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16405: from DUAL union all

Line 16403: from DUAL union all

16399: (
16400: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16401: from DUAL union all
16402: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16403: from DUAL union all
16404: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16405: from DUAL union all
16406: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16407: from DUAL union all

Line 16405: from DUAL union all

16401: from DUAL union all
16402: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16403: from DUAL union all
16404: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16405: from DUAL union all
16406: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16407: from DUAL union all
16408: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16409: from DUAL union all

Line 16407: from DUAL union all

16403: from DUAL union all
16404: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16405: from DUAL union all
16406: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16407: from DUAL union all
16408: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16409: from DUAL union all
16410: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16411: from DUAL union all

Line 16409: from DUAL union all

16405: from DUAL union all
16406: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16407: from DUAL union all
16408: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16409: from DUAL union all
16410: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16411: from DUAL union all
16412: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16413: from DUAL union all

Line 16411: from DUAL union all

16407: from DUAL union all
16408: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16409: from DUAL union all
16410: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16411: from DUAL union all
16412: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16413: from DUAL union all
16414: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16415: from DUAL

Line 16413: from DUAL union all

16409: from DUAL union all
16410: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16411: from DUAL union all
16412: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16413: from DUAL union all
16414: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16415: from DUAL
16416: ) fin_plan,
16417: (

Line 16415: from DUAL

16411: from DUAL union all
16412: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16413: from DUAL union all
16414: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16415: from DUAL
16416: ) fin_plan,
16417: (
16418: select 1 WBS_SUP_LEVEL,
16419: 1 WBS_SUB_LEVEL,

Line 16421: from DUAL

16417: (
16418: select 1 WBS_SUP_LEVEL,
16419: 1 WBS_SUB_LEVEL,
16420: 'PRJ' INVERT_ID
16421: from DUAL
16422: union all
16423: select 1 WBS_SUP_LEVEL,
16424: 1 WBS_SUB_LEVEL,
16425: 'WBS' INVERT_ID

Line 16426: from DUAL

16422: union all
16423: select 1 WBS_SUP_LEVEL,
16424: 1 WBS_SUB_LEVEL,
16425: 'WBS' INVERT_ID
16426: from DUAL
16427: ) top_slice
16428: where
16429: prg.STRUCT_TYPE = 'PRG' and
16430: prg.SUP_LEVEL = l_level and

Line 16556: from DUAL union all

16552: (
16553: select 'Y' CB_FLAG,
16554: 'N' CO_FLAG,
16555: -3 PLAN_VERSION_ID
16556: from DUAL union all
16557: select 'N' CB_FLAG,
16558: 'Y' CO_FLAG,
16559: -4 PLAN_VERSION_ID
16560: from DUAL union all

Line 16560: from DUAL union all

16556: from DUAL union all
16557: select 'N' CB_FLAG,
16558: 'Y' CO_FLAG,
16559: -4 PLAN_VERSION_ID
16560: from DUAL union all
16561: select 'Y' CB_FLAG,
16562: 'Y' CO_FLAG,
16563: -3 PLAN_VERSION_ID
16564: from DUAL union all

Line 16564: from DUAL union all

16560: from DUAL union all
16561: select 'Y' CB_FLAG,
16562: 'Y' CO_FLAG,
16563: -3 PLAN_VERSION_ID
16564: from DUAL union all
16565: select 'Y' CB_FLAG,
16566: 'Y' CO_FLAG,
16567: -4 PLAN_VERSION_ID
16568: from DUAL

Line 16568: from DUAL

16564: from DUAL union all
16565: select 'Y' CB_FLAG,
16566: 'Y' CO_FLAG,
16567: -4 PLAN_VERSION_ID
16568: from DUAL
16569: ) fin_plan
16570: where
16571: prg.STRUCT_TYPE = 'PRG' and
16572: prg.SUP_LEVEL = l_level and

Line 16707: from DUAL union all

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
16707: from DUAL union all
16708: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16709: from DUAL union all
16710: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16711: from DUAL union all

Line 16709: from DUAL union all

16705: (
16706: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16707: from DUAL union all
16708: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16709: from DUAL union all
16710: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16711: from DUAL union all
16712: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16713: from DUAL union all

Line 16711: from DUAL union all

16707: from DUAL union all
16708: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16709: from DUAL union all
16710: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16711: from DUAL union all
16712: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16713: from DUAL union all
16714: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16715: from DUAL union all

Line 16713: from DUAL union all

16709: from DUAL union all
16710: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16711: from DUAL union all
16712: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16713: from DUAL union all
16714: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16715: from DUAL union all
16716: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16717: from DUAL union all

Line 16715: from DUAL union all

16711: from DUAL union all
16712: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16713: from DUAL union all
16714: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16715: from DUAL union all
16716: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16717: from DUAL union all
16718: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16719: from DUAL union all

Line 16717: from DUAL union all

16713: from DUAL union all
16714: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16715: from DUAL union all
16716: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16717: from DUAL union all
16718: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16719: from DUAL union all
16720: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16721: from DUAL

Line 16719: from DUAL union all

16715: from DUAL union all
16716: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16717: from DUAL union all
16718: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16719: from DUAL union all
16720: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16721: from DUAL
16722: ) fin_plan,
16723: (

Line 16721: from DUAL

16717: from DUAL union all
16718: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16719: from DUAL union all
16720: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16721: from DUAL
16722: ) fin_plan,
16723: (
16724: select 1 WBS_SUP_LEVEL,
16725: 1 WBS_SUB_LEVEL,

Line 16727: from DUAL

16723: (
16724: select 1 WBS_SUP_LEVEL,
16725: 1 WBS_SUB_LEVEL,
16726: 'PRJ' INVERT_ID
16727: from DUAL
16728: union all
16729: select 1 WBS_SUP_LEVEL,
16730: 1 WBS_SUB_LEVEL,
16731: 'WBS' INVERT_ID

Line 16732: from DUAL

16728: union all
16729: select 1 WBS_SUP_LEVEL,
16730: 1 WBS_SUB_LEVEL,
16731: 'WBS' INVERT_ID
16732: from DUAL
16733: ) top_slice
16734: where
16735: prg.STRUCT_TYPE = 'PRG' and
16736: prg.SUP_LEVEL = l_level and

Line 16793: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all

16789: from
16790: PJI_PJP_PROJ_BATCH_MAP map,
16791: PJI_XBS_DENORM prg,
16792: (
16793: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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,

Line 16794: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

16790: PJI_PJP_PROJ_BATCH_MAP map,
16791: PJI_XBS_DENORM prg,
16792: (
16793: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 16795: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

16791: PJI_XBS_DENORM prg,
16792: (
16793: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 16796: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual

16792: (
16793: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 17719: from DUAL union all

17715: PA_XBS_DENORM wbs,
17716: PJI_XBS_DENORM prg,
17717: (
17718: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
17719: from DUAL union all
17720: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
17721: from DUAL union all
17722: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
17723: from DUAL union all

Line 17721: from DUAL union all

17717: (
17718: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
17719: from DUAL union all
17720: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
17721: from DUAL union all
17722: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
17723: from DUAL union all
17724: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
17725: from DUAL union all

Line 17723: from DUAL union all

17719: from DUAL union all
17720: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
17721: from DUAL union all
17722: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
17723: from DUAL union all
17724: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
17725: from DUAL union all
17726: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
17727: from DUAL union all

Line 17725: from DUAL union all

17721: from DUAL union all
17722: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
17723: from DUAL union all
17724: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
17725: from DUAL union all
17726: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
17727: from DUAL union all
17728: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
17729: from DUAL union all

Line 17727: from DUAL union all

17723: from DUAL union all
17724: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
17725: from DUAL union all
17726: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
17727: from DUAL union all
17728: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
17729: from DUAL union all
17730: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
17731: from DUAL union all

Line 17729: from DUAL union all

17725: from DUAL union all
17726: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
17727: from DUAL union all
17728: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
17729: from DUAL union all
17730: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
17731: from DUAL union all
17732: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
17733: from DUAL

Line 17731: from DUAL union all

17727: from DUAL union all
17728: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
17729: from DUAL union all
17730: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
17731: from DUAL union all
17732: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
17733: from DUAL
17734: ) fin_plan,
17735: (

Line 17733: from DUAL

17729: from DUAL union all
17730: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
17731: from DUAL union all
17732: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
17733: from DUAL
17734: ) fin_plan,
17735: (
17736: select 1 WBS_SUP_LEVEL,
17737: 1 WBS_SUB_LEVEL,

Line 17739: from DUAL

17735: (
17736: select 1 WBS_SUP_LEVEL,
17737: 1 WBS_SUB_LEVEL,
17738: 'PRJ' INVERT_ID
17739: from DUAL
17740: union all
17741: select 1 WBS_SUP_LEVEL,
17742: 1 WBS_SUB_LEVEL,
17743: 'WBS' INVERT_ID

Line 17744: from DUAL

17740: union all
17741: select 1 WBS_SUP_LEVEL,
17742: 1 WBS_SUB_LEVEL,
17743: 'WBS' INVERT_ID
17744: from DUAL
17745: ) top_slice
17746: where
17747: prg.STRUCT_TYPE = 'PRG' and
17748: prg.SUP_LEVEL = l_level and

Line 17874: from DUAL union all

17870: (
17871: select 'Y' CB_FLAG,
17872: 'N' CO_FLAG,
17873: -3 PLAN_VERSION_ID
17874: from DUAL union all
17875: select 'N' CB_FLAG,
17876: 'Y' CO_FLAG,
17877: -4 PLAN_VERSION_ID
17878: from DUAL union all

Line 17878: from DUAL union all

17874: from DUAL union all
17875: select 'N' CB_FLAG,
17876: 'Y' CO_FLAG,
17877: -4 PLAN_VERSION_ID
17878: from DUAL union all
17879: select 'Y' CB_FLAG,
17880: 'Y' CO_FLAG,
17881: -3 PLAN_VERSION_ID
17882: from DUAL union all

Line 17882: from DUAL union all

17878: from DUAL union all
17879: select 'Y' CB_FLAG,
17880: 'Y' CO_FLAG,
17881: -3 PLAN_VERSION_ID
17882: from DUAL union all
17883: select 'Y' CB_FLAG,
17884: 'Y' CO_FLAG,
17885: -4 PLAN_VERSION_ID
17886: from DUAL

Line 17886: from DUAL

17882: from DUAL union all
17883: select 'Y' CB_FLAG,
17884: 'Y' CO_FLAG,
17885: -4 PLAN_VERSION_ID
17886: from DUAL
17887: ) fin_plan
17888: where
17889: prg.STRUCT_TYPE = 'PRG' and
17890: prg.SUP_LEVEL = l_level and

Line 18025: from DUAL union all

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
18025: from DUAL union all
18026: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18027: from DUAL union all
18028: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18029: from DUAL union all

Line 18027: from DUAL union all

18023: (
18024: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18025: from DUAL union all
18026: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18027: from DUAL union all
18028: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18029: from DUAL union all
18030: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18031: from DUAL union all

Line 18029: from DUAL union all

18025: from DUAL union all
18026: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18027: from DUAL union all
18028: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18029: from DUAL union all
18030: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18031: from DUAL union all
18032: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18033: from DUAL union all

Line 18031: from DUAL union all

18027: from DUAL union all
18028: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18029: from DUAL union all
18030: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18031: from DUAL union all
18032: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18033: from DUAL union all
18034: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18035: from DUAL union all

Line 18033: from DUAL union all

18029: from DUAL union all
18030: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18031: from DUAL union all
18032: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18033: from DUAL union all
18034: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18035: from DUAL union all
18036: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18037: from DUAL union all

Line 18035: from DUAL union all

18031: from DUAL union all
18032: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18033: from DUAL union all
18034: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18035: from DUAL union all
18036: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18037: from DUAL union all
18038: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18039: from DUAL

Line 18037: from DUAL union all

18033: from DUAL union all
18034: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18035: from DUAL union all
18036: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18037: from DUAL union all
18038: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18039: from DUAL
18040: ) fin_plan,
18041: (

Line 18039: from DUAL

18035: from DUAL union all
18036: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18037: from DUAL union all
18038: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18039: from DUAL
18040: ) fin_plan,
18041: (
18042: select 1 WBS_SUP_LEVEL,
18043: 1 WBS_SUB_LEVEL,

Line 18045: from DUAL

18041: (
18042: select 1 WBS_SUP_LEVEL,
18043: 1 WBS_SUB_LEVEL,
18044: 'PRJ' INVERT_ID
18045: from DUAL
18046: union all
18047: select 1 WBS_SUP_LEVEL,
18048: 1 WBS_SUB_LEVEL,
18049: 'WBS' INVERT_ID

Line 18050: from DUAL

18046: union all
18047: select 1 WBS_SUP_LEVEL,
18048: 1 WBS_SUB_LEVEL,
18049: 'WBS' INVERT_ID
18050: from DUAL
18051: ) top_slice
18052: where
18053: prg.STRUCT_TYPE = 'PRG' and
18054: prg.SUP_LEVEL = l_level and

Line 18111: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all

18107: from
18108: PJI_PJP_PROJ_BATCH_MAP map,
18109: PJI_XBS_DENORM prg,
18110: (
18111: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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,

Line 18112: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

18108: PJI_PJP_PROJ_BATCH_MAP map,
18109: PJI_XBS_DENORM prg,
18110: (
18111: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 18113: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

18109: PJI_XBS_DENORM prg,
18110: (
18111: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 18114: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual

18110: (
18111: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 19037: from DUAL union all

19033: PA_XBS_DENORM wbs,
19034: PJI_XBS_DENORM prg,
19035: (
19036: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19037: from DUAL union all
19038: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19039: from DUAL union all
19040: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19041: from DUAL union all

Line 19039: from DUAL union all

19035: (
19036: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19037: from DUAL union all
19038: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19039: from DUAL union all
19040: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19041: from DUAL union all
19042: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19043: from DUAL union all

Line 19041: from DUAL union all

19037: from DUAL union all
19038: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19039: from DUAL union all
19040: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19041: from DUAL union all
19042: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19043: from DUAL union all
19044: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19045: from DUAL union all

Line 19043: from DUAL union all

19039: from DUAL union all
19040: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19041: from DUAL union all
19042: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19043: from DUAL union all
19044: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19045: from DUAL union all
19046: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19047: from DUAL union all

Line 19045: from DUAL union all

19041: from DUAL union all
19042: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19043: from DUAL union all
19044: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19045: from DUAL union all
19046: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19047: from DUAL union all
19048: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19049: from DUAL union all

Line 19047: from DUAL union all

19043: from DUAL union all
19044: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19045: from DUAL union all
19046: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19047: from DUAL union all
19048: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19049: from DUAL union all
19050: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19051: from DUAL

Line 19049: from DUAL union all

19045: from DUAL union all
19046: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19047: from DUAL union all
19048: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19049: from DUAL union all
19050: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19051: from DUAL
19052: ) fin_plan,
19053: (

Line 19051: from DUAL

19047: from DUAL union all
19048: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19049: from DUAL union all
19050: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19051: from DUAL
19052: ) fin_plan,
19053: (
19054: select 1 WBS_SUP_LEVEL,
19055: 1 WBS_SUB_LEVEL,

Line 19057: from DUAL

19053: (
19054: select 1 WBS_SUP_LEVEL,
19055: 1 WBS_SUB_LEVEL,
19056: 'PRJ' INVERT_ID
19057: from DUAL
19058: union all
19059: select 1 WBS_SUP_LEVEL,
19060: 1 WBS_SUB_LEVEL,
19061: 'WBS' INVERT_ID

Line 19062: from DUAL

19058: union all
19059: select 1 WBS_SUP_LEVEL,
19060: 1 WBS_SUB_LEVEL,
19061: 'WBS' INVERT_ID
19062: from DUAL
19063: ) top_slice
19064: where
19065: prg.STRUCT_TYPE = 'PRG' and
19066: prg.SUP_LEVEL = l_level and

Line 19192: from DUAL union all

19188: (
19189: select 'Y' CB_FLAG,
19190: 'N' CO_FLAG,
19191: -3 PLAN_VERSION_ID
19192: from DUAL union all
19193: select 'N' CB_FLAG,
19194: 'Y' CO_FLAG,
19195: -4 PLAN_VERSION_ID
19196: from DUAL union all

Line 19196: from DUAL union all

19192: from DUAL union all
19193: select 'N' CB_FLAG,
19194: 'Y' CO_FLAG,
19195: -4 PLAN_VERSION_ID
19196: from DUAL union all
19197: select 'Y' CB_FLAG,
19198: 'Y' CO_FLAG,
19199: -3 PLAN_VERSION_ID
19200: from DUAL union all

Line 19200: from DUAL union all

19196: from DUAL union all
19197: select 'Y' CB_FLAG,
19198: 'Y' CO_FLAG,
19199: -3 PLAN_VERSION_ID
19200: from DUAL union all
19201: select 'Y' CB_FLAG,
19202: 'Y' CO_FLAG,
19203: -4 PLAN_VERSION_ID
19204: from DUAL

Line 19204: from DUAL

19200: from DUAL union all
19201: select 'Y' CB_FLAG,
19202: 'Y' CO_FLAG,
19203: -4 PLAN_VERSION_ID
19204: from DUAL
19205: ) fin_plan
19206: where
19207: prg.STRUCT_TYPE = 'PRG' and
19208: prg.SUP_LEVEL = l_level and

Line 19343: from DUAL union all

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
19343: from DUAL union all
19344: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19345: from DUAL union all
19346: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19347: from DUAL union all

Line 19345: from DUAL union all

19341: (
19342: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19343: from DUAL union all
19344: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19345: from DUAL union all
19346: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19347: from DUAL union all
19348: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19349: from DUAL union all

Line 19347: from DUAL union all

19343: from DUAL union all
19344: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19345: from DUAL union all
19346: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19347: from DUAL union all
19348: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19349: from DUAL union all
19350: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19351: from DUAL union all

Line 19349: from DUAL union all

19345: from DUAL union all
19346: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19347: from DUAL union all
19348: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19349: from DUAL union all
19350: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19351: from DUAL union all
19352: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19353: from DUAL union all

Line 19351: from DUAL union all

19347: from DUAL union all
19348: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19349: from DUAL union all
19350: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19351: from DUAL union all
19352: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19353: from DUAL union all
19354: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19355: from DUAL union all

Line 19353: from DUAL union all

19349: from DUAL union all
19350: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19351: from DUAL union all
19352: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19353: from DUAL union all
19354: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19355: from DUAL union all
19356: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19357: from DUAL

Line 19355: from DUAL union all

19351: from DUAL union all
19352: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19353: from DUAL union all
19354: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19355: from DUAL union all
19356: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19357: from DUAL
19358: ) fin_plan,
19359: (

Line 19357: from DUAL

19353: from DUAL union all
19354: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19355: from DUAL union all
19356: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19357: from DUAL
19358: ) fin_plan,
19359: (
19360: select 1 WBS_SUP_LEVEL,
19361: 1 WBS_SUB_LEVEL,

Line 19363: from DUAL

19359: (
19360: select 1 WBS_SUP_LEVEL,
19361: 1 WBS_SUB_LEVEL,
19362: 'PRJ' INVERT_ID
19363: from DUAL
19364: union all
19365: select 1 WBS_SUP_LEVEL,
19366: 1 WBS_SUB_LEVEL,
19367: 'WBS' INVERT_ID

Line 19368: from DUAL

19364: union all
19365: select 1 WBS_SUP_LEVEL,
19366: 1 WBS_SUB_LEVEL,
19367: 'WBS' INVERT_ID
19368: from DUAL
19369: ) top_slice
19370: where
19371: prg.STRUCT_TYPE = 'PRG' and
19372: prg.SUP_LEVEL = l_level and

Line 19429: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all

19425: from
19426: PJI_PJP_PROJ_BATCH_MAP map,
19427: PJI_XBS_DENORM prg,
19428: (
19429: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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,

Line 19430: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

19426: PJI_PJP_PROJ_BATCH_MAP map,
19427: PJI_XBS_DENORM prg,
19428: (
19429: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 19431: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

19427: PJI_XBS_DENORM prg,
19428: (
19429: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 19432: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual

19428: (
19429: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 20355: from DUAL union all

20351: PA_XBS_DENORM wbs,
20352: PJI_XBS_DENORM prg,
20353: (
20354: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
20355: from DUAL union all
20356: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20357: from DUAL union all
20358: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
20359: from DUAL union all

Line 20357: from DUAL union all

20353: (
20354: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
20355: from DUAL union all
20356: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20357: from DUAL union all
20358: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
20359: from DUAL union all
20360: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20361: from DUAL union all

Line 20359: from DUAL union all

20355: from DUAL union all
20356: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20357: from DUAL union all
20358: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
20359: from DUAL union all
20360: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20361: from DUAL union all
20362: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
20363: from DUAL union all

Line 20361: from DUAL union all

20357: from DUAL union all
20358: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
20359: from DUAL union all
20360: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20361: from DUAL union all
20362: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
20363: from DUAL union all
20364: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20365: from DUAL union all

Line 20363: from DUAL union all

20359: from DUAL union all
20360: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20361: from DUAL union all
20362: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
20363: from DUAL union all
20364: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20365: from DUAL union all
20366: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
20367: from DUAL union all

Line 20365: from DUAL union all

20361: from DUAL union all
20362: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
20363: from DUAL union all
20364: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20365: from DUAL union all
20366: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
20367: from DUAL union all
20368: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20369: from DUAL

Line 20367: from DUAL union all

20363: from DUAL union all
20364: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20365: from DUAL union all
20366: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
20367: from DUAL union all
20368: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20369: from DUAL
20370: ) fin_plan,
20371: (

Line 20369: from DUAL

20365: from DUAL union all
20366: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
20367: from DUAL union all
20368: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20369: from DUAL
20370: ) fin_plan,
20371: (
20372: select 1 WBS_SUP_LEVEL,
20373: 1 WBS_SUB_LEVEL,

Line 20375: from DUAL

20371: (
20372: select 1 WBS_SUP_LEVEL,
20373: 1 WBS_SUB_LEVEL,
20374: 'PRJ' INVERT_ID
20375: from DUAL
20376: union all
20377: select 1 WBS_SUP_LEVEL,
20378: 1 WBS_SUB_LEVEL,
20379: 'WBS' INVERT_ID

Line 20380: from DUAL

20376: union all
20377: select 1 WBS_SUP_LEVEL,
20378: 1 WBS_SUB_LEVEL,
20379: 'WBS' INVERT_ID
20380: from DUAL
20381: ) top_slice
20382: where
20383: prg.STRUCT_TYPE = 'PRG' and
20384: prg.SUP_LEVEL = l_level and

Line 20510: from DUAL union all

20506: (
20507: select 'Y' CB_FLAG,
20508: 'N' CO_FLAG,
20509: -3 PLAN_VERSION_ID
20510: from DUAL union all
20511: select 'N' CB_FLAG,
20512: 'Y' CO_FLAG,
20513: -4 PLAN_VERSION_ID
20514: from DUAL union all

Line 20514: from DUAL union all

20510: from DUAL union all
20511: select 'N' CB_FLAG,
20512: 'Y' CO_FLAG,
20513: -4 PLAN_VERSION_ID
20514: from DUAL union all
20515: select 'Y' CB_FLAG,
20516: 'Y' CO_FLAG,
20517: -3 PLAN_VERSION_ID
20518: from DUAL union all

Line 20518: from DUAL union all

20514: from DUAL union all
20515: select 'Y' CB_FLAG,
20516: 'Y' CO_FLAG,
20517: -3 PLAN_VERSION_ID
20518: from DUAL union all
20519: select 'Y' CB_FLAG,
20520: 'Y' CO_FLAG,
20521: -4 PLAN_VERSION_ID
20522: from DUAL

Line 20522: from DUAL

20518: from DUAL union all
20519: select 'Y' CB_FLAG,
20520: 'Y' CO_FLAG,
20521: -4 PLAN_VERSION_ID
20522: from DUAL
20523: ) fin_plan
20524: where
20525: prg.STRUCT_TYPE = 'PRG' and
20526: prg.SUP_LEVEL = l_level and

Line 20661: from DUAL union all

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
20661: from DUAL union all
20662: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20663: from DUAL union all
20664: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
20665: from DUAL union all

Line 20663: from DUAL union all

20659: (
20660: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
20661: from DUAL union all
20662: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20663: from DUAL union all
20664: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
20665: from DUAL union all
20666: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20667: from DUAL union all

Line 20665: from DUAL union all

20661: from DUAL union all
20662: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20663: from DUAL union all
20664: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
20665: from DUAL union all
20666: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20667: from DUAL union all
20668: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
20669: from DUAL union all

Line 20667: from DUAL union all

20663: from DUAL union all
20664: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
20665: from DUAL union all
20666: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20667: from DUAL union all
20668: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
20669: from DUAL union all
20670: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20671: from DUAL union all

Line 20669: from DUAL union all

20665: from DUAL union all
20666: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20667: from DUAL union all
20668: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
20669: from DUAL union all
20670: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20671: from DUAL union all
20672: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
20673: from DUAL union all

Line 20671: from DUAL union all

20667: from DUAL union all
20668: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
20669: from DUAL union all
20670: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20671: from DUAL union all
20672: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
20673: from DUAL union all
20674: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20675: from DUAL

Line 20673: from DUAL union all

20669: from DUAL union all
20670: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20671: from DUAL union all
20672: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
20673: from DUAL union all
20674: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20675: from DUAL
20676: ) fin_plan,
20677: (

Line 20675: from DUAL

20671: from DUAL union all
20672: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
20673: from DUAL union all
20674: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
20675: from DUAL
20676: ) fin_plan,
20677: (
20678: select 1 WBS_SUP_LEVEL,
20679: 1 WBS_SUB_LEVEL,

Line 20681: from DUAL

20677: (
20678: select 1 WBS_SUP_LEVEL,
20679: 1 WBS_SUB_LEVEL,
20680: 'PRJ' INVERT_ID
20681: from DUAL
20682: union all
20683: select 1 WBS_SUP_LEVEL,
20684: 1 WBS_SUB_LEVEL,
20685: 'WBS' INVERT_ID

Line 20686: from DUAL

20682: union all
20683: select 1 WBS_SUP_LEVEL,
20684: 1 WBS_SUB_LEVEL,
20685: 'WBS' INVERT_ID
20686: from DUAL
20687: ) top_slice
20688: where
20689: prg.STRUCT_TYPE = 'PRG' and
20690: prg.SUP_LEVEL = l_level and

Line 20747: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all

20743: from
20744: PJI_PJP_PROJ_BATCH_MAP map,
20745: PJI_XBS_DENORM prg,
20746: (
20747: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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,

Line 20748: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

20744: PJI_PJP_PROJ_BATCH_MAP map,
20745: PJI_XBS_DENORM prg,
20746: (
20747: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 20749: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

20745: PJI_XBS_DENORM prg,
20746: (
20747: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 20750: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual

20746: (
20747: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 21178: from DUAL

21174: (
21175: select 1 WBS_SUP_LEVEL,
21176: 1 WBS_SUB_LEVEL,
21177: 'PRJ' INVERT_ID
21178: from DUAL
21179: union all
21180: select 1 WBS_SUP_LEVEL,
21181: 1 WBS_SUB_LEVEL,
21182: 'WBS' INVERT_ID

Line 21183: from DUAL

21179: union all
21180: select 1 WBS_SUP_LEVEL,
21181: 1 WBS_SUB_LEVEL,
21182: 'WBS' INVERT_ID
21183: from DUAL
21184: ) top_slice
21185: where
21186: prg.STRUCT_TYPE = 'PRG' and
21187: prg.SUP_LEVEL = l_level and

Line 21368: from DUAL

21364: (
21365: select 1 WBS_SUP_LEVEL,
21366: 1 WBS_SUB_LEVEL,
21367: 'PRJ' INVERT_ID
21368: from DUAL
21369: union all
21370: select 1 WBS_SUP_LEVEL,
21371: 1 WBS_SUB_LEVEL,
21372: 'WBS' INVERT_ID

Line 21373: from DUAL

21369: union all
21370: select 1 WBS_SUP_LEVEL,
21371: 1 WBS_SUB_LEVEL,
21372: 'WBS' INVERT_ID
21373: from DUAL
21374: ) top_slice
21375: where
21376: prg.STRUCT_TYPE = 'PRG' and
21377: prg.SUP_LEVEL = l_level and

Line 21760: from DUAL

21756: (
21757: select 1 WBS_SUP_LEVEL,
21758: 1 WBS_SUB_LEVEL,
21759: 'PRJ' INVERT_ID
21760: from DUAL
21761: union all
21762: select 1 WBS_SUP_LEVEL,
21763: 1 WBS_SUB_LEVEL,
21764: 'WBS' INVERT_ID

Line 21765: from DUAL

21761: union all
21762: select 1 WBS_SUP_LEVEL,
21763: 1 WBS_SUB_LEVEL,
21764: 'WBS' INVERT_ID
21765: from DUAL
21766: ) top_slice
21767: where
21768: prg.STRUCT_TYPE = 'PRG' and
21769: prg.SUP_LEVEL = l_level and

Line 21950: from DUAL

21946: (
21947: select 1 WBS_SUP_LEVEL,
21948: 1 WBS_SUB_LEVEL,
21949: 'PRJ' INVERT_ID
21950: from DUAL
21951: union all
21952: select 1 WBS_SUP_LEVEL,
21953: 1 WBS_SUB_LEVEL,
21954: 'WBS' INVERT_ID

Line 21955: from DUAL

21951: union all
21952: select 1 WBS_SUP_LEVEL,
21953: 1 WBS_SUB_LEVEL,
21954: 'WBS' INVERT_ID
21955: from DUAL
21956: ) top_slice
21957: where
21958: prg.STRUCT_TYPE = 'PRG' and
21959: prg.SUP_LEVEL = l_level and

Line 22342: from DUAL

22338: (
22339: select 1 WBS_SUP_LEVEL,
22340: 1 WBS_SUB_LEVEL,
22341: 'PRJ' INVERT_ID
22342: from DUAL
22343: union all
22344: select 1 WBS_SUP_LEVEL,
22345: 1 WBS_SUB_LEVEL,
22346: 'WBS' INVERT_ID

Line 22347: from DUAL

22343: union all
22344: select 1 WBS_SUP_LEVEL,
22345: 1 WBS_SUB_LEVEL,
22346: 'WBS' INVERT_ID
22347: from DUAL
22348: ) top_slice
22349: where
22350: prg.STRUCT_TYPE = 'PRG' and
22351: prg.SUP_LEVEL = l_level and

Line 22532: from DUAL

22528: (
22529: select 1 WBS_SUP_LEVEL,
22530: 1 WBS_SUB_LEVEL,
22531: 'PRJ' INVERT_ID
22532: from DUAL
22533: union all
22534: select 1 WBS_SUP_LEVEL,
22535: 1 WBS_SUB_LEVEL,
22536: 'WBS' INVERT_ID

Line 22537: from DUAL

22533: union all
22534: select 1 WBS_SUP_LEVEL,
22535: 1 WBS_SUB_LEVEL,
22536: 'WBS' INVERT_ID
22537: from DUAL
22538: ) top_slice
22539: where
22540: prg.STRUCT_TYPE = 'PRG' and
22541: prg.SUP_LEVEL = l_level and

Line 22924: from DUAL

22920: (
22921: select 1 WBS_SUP_LEVEL,
22922: 1 WBS_SUB_LEVEL,
22923: 'PRJ' INVERT_ID
22924: from DUAL
22925: union all
22926: select 1 WBS_SUP_LEVEL,
22927: 1 WBS_SUB_LEVEL,
22928: 'WBS' INVERT_ID

Line 22929: from DUAL

22925: union all
22926: select 1 WBS_SUP_LEVEL,
22927: 1 WBS_SUB_LEVEL,
22928: 'WBS' INVERT_ID
22929: from DUAL
22930: ) top_slice
22931: where
22932: prg.STRUCT_TYPE = 'PRG' and
22933: prg.SUP_LEVEL = l_level and

Line 23114: from DUAL

23110: (
23111: select 1 WBS_SUP_LEVEL,
23112: 1 WBS_SUB_LEVEL,
23113: 'PRJ' INVERT_ID
23114: from DUAL
23115: union all
23116: select 1 WBS_SUP_LEVEL,
23117: 1 WBS_SUB_LEVEL,
23118: 'WBS' INVERT_ID

Line 23119: from DUAL

23115: union all
23116: select 1 WBS_SUP_LEVEL,
23117: 1 WBS_SUB_LEVEL,
23118: 'WBS' INVERT_ID
23119: from DUAL
23120: ) top_slice
23121: where
23122: prg.STRUCT_TYPE = 'PRG' and
23123: prg.SUP_LEVEL = l_level and

Line 23506: from DUAL

23502: (
23503: select 1 WBS_SUP_LEVEL,
23504: 1 WBS_SUB_LEVEL,
23505: 'PRJ' INVERT_ID
23506: from DUAL
23507: union all
23508: select 1 WBS_SUP_LEVEL,
23509: 1 WBS_SUB_LEVEL,
23510: 'WBS' INVERT_ID

Line 23511: from DUAL

23507: union all
23508: select 1 WBS_SUP_LEVEL,
23509: 1 WBS_SUB_LEVEL,
23510: 'WBS' INVERT_ID
23511: from DUAL
23512: ) top_slice
23513: where
23514: prg.STRUCT_TYPE = 'PRG' and
23515: prg.SUP_LEVEL = l_level and

Line 23696: from DUAL

23692: (
23693: select 1 WBS_SUP_LEVEL,
23694: 1 WBS_SUB_LEVEL,
23695: 'PRJ' INVERT_ID
23696: from DUAL
23697: union all
23698: select 1 WBS_SUP_LEVEL,
23699: 1 WBS_SUB_LEVEL,
23700: 'WBS' INVERT_ID

Line 23701: from DUAL

23697: union all
23698: select 1 WBS_SUP_LEVEL,
23699: 1 WBS_SUB_LEVEL,
23700: 'WBS' INVERT_ID
23701: from DUAL
23702: ) top_slice
23703: where
23704: prg.STRUCT_TYPE = 'PRG' and
23705: prg.SUP_LEVEL = l_level and

Line 24088: from DUAL

24084: (
24085: select 1 WBS_SUP_LEVEL,
24086: 1 WBS_SUB_LEVEL,
24087: 'PRJ' INVERT_ID
24088: from DUAL
24089: union all
24090: select 1 WBS_SUP_LEVEL,
24091: 1 WBS_SUB_LEVEL,
24092: 'WBS' INVERT_ID

Line 24093: from DUAL

24089: union all
24090: select 1 WBS_SUP_LEVEL,
24091: 1 WBS_SUB_LEVEL,
24092: 'WBS' INVERT_ID
24093: from DUAL
24094: ) top_slice
24095: where
24096: prg.STRUCT_TYPE = 'PRG' and
24097: prg.SUP_LEVEL = l_level and

Line 24278: from DUAL

24274: (
24275: select 1 WBS_SUP_LEVEL,
24276: 1 WBS_SUB_LEVEL,
24277: 'PRJ' INVERT_ID
24278: from DUAL
24279: union all
24280: select 1 WBS_SUP_LEVEL,
24281: 1 WBS_SUB_LEVEL,
24282: 'WBS' INVERT_ID

Line 24283: from DUAL

24279: union all
24280: select 1 WBS_SUP_LEVEL,
24281: 1 WBS_SUB_LEVEL,
24282: 'WBS' INVERT_ID
24283: from DUAL
24284: ) top_slice
24285: where
24286: prg.STRUCT_TYPE = 'PRG' and
24287: prg.SUP_LEVEL = l_level and

Line 24670: from DUAL

24666: (
24667: select 1 WBS_SUP_LEVEL,
24668: 1 WBS_SUB_LEVEL,
24669: 'PRJ' INVERT_ID
24670: from DUAL
24671: union all
24672: select 1 WBS_SUP_LEVEL,
24673: 1 WBS_SUB_LEVEL,
24674: 'WBS' INVERT_ID

Line 24675: from DUAL

24671: union all
24672: select 1 WBS_SUP_LEVEL,
24673: 1 WBS_SUB_LEVEL,
24674: 'WBS' INVERT_ID
24675: from DUAL
24676: ) top_slice
24677: where
24678: prg.STRUCT_TYPE = 'PRG' and
24679: prg.SUP_LEVEL = l_level and

Line 24860: from DUAL

24856: (
24857: select 1 WBS_SUP_LEVEL,
24858: 1 WBS_SUB_LEVEL,
24859: 'PRJ' INVERT_ID
24860: from DUAL
24861: union all
24862: select 1 WBS_SUP_LEVEL,
24863: 1 WBS_SUB_LEVEL,
24864: 'WBS' INVERT_ID

Line 24865: from DUAL

24861: union all
24862: select 1 WBS_SUP_LEVEL,
24863: 1 WBS_SUB_LEVEL,
24864: 'WBS' INVERT_ID
24865: from DUAL
24866: ) top_slice
24867: where
24868: prg.STRUCT_TYPE = 'PRG' and
24869: prg.SUP_LEVEL = l_level and

Line 25252: from DUAL

25248: (
25249: select 1 WBS_SUP_LEVEL,
25250: 1 WBS_SUB_LEVEL,
25251: 'PRJ' INVERT_ID
25252: from DUAL
25253: union all
25254: select 1 WBS_SUP_LEVEL,
25255: 1 WBS_SUB_LEVEL,
25256: 'WBS' INVERT_ID

Line 25257: from DUAL

25253: union all
25254: select 1 WBS_SUP_LEVEL,
25255: 1 WBS_SUB_LEVEL,
25256: 'WBS' INVERT_ID
25257: from DUAL
25258: ) top_slice
25259: where
25260: prg.STRUCT_TYPE = 'PRG' and
25261: prg.SUP_LEVEL = l_level and

Line 25442: from DUAL

25438: (
25439: select 1 WBS_SUP_LEVEL,
25440: 1 WBS_SUB_LEVEL,
25441: 'PRJ' INVERT_ID
25442: from DUAL
25443: union all
25444: select 1 WBS_SUP_LEVEL,
25445: 1 WBS_SUB_LEVEL,
25446: 'WBS' INVERT_ID

Line 25447: from DUAL

25443: union all
25444: select 1 WBS_SUP_LEVEL,
25445: 1 WBS_SUB_LEVEL,
25446: 'WBS' INVERT_ID
25447: from DUAL
25448: ) top_slice
25449: where
25450: prg.STRUCT_TYPE = 'PRG' and
25451: prg.SUP_LEVEL = l_level and

Line 25834: from DUAL

25830: (
25831: select 1 WBS_SUP_LEVEL,
25832: 1 WBS_SUB_LEVEL,
25833: 'PRJ' INVERT_ID
25834: from DUAL
25835: union all
25836: select 1 WBS_SUP_LEVEL,
25837: 1 WBS_SUB_LEVEL,
25838: 'WBS' INVERT_ID

Line 25839: from DUAL

25835: union all
25836: select 1 WBS_SUP_LEVEL,
25837: 1 WBS_SUB_LEVEL,
25838: 'WBS' INVERT_ID
25839: from DUAL
25840: ) top_slice
25841: where
25842: prg.STRUCT_TYPE = 'PRG' and
25843: prg.SUP_LEVEL = l_level and

Line 26024: from DUAL

26020: (
26021: select 1 WBS_SUP_LEVEL,
26022: 1 WBS_SUB_LEVEL,
26023: 'PRJ' INVERT_ID
26024: from DUAL
26025: union all
26026: select 1 WBS_SUP_LEVEL,
26027: 1 WBS_SUB_LEVEL,
26028: 'WBS' INVERT_ID

Line 26029: from DUAL

26025: union all
26026: select 1 WBS_SUP_LEVEL,
26027: 1 WBS_SUB_LEVEL,
26028: 'WBS' INVERT_ID
26029: from DUAL
26030: ) top_slice
26031: where
26032: prg.STRUCT_TYPE = 'PRG' and
26033: prg.SUP_LEVEL = l_level and

Line 26416: from DUAL

26412: (
26413: select 1 WBS_SUP_LEVEL,
26414: 1 WBS_SUB_LEVEL,
26415: 'PRJ' INVERT_ID
26416: from DUAL
26417: union all
26418: select 1 WBS_SUP_LEVEL,
26419: 1 WBS_SUB_LEVEL,
26420: 'WBS' INVERT_ID

Line 26421: from DUAL

26417: union all
26418: select 1 WBS_SUP_LEVEL,
26419: 1 WBS_SUB_LEVEL,
26420: 'WBS' INVERT_ID
26421: from DUAL
26422: ) top_slice
26423: where
26424: prg.STRUCT_TYPE = 'PRG' and
26425: prg.SUP_LEVEL = l_level and

Line 26606: from DUAL

26602: (
26603: select 1 WBS_SUP_LEVEL,
26604: 1 WBS_SUB_LEVEL,
26605: 'PRJ' INVERT_ID
26606: from DUAL
26607: union all
26608: select 1 WBS_SUP_LEVEL,
26609: 1 WBS_SUB_LEVEL,
26610: 'WBS' INVERT_ID

Line 26611: from DUAL

26607: union all
26608: select 1 WBS_SUP_LEVEL,
26609: 1 WBS_SUB_LEVEL,
26610: 'WBS' INVERT_ID
26611: from DUAL
26612: ) top_slice
26613: where
26614: prg.STRUCT_TYPE = 'PRG' and
26615: prg.SUP_LEVEL = l_level and

Line 27242: from DUAL union all

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
27242: from DUAL union all
27243: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
27244: from DUAL union all
27245: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
27246: from DUAL union all

Line 27244: from DUAL union all

27240: (
27241: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
27242: from DUAL union all
27243: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
27244: from DUAL union all
27245: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
27246: from DUAL union all
27247: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
27248: from DUAL

Line 27246: from DUAL union all

27242: from DUAL union all
27243: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
27244: from DUAL union all
27245: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
27246: from DUAL union all
27247: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
27248: from DUAL
27249: ) fin_plan
27250: where

Line 27248: from DUAL

27244: from DUAL union all
27245: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
27246: from DUAL union all
27247: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
27248: from DUAL
27249: ) fin_plan
27250: where
27251: prg.WORKER_ID = p_worker_id and
27252: prg.STRUCT_TYPE = 'PRG' and

Line 27643: from DUAL union all

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
27643: from DUAL union all
27644: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
27645: from DUAL union all
27646: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
27647: from DUAL union all

Line 27645: from DUAL union all

27641: (
27642: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
27643: from DUAL union all
27644: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
27645: from DUAL union all
27646: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
27647: from DUAL union all
27648: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
27649: from DUAL

Line 27647: from DUAL union all

27643: from DUAL union all
27644: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
27645: from DUAL union all
27646: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
27647: from DUAL union all
27648: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
27649: from DUAL
27650: ) fin_plan
27651: where

Line 27649: from DUAL

27645: from DUAL union all
27646: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
27647: from DUAL union all
27648: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
27649: from DUAL
27650: ) fin_plan
27651: where
27652: prg.STRUCT_TYPE = 'PRG' and
27653: prg.SUP_LEVEL = l_level and

Line 27740: from DUAL

27736: PA_XBS_DENORM wbs,
27737: (
27738: select 1 WBS_SUP_LEVEL,
27739: 'PRJ' INVERT_ID
27740: from DUAL
27741: union all
27742: select 1 WBS_SUP_LEVEL,
27743: 'WBS' INVERT_ID
27744: from DUAL

Line 27744: from DUAL

27740: from DUAL
27741: union all
27742: select 1 WBS_SUP_LEVEL,
27743: 'WBS' INVERT_ID
27744: from DUAL
27745: ) top_slice
27746: where
27747: map.WORKER_ID = p_worker_id and
27748: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 28287: from DUAL union all

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
28287: from DUAL union all
28288: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
28289: from DUAL union all
28290: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
28291: from DUAL union all

Line 28289: from DUAL union all

28285: (
28286: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
28287: from DUAL union all
28288: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
28289: from DUAL union all
28290: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
28291: from DUAL union all
28292: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
28293: from DUAL

Line 28291: from DUAL union all

28287: from DUAL union all
28288: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
28289: from DUAL union all
28290: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
28291: from DUAL union all
28292: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
28293: from DUAL
28294: ) fin_plan
28295: where

Line 28293: from DUAL

28289: from DUAL union all
28290: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
28291: from DUAL union all
28292: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
28293: from DUAL
28294: ) fin_plan
28295: where
28296: prg.WORKER_ID = p_worker_id and
28297: prg.STRUCT_TYPE = 'PRG' and

Line 28688: from DUAL union all

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
28688: from DUAL union all
28689: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
28690: from DUAL union all
28691: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
28692: from DUAL union all

Line 28690: from DUAL union all

28686: (
28687: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
28688: from DUAL union all
28689: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
28690: from DUAL union all
28691: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
28692: from DUAL union all
28693: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
28694: from DUAL

Line 28692: from DUAL union all

28688: from DUAL union all
28689: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
28690: from DUAL union all
28691: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
28692: from DUAL union all
28693: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
28694: from DUAL
28695: ) fin_plan
28696: where

Line 28694: from DUAL

28690: from DUAL union all
28691: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
28692: from DUAL union all
28693: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
28694: from DUAL
28695: ) fin_plan
28696: where
28697: prg.STRUCT_TYPE = 'PRG' and
28698: prg.SUP_LEVEL = l_level and

Line 28785: from DUAL

28781: PA_XBS_DENORM wbs,
28782: (
28783: select 1 WBS_SUP_LEVEL,
28784: 'PRJ' INVERT_ID
28785: from DUAL
28786: union all
28787: select 1 WBS_SUP_LEVEL,
28788: 'WBS' INVERT_ID
28789: from DUAL

Line 28789: from DUAL

28785: from DUAL
28786: union all
28787: select 1 WBS_SUP_LEVEL,
28788: 'WBS' INVERT_ID
28789: from DUAL
28790: ) top_slice
28791: where
28792: map.WORKER_ID = p_worker_id and
28793: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 29332: from DUAL union all

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
29332: from DUAL union all
29333: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
29334: from DUAL union all
29335: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
29336: from DUAL union all

Line 29334: from DUAL union all

29330: (
29331: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
29332: from DUAL union all
29333: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
29334: from DUAL union all
29335: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
29336: from DUAL union all
29337: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
29338: from DUAL

Line 29336: from DUAL union all

29332: from DUAL union all
29333: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
29334: from DUAL union all
29335: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
29336: from DUAL union all
29337: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
29338: from DUAL
29339: ) fin_plan
29340: where

Line 29338: from DUAL

29334: from DUAL union all
29335: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
29336: from DUAL union all
29337: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
29338: from DUAL
29339: ) fin_plan
29340: where
29341: prg.WORKER_ID = p_worker_id and
29342: prg.STRUCT_TYPE = 'PRG' and

Line 29733: from DUAL union all

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
29733: from DUAL union all
29734: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
29735: from DUAL union all
29736: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
29737: from DUAL union all

Line 29735: from DUAL union all

29731: (
29732: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
29733: from DUAL union all
29734: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
29735: from DUAL union all
29736: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
29737: from DUAL union all
29738: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
29739: from DUAL

Line 29737: from DUAL union all

29733: from DUAL union all
29734: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
29735: from DUAL union all
29736: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
29737: from DUAL union all
29738: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
29739: from DUAL
29740: ) fin_plan
29741: where

Line 29739: from DUAL

29735: from DUAL union all
29736: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
29737: from DUAL union all
29738: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
29739: from DUAL
29740: ) fin_plan
29741: where
29742: prg.STRUCT_TYPE = 'PRG' and
29743: prg.SUP_LEVEL = l_level and

Line 29830: from DUAL

29826: PA_XBS_DENORM wbs,
29827: (
29828: select 1 WBS_SUP_LEVEL,
29829: 'PRJ' INVERT_ID
29830: from DUAL
29831: union all
29832: select 1 WBS_SUP_LEVEL,
29833: 'WBS' INVERT_ID
29834: from DUAL

Line 29834: from DUAL

29830: from DUAL
29831: union all
29832: select 1 WBS_SUP_LEVEL,
29833: 'WBS' INVERT_ID
29834: from DUAL
29835: ) top_slice
29836: where
29837: map.WORKER_ID = p_worker_id and
29838: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 30377: from DUAL union all

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
30377: from DUAL union all
30378: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
30379: from DUAL union all
30380: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
30381: from DUAL union all

Line 30379: from DUAL union all

30375: (
30376: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
30377: from DUAL union all
30378: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
30379: from DUAL union all
30380: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
30381: from DUAL union all
30382: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
30383: from DUAL

Line 30381: from DUAL union all

30377: from DUAL union all
30378: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
30379: from DUAL union all
30380: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
30381: from DUAL union all
30382: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
30383: from DUAL
30384: ) fin_plan
30385: where

Line 30383: from DUAL

30379: from DUAL union all
30380: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
30381: from DUAL union all
30382: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
30383: from DUAL
30384: ) fin_plan
30385: where
30386: prg.WORKER_ID = p_worker_id and
30387: prg.STRUCT_TYPE = 'PRG' and

Line 30778: from DUAL union all

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
30778: from DUAL union all
30779: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
30780: from DUAL union all
30781: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
30782: from DUAL union all

Line 30780: from DUAL union all

30776: (
30777: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
30778: from DUAL union all
30779: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
30780: from DUAL union all
30781: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
30782: from DUAL union all
30783: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
30784: from DUAL

Line 30782: from DUAL union all

30778: from DUAL union all
30779: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
30780: from DUAL union all
30781: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
30782: from DUAL union all
30783: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
30784: from DUAL
30785: ) fin_plan
30786: where

Line 30784: from DUAL

30780: from DUAL union all
30781: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
30782: from DUAL union all
30783: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
30784: from DUAL
30785: ) fin_plan
30786: where
30787: prg.STRUCT_TYPE = 'PRG' and
30788: prg.SUP_LEVEL = l_level and

Line 30875: from DUAL

30871: PA_XBS_DENORM wbs,
30872: (
30873: select 1 WBS_SUP_LEVEL,
30874: 'PRJ' INVERT_ID
30875: from DUAL
30876: union all
30877: select 1 WBS_SUP_LEVEL,
30878: 'WBS' INVERT_ID
30879: from DUAL

Line 30879: from DUAL

30875: from DUAL
30876: union all
30877: select 1 WBS_SUP_LEVEL,
30878: 'WBS' INVERT_ID
30879: from DUAL
30880: ) top_slice
30881: where
30882: map.WORKER_ID = p_worker_id and
30883: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 31422: from DUAL union all

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
31422: from DUAL union all
31423: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
31424: from DUAL union all
31425: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
31426: from DUAL union all

Line 31424: from DUAL union all

31420: (
31421: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
31422: from DUAL union all
31423: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
31424: from DUAL union all
31425: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
31426: from DUAL union all
31427: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
31428: from DUAL

Line 31426: from DUAL union all

31422: from DUAL union all
31423: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
31424: from DUAL union all
31425: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
31426: from DUAL union all
31427: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
31428: from DUAL
31429: ) fin_plan
31430: where

Line 31428: from DUAL

31424: from DUAL union all
31425: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
31426: from DUAL union all
31427: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
31428: from DUAL
31429: ) fin_plan
31430: where
31431: prg.WORKER_ID = p_worker_id and
31432: prg.STRUCT_TYPE = 'PRG' and

Line 31823: from DUAL union all

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
31823: from DUAL union all
31824: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
31825: from DUAL union all
31826: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
31827: from DUAL union all

Line 31825: from DUAL union all

31821: (
31822: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
31823: from DUAL union all
31824: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
31825: from DUAL union all
31826: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
31827: from DUAL union all
31828: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
31829: from DUAL

Line 31827: from DUAL union all

31823: from DUAL union all
31824: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
31825: from DUAL union all
31826: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
31827: from DUAL union all
31828: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
31829: from DUAL
31830: ) fin_plan
31831: where

Line 31829: from DUAL

31825: from DUAL union all
31826: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
31827: from DUAL union all
31828: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
31829: from DUAL
31830: ) fin_plan
31831: where
31832: prg.STRUCT_TYPE = 'PRG' and
31833: prg.SUP_LEVEL = l_level and

Line 31920: from DUAL

31916: PA_XBS_DENORM wbs,
31917: (
31918: select 1 WBS_SUP_LEVEL,
31919: 'PRJ' INVERT_ID
31920: from DUAL
31921: union all
31922: select 1 WBS_SUP_LEVEL,
31923: 'WBS' INVERT_ID
31924: from DUAL

Line 31924: from DUAL

31920: from DUAL
31921: union all
31922: select 1 WBS_SUP_LEVEL,
31923: 'WBS' INVERT_ID
31924: from DUAL
31925: ) top_slice
31926: where
31927: map.WORKER_ID = p_worker_id and
31928: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 32467: from DUAL union all

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
32467: from DUAL union all
32468: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
32469: from DUAL union all
32470: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
32471: from DUAL union all

Line 32469: from DUAL union all

32465: (
32466: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
32467: from DUAL union all
32468: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
32469: from DUAL union all
32470: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
32471: from DUAL union all
32472: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
32473: from DUAL

Line 32471: from DUAL union all

32467: from DUAL union all
32468: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
32469: from DUAL union all
32470: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
32471: from DUAL union all
32472: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
32473: from DUAL
32474: ) fin_plan
32475: where

Line 32473: from DUAL

32469: from DUAL union all
32470: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
32471: from DUAL union all
32472: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
32473: from DUAL
32474: ) fin_plan
32475: where
32476: prg.WORKER_ID = p_worker_id and
32477: prg.STRUCT_TYPE = 'PRG' and

Line 32868: from DUAL union all

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
32868: from DUAL union all
32869: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
32870: from DUAL union all
32871: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
32872: from DUAL union all

Line 32870: from DUAL union all

32866: (
32867: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
32868: from DUAL union all
32869: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
32870: from DUAL union all
32871: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
32872: from DUAL union all
32873: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
32874: from DUAL

Line 32872: from DUAL union all

32868: from DUAL union all
32869: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
32870: from DUAL union all
32871: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
32872: from DUAL union all
32873: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
32874: from DUAL
32875: ) fin_plan
32876: where

Line 32874: from DUAL

32870: from DUAL union all
32871: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
32872: from DUAL union all
32873: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
32874: from DUAL
32875: ) fin_plan
32876: where
32877: prg.STRUCT_TYPE = 'PRG' and
32878: prg.SUP_LEVEL = l_level and

Line 32965: from DUAL

32961: PA_XBS_DENORM wbs,
32962: (
32963: select 1 WBS_SUP_LEVEL,
32964: 'PRJ' INVERT_ID
32965: from DUAL
32966: union all
32967: select 1 WBS_SUP_LEVEL,
32968: 'WBS' INVERT_ID
32969: from DUAL

Line 32969: from DUAL

32965: from DUAL
32966: union all
32967: select 1 WBS_SUP_LEVEL,
32968: 'WBS' INVERT_ID
32969: from DUAL
32970: ) top_slice
32971: where
32972: map.WORKER_ID = p_worker_id and
32973: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 33512: from DUAL union all

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
33512: from DUAL union all
33513: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
33514: from DUAL union all
33515: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
33516: from DUAL union all

Line 33514: from DUAL union all

33510: (
33511: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
33512: from DUAL union all
33513: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
33514: from DUAL union all
33515: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
33516: from DUAL union all
33517: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
33518: from DUAL

Line 33516: from DUAL union all

33512: from DUAL union all
33513: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
33514: from DUAL union all
33515: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
33516: from DUAL union all
33517: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
33518: from DUAL
33519: ) fin_plan
33520: where

Line 33518: from DUAL

33514: from DUAL union all
33515: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
33516: from DUAL union all
33517: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
33518: from DUAL
33519: ) fin_plan
33520: where
33521: prg.WORKER_ID = p_worker_id and
33522: prg.STRUCT_TYPE = 'PRG' and

Line 33913: from DUAL union all

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
33913: from DUAL union all
33914: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
33915: from DUAL union all
33916: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
33917: from DUAL union all

Line 33915: from DUAL union all

33911: (
33912: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
33913: from DUAL union all
33914: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
33915: from DUAL union all
33916: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
33917: from DUAL union all
33918: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
33919: from DUAL

Line 33917: from DUAL union all

33913: from DUAL union all
33914: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
33915: from DUAL union all
33916: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
33917: from DUAL union all
33918: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
33919: from DUAL
33920: ) fin_plan
33921: where

Line 33919: from DUAL

33915: from DUAL union all
33916: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
33917: from DUAL union all
33918: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
33919: from DUAL
33920: ) fin_plan
33921: where
33922: prg.STRUCT_TYPE = 'PRG' and
33923: prg.SUP_LEVEL = l_level and

Line 34010: from DUAL

34006: PA_XBS_DENORM wbs,
34007: (
34008: select 1 WBS_SUP_LEVEL,
34009: 'PRJ' INVERT_ID
34010: from DUAL
34011: union all
34012: select 1 WBS_SUP_LEVEL,
34013: 'WBS' INVERT_ID
34014: from DUAL

Line 34014: from DUAL

34010: from DUAL
34011: union all
34012: select 1 WBS_SUP_LEVEL,
34013: 'WBS' INVERT_ID
34014: from DUAL
34015: ) top_slice
34016: where
34017: map.WORKER_ID = p_worker_id and
34018: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 34557: from DUAL union all

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
34557: from DUAL union all
34558: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
34559: from DUAL union all
34560: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
34561: from DUAL union all

Line 34559: from DUAL union all

34555: (
34556: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
34557: from DUAL union all
34558: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
34559: from DUAL union all
34560: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
34561: from DUAL union all
34562: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
34563: from DUAL

Line 34561: from DUAL union all

34557: from DUAL union all
34558: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
34559: from DUAL union all
34560: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
34561: from DUAL union all
34562: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
34563: from DUAL
34564: ) fin_plan
34565: where

Line 34563: from DUAL

34559: from DUAL union all
34560: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
34561: from DUAL union all
34562: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
34563: from DUAL
34564: ) fin_plan
34565: where
34566: prg.WORKER_ID = p_worker_id and
34567: prg.STRUCT_TYPE = 'PRG' and

Line 34958: from DUAL union all

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
34958: from DUAL union all
34959: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
34960: from DUAL union all
34961: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
34962: from DUAL union all

Line 34960: from DUAL union all

34956: (
34957: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
34958: from DUAL union all
34959: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
34960: from DUAL union all
34961: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
34962: from DUAL union all
34963: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
34964: from DUAL

Line 34962: from DUAL union all

34958: from DUAL union all
34959: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
34960: from DUAL union all
34961: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
34962: from DUAL union all
34963: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
34964: from DUAL
34965: ) fin_plan
34966: where

Line 34964: from DUAL

34960: from DUAL union all
34961: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
34962: from DUAL union all
34963: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
34964: from DUAL
34965: ) fin_plan
34966: where
34967: prg.STRUCT_TYPE = 'PRG' and
34968: prg.SUP_LEVEL = l_level and

Line 35055: from DUAL

35051: PA_XBS_DENORM wbs,
35052: (
35053: select 1 WBS_SUP_LEVEL,
35054: 'PRJ' INVERT_ID
35055: from DUAL
35056: union all
35057: select 1 WBS_SUP_LEVEL,
35058: 'WBS' INVERT_ID
35059: from DUAL

Line 35059: from DUAL

35055: from DUAL
35056: union all
35057: select 1 WBS_SUP_LEVEL,
35058: 'WBS' INVERT_ID
35059: from DUAL
35060: ) top_slice
35061: where
35062: map.WORKER_ID = p_worker_id and
35063: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 35602: from DUAL union all

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
35602: from DUAL union all
35603: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
35604: from DUAL union all
35605: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
35606: from DUAL union all

Line 35604: from DUAL union all

35600: (
35601: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
35602: from DUAL union all
35603: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
35604: from DUAL union all
35605: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
35606: from DUAL union all
35607: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
35608: from DUAL

Line 35606: from DUAL union all

35602: from DUAL union all
35603: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
35604: from DUAL union all
35605: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
35606: from DUAL union all
35607: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
35608: from DUAL
35609: ) fin_plan
35610: where

Line 35608: from DUAL

35604: from DUAL union all
35605: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
35606: from DUAL union all
35607: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
35608: from DUAL
35609: ) fin_plan
35610: where
35611: prg.WORKER_ID = p_worker_id and
35612: prg.STRUCT_TYPE = 'PRG' and

Line 36003: from DUAL union all

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
36003: from DUAL union all
36004: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
36005: from DUAL union all
36006: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
36007: from DUAL union all

Line 36005: from DUAL union all

36001: (
36002: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
36003: from DUAL union all
36004: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
36005: from DUAL union all
36006: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
36007: from DUAL union all
36008: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
36009: from DUAL

Line 36007: from DUAL union all

36003: from DUAL union all
36004: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
36005: from DUAL union all
36006: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
36007: from DUAL union all
36008: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
36009: from DUAL
36010: ) fin_plan
36011: where

Line 36009: from DUAL

36005: from DUAL union all
36006: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
36007: from DUAL union all
36008: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
36009: from DUAL
36010: ) fin_plan
36011: where
36012: prg.STRUCT_TYPE = 'PRG' and
36013: prg.SUP_LEVEL = l_level and

Line 36100: from DUAL

36096: PA_XBS_DENORM wbs,
36097: (
36098: select 1 WBS_SUP_LEVEL,
36099: 'PRJ' INVERT_ID
36100: from DUAL
36101: union all
36102: select 1 WBS_SUP_LEVEL,
36103: 'WBS' INVERT_ID
36104: from DUAL

Line 36104: from DUAL

36100: from DUAL
36101: union all
36102: select 1 WBS_SUP_LEVEL,
36103: 'WBS' INVERT_ID
36104: from DUAL
36105: ) top_slice
36106: where
36107: map.WORKER_ID = p_worker_id and
36108: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 36647: from DUAL union all

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
36647: from DUAL union all
36648: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
36649: from DUAL union all
36650: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
36651: from DUAL union all

Line 36649: from DUAL union all

36645: (
36646: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
36647: from DUAL union all
36648: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
36649: from DUAL union all
36650: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
36651: from DUAL union all
36652: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
36653: from DUAL

Line 36651: from DUAL union all

36647: from DUAL union all
36648: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
36649: from DUAL union all
36650: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
36651: from DUAL union all
36652: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
36653: from DUAL
36654: ) fin_plan
36655: where

Line 36653: from DUAL

36649: from DUAL union all
36650: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
36651: from DUAL union all
36652: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
36653: from DUAL
36654: ) fin_plan
36655: where
36656: prg.WORKER_ID = p_worker_id and
36657: prg.STRUCT_TYPE = 'PRG' and

Line 37048: from DUAL union all

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
37048: from DUAL union all
37049: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
37050: from DUAL union all
37051: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
37052: from DUAL union all

Line 37050: from DUAL union all

37046: (
37047: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
37048: from DUAL union all
37049: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
37050: from DUAL union all
37051: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
37052: from DUAL union all
37053: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
37054: from DUAL

Line 37052: from DUAL union all

37048: from DUAL union all
37049: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
37050: from DUAL union all
37051: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
37052: from DUAL union all
37053: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
37054: from DUAL
37055: ) fin_plan
37056: where

Line 37054: from DUAL

37050: from DUAL union all
37051: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
37052: from DUAL union all
37053: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
37054: from DUAL
37055: ) fin_plan
37056: where
37057: prg.STRUCT_TYPE = 'PRG' and
37058: prg.SUP_LEVEL = l_level and

Line 37145: from DUAL

37141: PA_XBS_DENORM wbs,
37142: (
37143: select 1 WBS_SUP_LEVEL,
37144: 'PRJ' INVERT_ID
37145: from DUAL
37146: union all
37147: select 1 WBS_SUP_LEVEL,
37148: 'WBS' INVERT_ID
37149: from DUAL

Line 37149: from DUAL

37145: from DUAL
37146: union all
37147: select 1 WBS_SUP_LEVEL,
37148: 'WBS' INVERT_ID
37149: from DUAL
37150: ) top_slice
37151: where
37152: map.WORKER_ID = p_worker_id and
37153: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 37523: from DUAL

37519: PA_XBS_DENORM wbs,
37520: (
37521: select 1 WBS_SUP_LEVEL,
37522: 'PRJ' INVERT_ID
37523: from DUAL
37524: union all
37525: select 1 WBS_SUP_LEVEL,
37526: 'WBS' INVERT_ID
37527: from DUAL

Line 37527: from DUAL

37523: from DUAL
37524: union all
37525: select 1 WBS_SUP_LEVEL,
37526: 'WBS' INVERT_ID
37527: from DUAL
37528: ) top_slice
37529: where
37530: map.WORKER_ID = p_worker_id and
37531: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 37866: from DUAL

37862: PA_XBS_DENORM wbs,
37863: (
37864: select 1 WBS_SUP_LEVEL,
37865: 'PRJ' INVERT_ID
37866: from DUAL
37867: union all
37868: select 1 WBS_SUP_LEVEL,
37869: 'WBS' INVERT_ID
37870: from DUAL

Line 37870: from DUAL

37866: from DUAL
37867: union all
37868: select 1 WBS_SUP_LEVEL,
37869: 'WBS' INVERT_ID
37870: from DUAL
37871: ) top_slice
37872: where
37873: map.WORKER_ID = p_worker_id and
37874: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 38208: from DUAL

38204: PA_XBS_DENORM wbs,
38205: (
38206: select 1 WBS_SUP_LEVEL,
38207: 'PRJ' INVERT_ID
38208: from DUAL
38209: union all
38210: select 1 WBS_SUP_LEVEL,
38211: 'WBS' INVERT_ID
38212: from DUAL

Line 38212: from DUAL

38208: from DUAL
38209: union all
38210: select 1 WBS_SUP_LEVEL,
38211: 'WBS' INVERT_ID
38212: from DUAL
38213: ) top_slice
38214: where
38215: map.WORKER_ID = p_worker_id and
38216: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 38550: from DUAL

38546: PA_XBS_DENORM wbs,
38547: (
38548: select 1 WBS_SUP_LEVEL,
38549: 'PRJ' INVERT_ID
38550: from DUAL
38551: union all
38552: select 1 WBS_SUP_LEVEL,
38553: 'WBS' INVERT_ID
38554: from DUAL

Line 38554: from DUAL

38550: from DUAL
38551: union all
38552: select 1 WBS_SUP_LEVEL,
38553: 'WBS' INVERT_ID
38554: from DUAL
38555: ) top_slice
38556: where
38557: map.WORKER_ID = p_worker_id and
38558: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 38892: from DUAL

38888: PA_XBS_DENORM wbs,
38889: (
38890: select 1 WBS_SUP_LEVEL,
38891: 'PRJ' INVERT_ID
38892: from DUAL
38893: union all
38894: select 1 WBS_SUP_LEVEL,
38895: 'WBS' INVERT_ID
38896: from DUAL

Line 38896: from DUAL

38892: from DUAL
38893: union all
38894: select 1 WBS_SUP_LEVEL,
38895: 'WBS' INVERT_ID
38896: from DUAL
38897: ) top_slice
38898: where
38899: map.WORKER_ID = p_worker_id and
38900: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 39234: from DUAL

39230: PA_XBS_DENORM wbs,
39231: (
39232: select 1 WBS_SUP_LEVEL,
39233: 'PRJ' INVERT_ID
39234: from DUAL
39235: union all
39236: select 1 WBS_SUP_LEVEL,
39237: 'WBS' INVERT_ID
39238: from DUAL

Line 39238: from DUAL

39234: from DUAL
39235: union all
39236: select 1 WBS_SUP_LEVEL,
39237: 'WBS' INVERT_ID
39238: from DUAL
39239: ) top_slice
39240: where
39241: map.WORKER_ID = p_worker_id and
39242: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 39576: from DUAL

39572: PA_XBS_DENORM wbs,
39573: (
39574: select 1 WBS_SUP_LEVEL,
39575: 'PRJ' INVERT_ID
39576: from DUAL
39577: union all
39578: select 1 WBS_SUP_LEVEL,
39579: 'WBS' INVERT_ID
39580: from DUAL

Line 39580: from DUAL

39576: from DUAL
39577: union all
39578: select 1 WBS_SUP_LEVEL,
39579: 'WBS' INVERT_ID
39580: from DUAL
39581: ) top_slice
39582: where
39583: map.WORKER_ID = p_worker_id and
39584: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 39918: from DUAL

39914: PA_XBS_DENORM wbs,
39915: (
39916: select 1 WBS_SUP_LEVEL,
39917: 'PRJ' INVERT_ID
39918: from DUAL
39919: union all
39920: select 1 WBS_SUP_LEVEL,
39921: 'WBS' INVERT_ID
39922: from DUAL

Line 39922: from DUAL

39918: from DUAL
39919: union all
39920: select 1 WBS_SUP_LEVEL,
39921: 'WBS' INVERT_ID
39922: from DUAL
39923: ) top_slice
39924: where
39925: map.WORKER_ID = p_worker_id and
39926: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 40260: from DUAL

40256: PA_XBS_DENORM wbs,
40257: (
40258: select 1 WBS_SUP_LEVEL,
40259: 'PRJ' INVERT_ID
40260: from DUAL
40261: union all
40262: select 1 WBS_SUP_LEVEL,
40263: 'WBS' INVERT_ID
40264: from DUAL

Line 40264: from DUAL

40260: from DUAL
40261: union all
40262: select 1 WBS_SUP_LEVEL,
40263: 'WBS' INVERT_ID
40264: from DUAL
40265: ) top_slice
40266: where
40267: map.WORKER_ID = p_worker_id and
40268: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 40602: from DUAL

40598: PA_XBS_DENORM wbs,
40599: (
40600: select 1 WBS_SUP_LEVEL,
40601: 'PRJ' INVERT_ID
40602: from DUAL
40603: union all
40604: select 1 WBS_SUP_LEVEL,
40605: 'WBS' INVERT_ID
40606: from DUAL

Line 40606: from DUAL

40602: from DUAL
40603: union all
40604: select 1 WBS_SUP_LEVEL,
40605: 'WBS' INVERT_ID
40606: from DUAL
40607: ) top_slice
40608: where
40609: map.WORKER_ID = p_worker_id and
40610: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 46050: from DUAL union all

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
46050: from DUAL union all
46051: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46052: from DUAL union all
46053: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
46054: from DUAL union all

Line 46052: from DUAL union all

46048: (
46049: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
46050: from DUAL union all
46051: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46052: from DUAL union all
46053: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
46054: from DUAL union all
46055: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46056: from DUAL union all

Line 46054: from DUAL union all

46050: from DUAL union all
46051: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46052: from DUAL union all
46053: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
46054: from DUAL union all
46055: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46056: from DUAL union all
46057: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
46058: from DUAL union all

Line 46056: from DUAL union all

46052: from DUAL union all
46053: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
46054: from DUAL union all
46055: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46056: from DUAL union all
46057: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
46058: from DUAL union all
46059: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46060: from DUAL union all

Line 46058: from DUAL union all

46054: from DUAL union all
46055: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46056: from DUAL union all
46057: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
46058: from DUAL union all
46059: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46060: from DUAL union all
46061: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
46062: from DUAL union all

Line 46060: from DUAL union all

46056: from DUAL union all
46057: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
46058: from DUAL union all
46059: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46060: from DUAL union all
46061: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
46062: from DUAL union all
46063: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46064: from DUAL

Line 46062: from DUAL union all

46058: from DUAL union all
46059: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46060: from DUAL union all
46061: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
46062: from DUAL union all
46063: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46064: from DUAL
46065: ) fin_plan,
46066: (

Line 46064: from DUAL

46060: from DUAL union all
46061: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
46062: from DUAL union all
46063: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46064: from DUAL
46065: ) fin_plan,
46066: (
46067: select 1 WBS_SUP_LEVEL,
46068: 1 WBS_SUB_LEVEL,

Line 46070: from DUAL

46066: (
46067: select 1 WBS_SUP_LEVEL,
46068: 1 WBS_SUB_LEVEL,
46069: 'PRJ' INVERT_ID
46070: from DUAL
46071: union all
46072: select 1 WBS_SUP_LEVEL,
46073: 1 WBS_SUB_LEVEL,
46074: 'WBS' INVERT_ID

Line 46075: from DUAL

46071: union all
46072: select 1 WBS_SUP_LEVEL,
46073: 1 WBS_SUB_LEVEL,
46074: 'WBS' INVERT_ID
46075: from DUAL
46076: ) top_slice
46077: where
46078: prg.STRUCT_TYPE = 'PRG' and
46079: prg.SUP_LEVEL = l_level and

Line 46208: from DUAL union all

46204: (
46205: select 'Y' CB_FLAG,
46206: 'N' CO_FLAG,
46207: -3 PLAN_VERSION_ID
46208: from DUAL union all
46209: select 'N' CB_FLAG,
46210: 'Y' CO_FLAG,
46211: -4 PLAN_VERSION_ID
46212: from DUAL union all

Line 46212: from DUAL union all

46208: from DUAL union all
46209: select 'N' CB_FLAG,
46210: 'Y' CO_FLAG,
46211: -4 PLAN_VERSION_ID
46212: from DUAL union all
46213: select 'Y' CB_FLAG,
46214: 'Y' CO_FLAG,
46215: -3 PLAN_VERSION_ID
46216: from DUAL union all

Line 46216: from DUAL union all

46212: from DUAL union all
46213: select 'Y' CB_FLAG,
46214: 'Y' CO_FLAG,
46215: -3 PLAN_VERSION_ID
46216: from DUAL union all
46217: select 'Y' CB_FLAG,
46218: 'Y' CO_FLAG,
46219: -4 PLAN_VERSION_ID
46220: from DUAL

Line 46220: from DUAL

46216: from DUAL union all
46217: select 'Y' CB_FLAG,
46218: 'Y' CO_FLAG,
46219: -4 PLAN_VERSION_ID
46220: from DUAL
46221: ) fin_plan
46222: where
46223: prg.STRUCT_TYPE = 'PRG' and
46224: prg.SUP_LEVEL = l_level and

Line 46362: from DUAL union all

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
46362: from DUAL union all
46363: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46364: from DUAL union all
46365: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
46366: from DUAL union all

Line 46364: from DUAL union all

46360: (
46361: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
46362: from DUAL union all
46363: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46364: from DUAL union all
46365: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
46366: from DUAL union all
46367: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46368: from DUAL union all

Line 46366: from DUAL union all

46362: from DUAL union all
46363: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46364: from DUAL union all
46365: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
46366: from DUAL union all
46367: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46368: from DUAL union all
46369: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
46370: from DUAL union all

Line 46368: from DUAL union all

46364: from DUAL union all
46365: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
46366: from DUAL union all
46367: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46368: from DUAL union all
46369: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
46370: from DUAL union all
46371: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46372: from DUAL union all

Line 46370: from DUAL union all

46366: from DUAL union all
46367: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46368: from DUAL union all
46369: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
46370: from DUAL union all
46371: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46372: from DUAL union all
46373: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
46374: from DUAL union all

Line 46372: from DUAL union all

46368: from DUAL union all
46369: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
46370: from DUAL union all
46371: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46372: from DUAL union all
46373: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
46374: from DUAL union all
46375: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46376: from DUAL

Line 46374: from DUAL union all

46370: from DUAL union all
46371: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46372: from DUAL union all
46373: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
46374: from DUAL union all
46375: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46376: from DUAL
46377: ) fin_plan,
46378: (

Line 46376: from DUAL

46372: from DUAL union all
46373: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
46374: from DUAL union all
46375: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
46376: from DUAL
46377: ) fin_plan,
46378: (
46379: select 1 WBS_SUP_LEVEL,
46380: 1 WBS_SUB_LEVEL,

Line 46382: from DUAL

46378: (
46379: select 1 WBS_SUP_LEVEL,
46380: 1 WBS_SUB_LEVEL,
46381: 'PRJ' INVERT_ID
46382: from DUAL
46383: union all
46384: select 1 WBS_SUP_LEVEL,
46385: 1 WBS_SUB_LEVEL,
46386: 'WBS' INVERT_ID

Line 46387: from DUAL

46383: union all
46384: select 1 WBS_SUP_LEVEL,
46385: 1 WBS_SUB_LEVEL,
46386: 'WBS' INVERT_ID
46387: from DUAL
46388: ) top_slice
46389: where
46390: prg.STRUCT_TYPE = 'PRG' and
46391: prg.SUP_LEVEL = l_level and

Line 46450: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all

46446: from
46447: PJI_PJP_PROJ_BATCH_MAP map,
46448: PJI_XBS_DENORM_T prg,
46449: (
46450: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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,

Line 46451: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

46447: PJI_PJP_PROJ_BATCH_MAP map,
46448: PJI_XBS_DENORM_T prg,
46449: (
46450: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 46452: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

46448: PJI_XBS_DENORM_T prg,
46449: (
46450: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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

Line 46453: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual

46449: (
46450: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
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