APPS.PJI_PJP_PRG_PERF_ALL dependencies on DUAL

Line 4100: select 1 INVERT_ID from dual union all

4096: AND ver.worker_id = g_worker_id
4097: ) spread_bl
4098: ,
4099: (
4100: select 1 INVERT_ID from dual union all
4101: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
4102: select 4 INVERT_ID from dual union all
4103: select 8 INVERT_ID from dual union all
4104: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

Line 4101: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all

4097: ) spread_bl
4098: ,
4099: (
4100: select 1 INVERT_ID from dual union all
4101: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
4102: select 4 INVERT_ID from dual union all
4103: select 8 INVERT_ID from dual union all
4104: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4105: ) invert

Line 4102: select 4 INVERT_ID from dual union all

4098: ,
4099: (
4100: select 1 INVERT_ID from dual union all
4101: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
4102: select 4 INVERT_ID from dual union all
4103: select 8 INVERT_ID from dual union all
4104: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4105: ) invert
4106: ) collapse_bl

Line 4103: select 8 INVERT_ID from dual union all

4099: (
4100: select 1 INVERT_ID from dual union all
4101: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
4102: select 4 INVERT_ID from dual union all
4103: select 8 INVERT_ID from dual union all
4104: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4105: ) invert
4106: ) collapse_bl
4107: GROUP BY

Line 4104: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

4100: select 1 INVERT_ID from dual union all
4101: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
4102: select 4 INVERT_ID from dual union all
4103: select 8 INVERT_ID from dual union all
4104: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4105: ) invert
4106: ) collapse_bl
4107: GROUP BY
4108: collapse_bl.PROJECT_ID

Line 5676: decode(decode(bv.baselined_date, NULL, 'N', 'Y')||bv.current_flag,'YY', 'Y', 'N'),'X')) from dual

5672: (
5673: Select decode(
5674: bitand(l_refresh_code,g_all_plans),g_all_plans,'Y',
5675: decode( bitand(l_refresh_code,g_cb_plans),g_cb_plans,
5676: decode(decode(bv.baselined_date, NULL, 'N', 'Y')||bv.current_flag,'YY', 'Y', 'N'),'X')) from dual
5677: UNION ALL
5678: Select decode(
5679: bitand(l_refresh_code,g_all_plans),g_all_plans,'Y',
5680: decode( bitand(l_refresh_code,g_co_plans),g_co_plans,bv.current_original_flag,'X')) from dual

Line 5680: decode( bitand(l_refresh_code,g_co_plans),g_co_plans,bv.current_original_flag,'X')) from dual

5676: decode(decode(bv.baselined_date, NULL, 'N', 'Y')||bv.current_flag,'YY', 'Y', 'N'),'X')) from dual
5677: UNION ALL
5678: Select decode(
5679: bitand(l_refresh_code,g_all_plans),g_all_plans,'Y',
5680: decode( bitand(l_refresh_code,g_co_plans),g_co_plans,bv.current_original_flag,'X')) from dual
5681: )
5682: OR -- Bug#5099574 Pull Reversals for Fin plan Working Versions when l_refresh_code=16,30. ignore if l_refresh_code>=62
5683: (
5684: bv.BUDGET_STATUS_CODE in ('W','S') and

Line 5711: select decode (bitand (l_refresh_code,1),1,-1,-999) plan_version_id from dual where l_plan_type_id is null

5707: map.worker_id,map.project_id, plan_version_id, 'G' time_phased_code
5708: from
5709: PJI_PJP_PROJ_BATCH_MAP map,
5710: (
5711: select decode (bitand (l_refresh_code,1),1,-1,-999) plan_version_id from dual where l_plan_type_id is null
5712: union all
5713: select decode (bitand (l_refresh_code,g_cb_plans),g_cb_plans,-3,-999) plan_version_id from dual
5714: union all
5715: select decode (bitand (l_refresh_code,g_co_plans),g_co_plans,-4,-999) plan_version_id from dual

Line 5713: select decode (bitand (l_refresh_code,g_cb_plans),g_cb_plans,-3,-999) plan_version_id from dual

5709: PJI_PJP_PROJ_BATCH_MAP map,
5710: (
5711: select decode (bitand (l_refresh_code,1),1,-1,-999) plan_version_id from dual where l_plan_type_id is null
5712: union all
5713: select decode (bitand (l_refresh_code,g_cb_plans),g_cb_plans,-3,-999) plan_version_id from dual
5714: union all
5715: select decode (bitand (l_refresh_code,g_co_plans),g_co_plans,-4,-999) plan_version_id from dual
5716: )
5717: where map.worker_id=p_worker_id;

Line 5715: select decode (bitand (l_refresh_code,g_co_plans),g_co_plans,-4,-999) plan_version_id from dual

5711: select decode (bitand (l_refresh_code,1),1,-1,-999) plan_version_id from dual where l_plan_type_id is null
5712: union all
5713: select decode (bitand (l_refresh_code,g_cb_plans),g_cb_plans,-3,-999) plan_version_id from dual
5714: union all
5715: select decode (bitand (l_refresh_code,g_co_plans),g_co_plans,-4,-999) plan_version_id from dual
5716: )
5717: where map.worker_id=p_worker_id;
5718:
5719:

Line 6402: DUAL;

6398: 'ROLLUP_FPR_WBS - level ' || to_char(l_level - x + 1) STEP_NAME,
6399: null START_DATE,
6400: null END_DATE
6401: from
6402: DUAL;
6403:
6404: end loop;
6405:
6406: end if;

Line 7642: from DUAL union all

7638: PA_XBS_DENORM wbs,
7639: PJI_XBS_DENORM prg,
7640: (
7641: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7642: from DUAL union all
7643: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7644: from DUAL union all
7645: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7646: from DUAL union all

Line 7644: from DUAL union all

7640: (
7641: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7642: from DUAL union all
7643: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7644: from DUAL union all
7645: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7646: from DUAL union all
7647: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7648: from DUAL union all

Line 7646: from DUAL union all

7642: from DUAL union all
7643: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7644: from DUAL union all
7645: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7646: from DUAL union all
7647: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7648: from DUAL union all
7649: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7650: from DUAL union all

Line 7648: from DUAL union all

7644: from DUAL union all
7645: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7646: from DUAL union all
7647: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7648: from DUAL union all
7649: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7650: from DUAL union all
7651: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7652: from DUAL union all

Line 7650: from DUAL union all

7646: from DUAL union all
7647: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7648: from DUAL union all
7649: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7650: from DUAL union all
7651: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7652: from DUAL union all
7653: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7654: from DUAL union all

Line 7652: from DUAL union all

7648: from DUAL union all
7649: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7650: from DUAL union all
7651: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7652: from DUAL union all
7653: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7654: from DUAL union all
7655: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7656: from DUAL

Line 7654: from DUAL union all

7650: from DUAL union all
7651: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7652: from DUAL union all
7653: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7654: from DUAL union all
7655: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7656: from DUAL
7657: ) fin_plan,
7658: (

Line 7656: from DUAL

7652: from DUAL union all
7653: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7654: from DUAL union all
7655: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7656: from DUAL
7657: ) fin_plan,
7658: (
7659: select 1 WBS_SUP_LEVEL,
7660: 1 WBS_SUB_LEVEL,

Line 7662: from DUAL

7658: (
7659: select 1 WBS_SUP_LEVEL,
7660: 1 WBS_SUB_LEVEL,
7661: 'PRJ' INVERT_ID
7662: from DUAL
7663: union all
7664: select 1 WBS_SUP_LEVEL,
7665: 1 WBS_SUB_LEVEL,
7666: 'WBS' INVERT_ID

Line 7667: from DUAL

7663: union all
7664: select 1 WBS_SUP_LEVEL,
7665: 1 WBS_SUB_LEVEL,
7666: 'WBS' INVERT_ID
7667: from DUAL
7668: ) top_slice
7669: where
7670: prg.STRUCT_TYPE = 'PRG' and
7671: prg.SUP_LEVEL = l_level and

Line 7797: from DUAL union all

7793: (
7794: select 'Y' CB_FLAG,
7795: 'N' CO_FLAG,
7796: -3 PLAN_VERSION_ID
7797: from DUAL union all
7798: select 'N' CB_FLAG,
7799: 'Y' CO_FLAG,
7800: -4 PLAN_VERSION_ID
7801: from DUAL union all

Line 7801: from DUAL union all

7797: from DUAL union all
7798: select 'N' CB_FLAG,
7799: 'Y' CO_FLAG,
7800: -4 PLAN_VERSION_ID
7801: from DUAL union all
7802: select 'Y' CB_FLAG,
7803: 'Y' CO_FLAG,
7804: -3 PLAN_VERSION_ID
7805: from DUAL union all

Line 7805: from DUAL union all

7801: from DUAL union all
7802: select 'Y' CB_FLAG,
7803: 'Y' CO_FLAG,
7804: -3 PLAN_VERSION_ID
7805: from DUAL union all
7806: select 'Y' CB_FLAG,
7807: 'Y' CO_FLAG,
7808: -4 PLAN_VERSION_ID
7809: from DUAL

Line 7809: from DUAL

7805: from DUAL union all
7806: select 'Y' CB_FLAG,
7807: 'Y' CO_FLAG,
7808: -4 PLAN_VERSION_ID
7809: from DUAL
7810: ) fin_plan
7811: where
7812: prg.STRUCT_TYPE = 'PRG' and
7813: prg.SUP_LEVEL = l_level and

Line 7948: from DUAL union all

7944: PJI_XBS_DENORM prg,
7945: PJI_FP_XBS_ACCUM_F fpr,
7946: (
7947: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7948: from DUAL union all
7949: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7950: from DUAL union all
7951: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7952: from DUAL union all

Line 7950: from DUAL union all

7946: (
7947: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7948: from DUAL union all
7949: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7950: from DUAL union all
7951: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7952: from DUAL union all
7953: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7954: from DUAL union all

Line 7952: from DUAL union all

7948: from DUAL union all
7949: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7950: from DUAL union all
7951: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7952: from DUAL union all
7953: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7954: from DUAL union all
7955: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7956: from DUAL union all

Line 7954: from DUAL union all

7950: from DUAL union all
7951: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7952: from DUAL union all
7953: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7954: from DUAL union all
7955: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7956: from DUAL union all
7957: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7958: from DUAL union all

Line 7956: from DUAL union all

7952: from DUAL union all
7953: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7954: from DUAL union all
7955: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7956: from DUAL union all
7957: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7958: from DUAL union all
7959: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7960: from DUAL union all

Line 7958: from DUAL union all

7954: from DUAL union all
7955: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7956: from DUAL union all
7957: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7958: from DUAL union all
7959: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7960: from DUAL union all
7961: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7962: from DUAL

Line 7960: from DUAL union all

7956: from DUAL union all
7957: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7958: from DUAL union all
7959: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7960: from DUAL union all
7961: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7962: from DUAL
7963: ) fin_plan,
7964: (

Line 7962: from DUAL

7958: from DUAL union all
7959: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7960: from DUAL union all
7961: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7962: from DUAL
7963: ) fin_plan,
7964: (
7965: select 1 WBS_SUP_LEVEL,
7966: 1 WBS_SUB_LEVEL,

Line 7968: from DUAL

7964: (
7965: select 1 WBS_SUP_LEVEL,
7966: 1 WBS_SUB_LEVEL,
7967: 'PRJ' INVERT_ID
7968: from DUAL
7969: union all
7970: select 1 WBS_SUP_LEVEL,
7971: 1 WBS_SUB_LEVEL,
7972: 'WBS' INVERT_ID

Line 7973: from DUAL

7969: union all
7970: select 1 WBS_SUP_LEVEL,
7971: 1 WBS_SUB_LEVEL,
7972: 'WBS' INVERT_ID
7973: from DUAL
7974: ) top_slice
7975: where
7976: prg.STRUCT_TYPE = 'PRG' and
7977: prg.SUP_LEVEL = l_level and

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

8030: from
8031: PJI_PJP_PROJ_BATCH_MAP map,
8032: PJI_XBS_DENORM prg,
8033: (
8034: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8035: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8036: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8037: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
8038: ) invert,

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

8031: PJI_PJP_PROJ_BATCH_MAP map,
8032: PJI_XBS_DENORM prg,
8033: (
8034: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8035: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8036: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8037: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
8038: ) invert,
8039: PJI_XBS_DENORM_DELTA prg_delta

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

8032: PJI_XBS_DENORM prg,
8033: (
8034: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8035: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8036: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8037: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
8038: ) invert,
8039: PJI_XBS_DENORM_DELTA prg_delta
8040: where

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

8033: (
8034: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8035: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8036: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8037: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
8038: ) invert,
8039: PJI_XBS_DENORM_DELTA prg_delta
8040: where
8041: prg.STRUCT_TYPE = 'PRG' and

Line 9136: from DUAL union all

9132: PA_XBS_DENORM wbs,
9133: PJI_XBS_DENORM prg,
9134: (
9135: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9136: from DUAL union all
9137: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9138: from DUAL union all
9139: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9140: from DUAL union all

Line 9138: from DUAL union all

9134: (
9135: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9136: from DUAL union all
9137: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9138: from DUAL union all
9139: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9140: from DUAL union all
9141: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9142: from DUAL union all

Line 9140: from DUAL union all

9136: from DUAL union all
9137: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9138: from DUAL union all
9139: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9140: from DUAL union all
9141: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9142: from DUAL union all
9143: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9144: from DUAL union all

Line 9142: from DUAL union all

9138: from DUAL union all
9139: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9140: from DUAL union all
9141: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9142: from DUAL union all
9143: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9144: from DUAL union all
9145: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9146: from DUAL union all

Line 9144: from DUAL union all

9140: from DUAL union all
9141: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9142: from DUAL union all
9143: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9144: from DUAL union all
9145: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9146: from DUAL union all
9147: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9148: from DUAL union all

Line 9146: from DUAL union all

9142: from DUAL union all
9143: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9144: from DUAL union all
9145: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9146: from DUAL union all
9147: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9148: from DUAL union all
9149: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9150: from DUAL

Line 9148: from DUAL union all

9144: from DUAL union all
9145: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9146: from DUAL union all
9147: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9148: from DUAL union all
9149: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9150: from DUAL
9151: ) fin_plan,
9152: (

Line 9150: from DUAL

9146: from DUAL union all
9147: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9148: from DUAL union all
9149: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9150: from DUAL
9151: ) fin_plan,
9152: (
9153: select 1 WBS_SUP_LEVEL,
9154: 1 WBS_SUB_LEVEL,

Line 9156: from DUAL

9152: (
9153: select 1 WBS_SUP_LEVEL,
9154: 1 WBS_SUB_LEVEL,
9155: 'PRJ' INVERT_ID
9156: from DUAL
9157: union all
9158: select 1 WBS_SUP_LEVEL,
9159: 1 WBS_SUB_LEVEL,
9160: 'WBS' INVERT_ID

Line 9161: from DUAL

9157: union all
9158: select 1 WBS_SUP_LEVEL,
9159: 1 WBS_SUB_LEVEL,
9160: 'WBS' INVERT_ID
9161: from DUAL
9162: ) top_slice
9163: where
9164: prg.STRUCT_TYPE = 'PRG' and
9165: prg.SUP_LEVEL = l_level and

Line 9291: from DUAL union all

9287: (
9288: select 'Y' CB_FLAG,
9289: 'N' CO_FLAG,
9290: -3 PLAN_VERSION_ID
9291: from DUAL union all
9292: select 'N' CB_FLAG,
9293: 'Y' CO_FLAG,
9294: -4 PLAN_VERSION_ID
9295: from DUAL union all

Line 9295: from DUAL union all

9291: from DUAL union all
9292: select 'N' CB_FLAG,
9293: 'Y' CO_FLAG,
9294: -4 PLAN_VERSION_ID
9295: from DUAL union all
9296: select 'Y' CB_FLAG,
9297: 'Y' CO_FLAG,
9298: -3 PLAN_VERSION_ID
9299: from DUAL union all

Line 9299: from DUAL union all

9295: from DUAL union all
9296: select 'Y' CB_FLAG,
9297: 'Y' CO_FLAG,
9298: -3 PLAN_VERSION_ID
9299: from DUAL union all
9300: select 'Y' CB_FLAG,
9301: 'Y' CO_FLAG,
9302: -4 PLAN_VERSION_ID
9303: from DUAL

Line 9303: from DUAL

9299: from DUAL union all
9300: select 'Y' CB_FLAG,
9301: 'Y' CO_FLAG,
9302: -4 PLAN_VERSION_ID
9303: from DUAL
9304: ) fin_plan
9305: where
9306: prg.STRUCT_TYPE = 'PRG' and
9307: prg.SUP_LEVEL = l_level and

Line 9442: from DUAL union all

9438: PJI_XBS_DENORM prg,
9439: PJI_FP_XBS_ACCUM_F fpr,
9440: (
9441: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9442: from DUAL union all
9443: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9444: from DUAL union all
9445: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9446: from DUAL union all

Line 9444: from DUAL union all

9440: (
9441: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9442: from DUAL union all
9443: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9444: from DUAL union all
9445: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9446: from DUAL union all
9447: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9448: from DUAL union all

Line 9446: from DUAL union all

9442: from DUAL union all
9443: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9444: from DUAL union all
9445: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9446: from DUAL union all
9447: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9448: from DUAL union all
9449: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9450: from DUAL union all

Line 9448: from DUAL union all

9444: from DUAL union all
9445: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9446: from DUAL union all
9447: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9448: from DUAL union all
9449: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9450: from DUAL union all
9451: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9452: from DUAL union all

Line 9450: from DUAL union all

9446: from DUAL union all
9447: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9448: from DUAL union all
9449: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9450: from DUAL union all
9451: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9452: from DUAL union all
9453: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9454: from DUAL union all

Line 9452: from DUAL union all

9448: from DUAL union all
9449: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9450: from DUAL union all
9451: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9452: from DUAL union all
9453: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9454: from DUAL union all
9455: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9456: from DUAL

Line 9454: from DUAL union all

9450: from DUAL union all
9451: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9452: from DUAL union all
9453: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9454: from DUAL union all
9455: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9456: from DUAL
9457: ) fin_plan,
9458: (

Line 9456: from DUAL

9452: from DUAL union all
9453: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9454: from DUAL union all
9455: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9456: from DUAL
9457: ) fin_plan,
9458: (
9459: select 1 WBS_SUP_LEVEL,
9460: 1 WBS_SUB_LEVEL,

Line 9462: from DUAL

9458: (
9459: select 1 WBS_SUP_LEVEL,
9460: 1 WBS_SUB_LEVEL,
9461: 'PRJ' INVERT_ID
9462: from DUAL
9463: union all
9464: select 1 WBS_SUP_LEVEL,
9465: 1 WBS_SUB_LEVEL,
9466: 'WBS' INVERT_ID

Line 9467: from DUAL

9463: union all
9464: select 1 WBS_SUP_LEVEL,
9465: 1 WBS_SUB_LEVEL,
9466: 'WBS' INVERT_ID
9467: from DUAL
9468: ) top_slice
9469: where
9470: prg.STRUCT_TYPE = 'PRG' and
9471: prg.SUP_LEVEL = l_level and

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

9524: from
9525: PJI_PJP_PROJ_BATCH_MAP map,
9526: PJI_XBS_DENORM prg,
9527: (
9528: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9529: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
9530: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9531: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
9532: ) invert,

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

9525: PJI_PJP_PROJ_BATCH_MAP map,
9526: PJI_XBS_DENORM prg,
9527: (
9528: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9529: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
9530: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9531: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
9532: ) invert,
9533: PJI_XBS_DENORM_DELTA prg_delta

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

9526: PJI_XBS_DENORM prg,
9527: (
9528: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9529: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
9530: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9531: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
9532: ) invert,
9533: PJI_XBS_DENORM_DELTA prg_delta
9534: where

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

9527: (
9528: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9529: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
9530: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9531: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
9532: ) invert,
9533: PJI_XBS_DENORM_DELTA prg_delta
9534: where
9535: prg.STRUCT_TYPE = 'PRG' and

Line 10630: from DUAL union all

10626: PA_XBS_DENORM wbs,
10627: PJI_XBS_DENORM prg,
10628: (
10629: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10630: from DUAL union all
10631: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10632: from DUAL union all
10633: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10634: from DUAL union all

Line 10632: from DUAL union all

10628: (
10629: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10630: from DUAL union all
10631: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10632: from DUAL union all
10633: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10634: from DUAL union all
10635: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10636: from DUAL union all

Line 10634: from DUAL union all

10630: from DUAL union all
10631: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10632: from DUAL union all
10633: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10634: from DUAL union all
10635: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10636: from DUAL union all
10637: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10638: from DUAL union all

Line 10636: from DUAL union all

10632: from DUAL union all
10633: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10634: from DUAL union all
10635: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10636: from DUAL union all
10637: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10638: from DUAL union all
10639: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10640: from DUAL union all

Line 10638: from DUAL union all

10634: from DUAL union all
10635: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10636: from DUAL union all
10637: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10638: from DUAL union all
10639: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10640: from DUAL union all
10641: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10642: from DUAL union all

Line 10640: from DUAL union all

10636: from DUAL union all
10637: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10638: from DUAL union all
10639: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10640: from DUAL union all
10641: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10642: from DUAL union all
10643: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10644: from DUAL

Line 10642: from DUAL union all

10638: from DUAL union all
10639: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10640: from DUAL union all
10641: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10642: from DUAL union all
10643: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10644: from DUAL
10645: ) fin_plan,
10646: (

Line 10644: from DUAL

10640: from DUAL union all
10641: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10642: from DUAL union all
10643: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10644: from DUAL
10645: ) fin_plan,
10646: (
10647: select 1 WBS_SUP_LEVEL,
10648: 1 WBS_SUB_LEVEL,

Line 10650: from DUAL

10646: (
10647: select 1 WBS_SUP_LEVEL,
10648: 1 WBS_SUB_LEVEL,
10649: 'PRJ' INVERT_ID
10650: from DUAL
10651: union all
10652: select 1 WBS_SUP_LEVEL,
10653: 1 WBS_SUB_LEVEL,
10654: 'WBS' INVERT_ID

Line 10655: from DUAL

10651: union all
10652: select 1 WBS_SUP_LEVEL,
10653: 1 WBS_SUB_LEVEL,
10654: 'WBS' INVERT_ID
10655: from DUAL
10656: ) top_slice
10657: where
10658: prg.STRUCT_TYPE = 'PRG' and
10659: prg.SUP_LEVEL = l_level and

Line 10785: from DUAL union all

10781: (
10782: select 'Y' CB_FLAG,
10783: 'N' CO_FLAG,
10784: -3 PLAN_VERSION_ID
10785: from DUAL union all
10786: select 'N' CB_FLAG,
10787: 'Y' CO_FLAG,
10788: -4 PLAN_VERSION_ID
10789: from DUAL union all

Line 10789: from DUAL union all

10785: from DUAL union all
10786: select 'N' CB_FLAG,
10787: 'Y' CO_FLAG,
10788: -4 PLAN_VERSION_ID
10789: from DUAL union all
10790: select 'Y' CB_FLAG,
10791: 'Y' CO_FLAG,
10792: -3 PLAN_VERSION_ID
10793: from DUAL union all

Line 10793: from DUAL union all

10789: from DUAL union all
10790: select 'Y' CB_FLAG,
10791: 'Y' CO_FLAG,
10792: -3 PLAN_VERSION_ID
10793: from DUAL union all
10794: select 'Y' CB_FLAG,
10795: 'Y' CO_FLAG,
10796: -4 PLAN_VERSION_ID
10797: from DUAL

Line 10797: from DUAL

10793: from DUAL union all
10794: select 'Y' CB_FLAG,
10795: 'Y' CO_FLAG,
10796: -4 PLAN_VERSION_ID
10797: from DUAL
10798: ) fin_plan
10799: where
10800: prg.STRUCT_TYPE = 'PRG' and
10801: prg.SUP_LEVEL = l_level and

Line 10936: from DUAL union all

10932: PJI_XBS_DENORM prg,
10933: PJI_FP_XBS_ACCUM_F fpr,
10934: (
10935: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10936: from DUAL union all
10937: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10938: from DUAL union all
10939: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10940: from DUAL union all

Line 10938: from DUAL union all

10934: (
10935: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10936: from DUAL union all
10937: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10938: from DUAL union all
10939: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10940: from DUAL union all
10941: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10942: from DUAL union all

Line 10940: from DUAL union all

10936: from DUAL union all
10937: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10938: from DUAL union all
10939: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10940: from DUAL union all
10941: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10942: from DUAL union all
10943: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10944: from DUAL union all

Line 10942: from DUAL union all

10938: from DUAL union all
10939: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10940: from DUAL union all
10941: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10942: from DUAL union all
10943: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10944: from DUAL union all
10945: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10946: from DUAL union all

Line 10944: from DUAL union all

10940: from DUAL union all
10941: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10942: from DUAL union all
10943: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10944: from DUAL union all
10945: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10946: from DUAL union all
10947: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10948: from DUAL union all

Line 10946: from DUAL union all

10942: from DUAL union all
10943: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10944: from DUAL union all
10945: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10946: from DUAL union all
10947: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10948: from DUAL union all
10949: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10950: from DUAL

Line 10948: from DUAL union all

10944: from DUAL union all
10945: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10946: from DUAL union all
10947: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10948: from DUAL union all
10949: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10950: from DUAL
10951: ) fin_plan,
10952: (

Line 10950: from DUAL

10946: from DUAL union all
10947: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10948: from DUAL union all
10949: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10950: from DUAL
10951: ) fin_plan,
10952: (
10953: select 1 WBS_SUP_LEVEL,
10954: 1 WBS_SUB_LEVEL,

Line 10956: from DUAL

10952: (
10953: select 1 WBS_SUP_LEVEL,
10954: 1 WBS_SUB_LEVEL,
10955: 'PRJ' INVERT_ID
10956: from DUAL
10957: union all
10958: select 1 WBS_SUP_LEVEL,
10959: 1 WBS_SUB_LEVEL,
10960: 'WBS' INVERT_ID

Line 10961: from DUAL

10957: union all
10958: select 1 WBS_SUP_LEVEL,
10959: 1 WBS_SUB_LEVEL,
10960: 'WBS' INVERT_ID
10961: from DUAL
10962: ) top_slice
10963: where
10964: prg.STRUCT_TYPE = 'PRG' and
10965: prg.SUP_LEVEL = l_level and

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

11018: from
11019: PJI_PJP_PROJ_BATCH_MAP map,
11020: PJI_XBS_DENORM prg,
11021: (
11022: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11023: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
11024: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11025: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
11026: ) invert,

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

11019: PJI_PJP_PROJ_BATCH_MAP map,
11020: PJI_XBS_DENORM prg,
11021: (
11022: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11023: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
11024: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11025: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
11026: ) invert,
11027: PJI_XBS_DENORM_DELTA prg_delta

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

11020: PJI_XBS_DENORM prg,
11021: (
11022: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11023: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
11024: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11025: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
11026: ) invert,
11027: PJI_XBS_DENORM_DELTA prg_delta
11028: where

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

11021: (
11022: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11023: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
11024: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
11025: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
11026: ) invert,
11027: PJI_XBS_DENORM_DELTA prg_delta
11028: where
11029: prg.STRUCT_TYPE = 'PRG' and

Line 12123: from DUAL union all

12119: PA_XBS_DENORM wbs,
12120: PJI_XBS_DENORM prg,
12121: (
12122: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12123: from DUAL union all
12124: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12125: from DUAL union all
12126: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12127: from DUAL union all

Line 12125: from DUAL union all

12121: (
12122: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12123: from DUAL union all
12124: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12125: from DUAL union all
12126: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12127: from DUAL union all
12128: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12129: from DUAL union all

Line 12127: from DUAL union all

12123: from DUAL union all
12124: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12125: from DUAL union all
12126: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12127: from DUAL union all
12128: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12129: from DUAL union all
12130: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12131: from DUAL union all

Line 12129: from DUAL union all

12125: from DUAL union all
12126: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12127: from DUAL union all
12128: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12129: from DUAL union all
12130: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12131: from DUAL union all
12132: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12133: from DUAL union all

Line 12131: from DUAL union all

12127: from DUAL union all
12128: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12129: from DUAL union all
12130: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12131: from DUAL union all
12132: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12133: from DUAL union all
12134: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12135: from DUAL union all

Line 12133: from DUAL union all

12129: from DUAL union all
12130: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12131: from DUAL union all
12132: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12133: from DUAL union all
12134: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12135: from DUAL union all
12136: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12137: from DUAL

Line 12135: from DUAL union all

12131: from DUAL union all
12132: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12133: from DUAL union all
12134: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12135: from DUAL union all
12136: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12137: from DUAL
12138: ) fin_plan,
12139: (

Line 12137: from DUAL

12133: from DUAL union all
12134: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12135: from DUAL union all
12136: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12137: from DUAL
12138: ) fin_plan,
12139: (
12140: select 1 WBS_SUP_LEVEL,
12141: 1 WBS_SUB_LEVEL,

Line 12143: from DUAL

12139: (
12140: select 1 WBS_SUP_LEVEL,
12141: 1 WBS_SUB_LEVEL,
12142: 'PRJ' INVERT_ID
12143: from DUAL
12144: union all
12145: select 1 WBS_SUP_LEVEL,
12146: 1 WBS_SUB_LEVEL,
12147: 'WBS' INVERT_ID

Line 12148: from DUAL

12144: union all
12145: select 1 WBS_SUP_LEVEL,
12146: 1 WBS_SUB_LEVEL,
12147: 'WBS' INVERT_ID
12148: from DUAL
12149: ) top_slice
12150: where
12151: prg.STRUCT_TYPE = 'PRG' and
12152: prg.SUP_LEVEL = l_level and

Line 12278: from DUAL union all

12274: (
12275: select 'Y' CB_FLAG,
12276: 'N' CO_FLAG,
12277: -3 PLAN_VERSION_ID
12278: from DUAL union all
12279: select 'N' CB_FLAG,
12280: 'Y' CO_FLAG,
12281: -4 PLAN_VERSION_ID
12282: from DUAL union all

Line 12282: from DUAL union all

12278: from DUAL union all
12279: select 'N' CB_FLAG,
12280: 'Y' CO_FLAG,
12281: -4 PLAN_VERSION_ID
12282: from DUAL union all
12283: select 'Y' CB_FLAG,
12284: 'Y' CO_FLAG,
12285: -3 PLAN_VERSION_ID
12286: from DUAL union all

Line 12286: from DUAL union all

12282: from DUAL union all
12283: select 'Y' CB_FLAG,
12284: 'Y' CO_FLAG,
12285: -3 PLAN_VERSION_ID
12286: from DUAL union all
12287: select 'Y' CB_FLAG,
12288: 'Y' CO_FLAG,
12289: -4 PLAN_VERSION_ID
12290: from DUAL

Line 12290: from DUAL

12286: from DUAL union all
12287: select 'Y' CB_FLAG,
12288: 'Y' CO_FLAG,
12289: -4 PLAN_VERSION_ID
12290: from DUAL
12291: ) fin_plan
12292: where
12293: prg.STRUCT_TYPE = 'PRG' and
12294: prg.SUP_LEVEL = l_level and

Line 12429: from DUAL union all

12425: PJI_XBS_DENORM prg,
12426: PJI_FP_XBS_ACCUM_F fpr,
12427: (
12428: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12429: from DUAL union all
12430: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12431: from DUAL union all
12432: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12433: from DUAL union all

Line 12431: from DUAL union all

12427: (
12428: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12429: from DUAL union all
12430: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12431: from DUAL union all
12432: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12433: from DUAL union all
12434: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12435: from DUAL union all

Line 12433: from DUAL union all

12429: from DUAL union all
12430: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12431: from DUAL union all
12432: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12433: from DUAL union all
12434: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12435: from DUAL union all
12436: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12437: from DUAL union all

Line 12435: from DUAL union all

12431: from DUAL union all
12432: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12433: from DUAL union all
12434: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12435: from DUAL union all
12436: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12437: from DUAL union all
12438: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12439: from DUAL union all

Line 12437: from DUAL union all

12433: from DUAL union all
12434: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12435: from DUAL union all
12436: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12437: from DUAL union all
12438: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12439: from DUAL union all
12440: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12441: from DUAL union all

Line 12439: from DUAL union all

12435: from DUAL union all
12436: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12437: from DUAL union all
12438: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12439: from DUAL union all
12440: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12441: from DUAL union all
12442: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12443: from DUAL

Line 12441: from DUAL union all

12437: from DUAL union all
12438: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12439: from DUAL union all
12440: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12441: from DUAL union all
12442: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12443: from DUAL
12444: ) fin_plan,
12445: (

Line 12443: from DUAL

12439: from DUAL union all
12440: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12441: from DUAL union all
12442: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12443: from DUAL
12444: ) fin_plan,
12445: (
12446: select 1 WBS_SUP_LEVEL,
12447: 1 WBS_SUB_LEVEL,

Line 12449: from DUAL

12445: (
12446: select 1 WBS_SUP_LEVEL,
12447: 1 WBS_SUB_LEVEL,
12448: 'PRJ' INVERT_ID
12449: from DUAL
12450: union all
12451: select 1 WBS_SUP_LEVEL,
12452: 1 WBS_SUB_LEVEL,
12453: 'WBS' INVERT_ID

Line 12454: from DUAL

12450: union all
12451: select 1 WBS_SUP_LEVEL,
12452: 1 WBS_SUB_LEVEL,
12453: 'WBS' INVERT_ID
12454: from DUAL
12455: ) top_slice
12456: where
12457: prg.STRUCT_TYPE = 'PRG' and
12458: prg.SUP_LEVEL = l_level and

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

12511: from
12512: PJI_PJP_PROJ_BATCH_MAP map,
12513: PJI_XBS_DENORM prg,
12514: (
12515: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12516: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
12517: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12518: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
12519: ) invert,

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

12512: PJI_PJP_PROJ_BATCH_MAP map,
12513: PJI_XBS_DENORM prg,
12514: (
12515: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12516: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
12517: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12518: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
12519: ) invert,
12520: PJI_XBS_DENORM_DELTA prg_delta

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

12513: PJI_XBS_DENORM prg,
12514: (
12515: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12516: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
12517: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12518: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
12519: ) invert,
12520: PJI_XBS_DENORM_DELTA prg_delta
12521: where

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

12514: (
12515: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12516: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
12517: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12518: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
12519: ) invert,
12520: PJI_XBS_DENORM_DELTA prg_delta
12521: where
12522: prg.STRUCT_TYPE = 'PRG' and

Line 13617: from DUAL union all

13613: PA_XBS_DENORM wbs,
13614: PJI_XBS_DENORM prg,
13615: (
13616: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13617: from DUAL union all
13618: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13619: from DUAL union all
13620: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13621: from DUAL union all

Line 13619: from DUAL union all

13615: (
13616: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13617: from DUAL union all
13618: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13619: from DUAL union all
13620: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13621: from DUAL union all
13622: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13623: from DUAL union all

Line 13621: from DUAL union all

13617: from DUAL union all
13618: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13619: from DUAL union all
13620: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13621: from DUAL union all
13622: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13623: from DUAL union all
13624: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13625: from DUAL union all

Line 13623: from DUAL union all

13619: from DUAL union all
13620: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13621: from DUAL union all
13622: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13623: from DUAL union all
13624: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13625: from DUAL union all
13626: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13627: from DUAL union all

Line 13625: from DUAL union all

13621: from DUAL union all
13622: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13623: from DUAL union all
13624: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13625: from DUAL union all
13626: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13627: from DUAL union all
13628: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13629: from DUAL union all

Line 13627: from DUAL union all

13623: from DUAL union all
13624: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13625: from DUAL union all
13626: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13627: from DUAL union all
13628: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13629: from DUAL union all
13630: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13631: from DUAL

Line 13629: from DUAL union all

13625: from DUAL union all
13626: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13627: from DUAL union all
13628: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13629: from DUAL union all
13630: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13631: from DUAL
13632: ) fin_plan,
13633: (

Line 13631: from DUAL

13627: from DUAL union all
13628: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13629: from DUAL union all
13630: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13631: from DUAL
13632: ) fin_plan,
13633: (
13634: select 1 WBS_SUP_LEVEL,
13635: 1 WBS_SUB_LEVEL,

Line 13637: from DUAL

13633: (
13634: select 1 WBS_SUP_LEVEL,
13635: 1 WBS_SUB_LEVEL,
13636: 'PRJ' INVERT_ID
13637: from DUAL
13638: union all
13639: select 1 WBS_SUP_LEVEL,
13640: 1 WBS_SUB_LEVEL,
13641: 'WBS' INVERT_ID

Line 13642: from DUAL

13638: union all
13639: select 1 WBS_SUP_LEVEL,
13640: 1 WBS_SUB_LEVEL,
13641: 'WBS' INVERT_ID
13642: from DUAL
13643: ) top_slice
13644: where
13645: prg.STRUCT_TYPE = 'PRG' and
13646: prg.SUP_LEVEL = l_level and

Line 13772: from DUAL union all

13768: (
13769: select 'Y' CB_FLAG,
13770: 'N' CO_FLAG,
13771: -3 PLAN_VERSION_ID
13772: from DUAL union all
13773: select 'N' CB_FLAG,
13774: 'Y' CO_FLAG,
13775: -4 PLAN_VERSION_ID
13776: from DUAL union all

Line 13776: from DUAL union all

13772: from DUAL union all
13773: select 'N' CB_FLAG,
13774: 'Y' CO_FLAG,
13775: -4 PLAN_VERSION_ID
13776: from DUAL union all
13777: select 'Y' CB_FLAG,
13778: 'Y' CO_FLAG,
13779: -3 PLAN_VERSION_ID
13780: from DUAL union all

Line 13780: from DUAL union all

13776: from DUAL union all
13777: select 'Y' CB_FLAG,
13778: 'Y' CO_FLAG,
13779: -3 PLAN_VERSION_ID
13780: from DUAL union all
13781: select 'Y' CB_FLAG,
13782: 'Y' CO_FLAG,
13783: -4 PLAN_VERSION_ID
13784: from DUAL

Line 13784: from DUAL

13780: from DUAL union all
13781: select 'Y' CB_FLAG,
13782: 'Y' CO_FLAG,
13783: -4 PLAN_VERSION_ID
13784: from DUAL
13785: ) fin_plan
13786: where
13787: prg.STRUCT_TYPE = 'PRG' and
13788: prg.SUP_LEVEL = l_level and

Line 13923: from DUAL union all

13919: PJI_XBS_DENORM prg,
13920: PJI_FP_XBS_ACCUM_F fpr,
13921: (
13922: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13923: from DUAL union all
13924: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13925: from DUAL union all
13926: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13927: from DUAL union all

Line 13925: from DUAL union all

13921: (
13922: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13923: from DUAL union all
13924: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13925: from DUAL union all
13926: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13927: from DUAL union all
13928: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13929: from DUAL union all

Line 13927: from DUAL union all

13923: from DUAL union all
13924: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13925: from DUAL union all
13926: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13927: from DUAL union all
13928: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13929: from DUAL union all
13930: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13931: from DUAL union all

Line 13929: from DUAL union all

13925: from DUAL union all
13926: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13927: from DUAL union all
13928: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13929: from DUAL union all
13930: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13931: from DUAL union all
13932: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13933: from DUAL union all

Line 13931: from DUAL union all

13927: from DUAL union all
13928: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13929: from DUAL union all
13930: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13931: from DUAL union all
13932: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13933: from DUAL union all
13934: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13935: from DUAL union all

Line 13933: from DUAL union all

13929: from DUAL union all
13930: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13931: from DUAL union all
13932: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13933: from DUAL union all
13934: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13935: from DUAL union all
13936: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13937: from DUAL

Line 13935: from DUAL union all

13931: from DUAL union all
13932: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13933: from DUAL union all
13934: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13935: from DUAL union all
13936: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13937: from DUAL
13938: ) fin_plan,
13939: (

Line 13937: from DUAL

13933: from DUAL union all
13934: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13935: from DUAL union all
13936: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13937: from DUAL
13938: ) fin_plan,
13939: (
13940: select 1 WBS_SUP_LEVEL,
13941: 1 WBS_SUB_LEVEL,

Line 13943: from DUAL

13939: (
13940: select 1 WBS_SUP_LEVEL,
13941: 1 WBS_SUB_LEVEL,
13942: 'PRJ' INVERT_ID
13943: from DUAL
13944: union all
13945: select 1 WBS_SUP_LEVEL,
13946: 1 WBS_SUB_LEVEL,
13947: 'WBS' INVERT_ID

Line 13948: from DUAL

13944: union all
13945: select 1 WBS_SUP_LEVEL,
13946: 1 WBS_SUB_LEVEL,
13947: 'WBS' INVERT_ID
13948: from DUAL
13949: ) top_slice
13950: where
13951: prg.STRUCT_TYPE = 'PRG' and
13952: prg.SUP_LEVEL = l_level and

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

14005: from
14006: PJI_PJP_PROJ_BATCH_MAP map,
14007: PJI_XBS_DENORM prg,
14008: (
14009: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14010: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
14011: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14012: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
14013: ) invert,

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

14006: PJI_PJP_PROJ_BATCH_MAP map,
14007: PJI_XBS_DENORM prg,
14008: (
14009: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14010: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
14011: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14012: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
14013: ) invert,
14014: PJI_XBS_DENORM_DELTA prg_delta

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

14007: PJI_XBS_DENORM prg,
14008: (
14009: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14010: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
14011: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14012: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
14013: ) invert,
14014: PJI_XBS_DENORM_DELTA prg_delta
14015: where

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

14008: (
14009: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14010: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
14011: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14012: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
14013: ) invert,
14014: PJI_XBS_DENORM_DELTA prg_delta
14015: where
14016: prg.STRUCT_TYPE = 'PRG' and

Line 15110: from DUAL union all

15106: PA_XBS_DENORM wbs,
15107: PJI_XBS_DENORM prg,
15108: (
15109: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15110: from DUAL union all
15111: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15112: from DUAL union all
15113: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15114: from DUAL union all

Line 15112: from DUAL union all

15108: (
15109: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15110: from DUAL union all
15111: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15112: from DUAL union all
15113: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15114: from DUAL union all
15115: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15116: from DUAL union all

Line 15114: from DUAL union all

15110: from DUAL union all
15111: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15112: from DUAL union all
15113: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15114: from DUAL union all
15115: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15116: from DUAL union all
15117: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15118: from DUAL union all

Line 15116: from DUAL union all

15112: from DUAL union all
15113: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15114: from DUAL union all
15115: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15116: from DUAL union all
15117: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15118: from DUAL union all
15119: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15120: from DUAL union all

Line 15118: from DUAL union all

15114: from DUAL union all
15115: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15116: from DUAL union all
15117: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15118: from DUAL union all
15119: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15120: from DUAL union all
15121: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15122: from DUAL union all

Line 15120: from DUAL union all

15116: from DUAL union all
15117: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15118: from DUAL union all
15119: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15120: from DUAL union all
15121: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15122: from DUAL union all
15123: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15124: from DUAL

Line 15122: from DUAL union all

15118: from DUAL union all
15119: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15120: from DUAL union all
15121: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15122: from DUAL union all
15123: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15124: from DUAL
15125: ) fin_plan,
15126: (

Line 15124: from DUAL

15120: from DUAL union all
15121: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15122: from DUAL union all
15123: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15124: from DUAL
15125: ) fin_plan,
15126: (
15127: select 1 WBS_SUP_LEVEL,
15128: 1 WBS_SUB_LEVEL,

Line 15130: from DUAL

15126: (
15127: select 1 WBS_SUP_LEVEL,
15128: 1 WBS_SUB_LEVEL,
15129: 'PRJ' INVERT_ID
15130: from DUAL
15131: union all
15132: select 1 WBS_SUP_LEVEL,
15133: 1 WBS_SUB_LEVEL,
15134: 'WBS' INVERT_ID

Line 15135: from DUAL

15131: union all
15132: select 1 WBS_SUP_LEVEL,
15133: 1 WBS_SUB_LEVEL,
15134: 'WBS' INVERT_ID
15135: from DUAL
15136: ) top_slice
15137: where
15138: prg.STRUCT_TYPE = 'PRG' and
15139: prg.SUP_LEVEL = l_level and

Line 15265: from DUAL union all

15261: (
15262: select 'Y' CB_FLAG,
15263: 'N' CO_FLAG,
15264: -3 PLAN_VERSION_ID
15265: from DUAL union all
15266: select 'N' CB_FLAG,
15267: 'Y' CO_FLAG,
15268: -4 PLAN_VERSION_ID
15269: from DUAL union all

Line 15269: from DUAL union all

15265: from DUAL union all
15266: select 'N' CB_FLAG,
15267: 'Y' CO_FLAG,
15268: -4 PLAN_VERSION_ID
15269: from DUAL union all
15270: select 'Y' CB_FLAG,
15271: 'Y' CO_FLAG,
15272: -3 PLAN_VERSION_ID
15273: from DUAL union all

Line 15273: from DUAL union all

15269: from DUAL union all
15270: select 'Y' CB_FLAG,
15271: 'Y' CO_FLAG,
15272: -3 PLAN_VERSION_ID
15273: from DUAL union all
15274: select 'Y' CB_FLAG,
15275: 'Y' CO_FLAG,
15276: -4 PLAN_VERSION_ID
15277: from DUAL

Line 15277: from DUAL

15273: from DUAL union all
15274: select 'Y' CB_FLAG,
15275: 'Y' CO_FLAG,
15276: -4 PLAN_VERSION_ID
15277: from DUAL
15278: ) fin_plan
15279: where
15280: prg.STRUCT_TYPE = 'PRG' and
15281: prg.SUP_LEVEL = l_level and

Line 15416: from DUAL union all

15412: PJI_XBS_DENORM prg,
15413: PJI_FP_XBS_ACCUM_F fpr,
15414: (
15415: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15416: from DUAL union all
15417: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15418: from DUAL union all
15419: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15420: from DUAL union all

Line 15418: from DUAL union all

15414: (
15415: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15416: from DUAL union all
15417: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15418: from DUAL union all
15419: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15420: from DUAL union all
15421: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15422: from DUAL union all

Line 15420: from DUAL union all

15416: from DUAL union all
15417: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15418: from DUAL union all
15419: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15420: from DUAL union all
15421: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15422: from DUAL union all
15423: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15424: from DUAL union all

Line 15422: from DUAL union all

15418: from DUAL union all
15419: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15420: from DUAL union all
15421: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15422: from DUAL union all
15423: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15424: from DUAL union all
15425: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15426: from DUAL union all

Line 15424: from DUAL union all

15420: from DUAL union all
15421: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15422: from DUAL union all
15423: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15424: from DUAL union all
15425: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15426: from DUAL union all
15427: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15428: from DUAL union all

Line 15426: from DUAL union all

15422: from DUAL union all
15423: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15424: from DUAL union all
15425: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15426: from DUAL union all
15427: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15428: from DUAL union all
15429: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15430: from DUAL

Line 15428: from DUAL union all

15424: from DUAL union all
15425: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15426: from DUAL union all
15427: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15428: from DUAL union all
15429: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15430: from DUAL
15431: ) fin_plan,
15432: (

Line 15430: from DUAL

15426: from DUAL union all
15427: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15428: from DUAL union all
15429: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15430: from DUAL
15431: ) fin_plan,
15432: (
15433: select 1 WBS_SUP_LEVEL,
15434: 1 WBS_SUB_LEVEL,

Line 15436: from DUAL

15432: (
15433: select 1 WBS_SUP_LEVEL,
15434: 1 WBS_SUB_LEVEL,
15435: 'PRJ' INVERT_ID
15436: from DUAL
15437: union all
15438: select 1 WBS_SUP_LEVEL,
15439: 1 WBS_SUB_LEVEL,
15440: 'WBS' INVERT_ID

Line 15441: from DUAL

15437: union all
15438: select 1 WBS_SUP_LEVEL,
15439: 1 WBS_SUB_LEVEL,
15440: 'WBS' INVERT_ID
15441: from DUAL
15442: ) top_slice
15443: where
15444: prg.STRUCT_TYPE = 'PRG' and
15445: prg.SUP_LEVEL = l_level and

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

15498: from
15499: PJI_PJP_PROJ_BATCH_MAP map,
15500: PJI_XBS_DENORM prg,
15501: (
15502: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15503: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
15504: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15505: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
15506: ) invert,

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

15499: PJI_PJP_PROJ_BATCH_MAP map,
15500: PJI_XBS_DENORM prg,
15501: (
15502: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15503: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
15504: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15505: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
15506: ) invert,
15507: PJI_XBS_DENORM_DELTA prg_delta

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

15500: PJI_XBS_DENORM prg,
15501: (
15502: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15503: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
15504: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15505: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
15506: ) invert,
15507: PJI_XBS_DENORM_DELTA prg_delta
15508: where

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

15501: (
15502: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15503: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
15504: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
15505: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
15506: ) invert,
15507: PJI_XBS_DENORM_DELTA prg_delta
15508: where
15509: prg.STRUCT_TYPE = 'PRG' and

Line 16603: from DUAL union all

16599: PA_XBS_DENORM wbs,
16600: PJI_XBS_DENORM prg,
16601: (
16602: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16603: from DUAL union all
16604: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16605: from DUAL union all
16606: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16607: from DUAL union all

Line 16605: from DUAL union all

16601: (
16602: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16603: from DUAL union all
16604: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16605: from DUAL union all
16606: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16607: from DUAL union all
16608: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16609: from DUAL union all

Line 16607: from DUAL union all

16603: from DUAL union all
16604: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16605: from DUAL union all
16606: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16607: from DUAL union all
16608: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16609: from DUAL union all
16610: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16611: from DUAL union all

Line 16609: from DUAL union all

16605: from DUAL union all
16606: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16607: from DUAL union all
16608: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16609: from DUAL union all
16610: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16611: from DUAL union all
16612: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16613: from DUAL union all

Line 16611: from DUAL union all

16607: from DUAL union all
16608: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16609: from DUAL union all
16610: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16611: from DUAL union all
16612: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16613: from DUAL union all
16614: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16615: from DUAL union all

Line 16613: from DUAL union all

16609: from DUAL union all
16610: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16611: from DUAL union all
16612: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16613: from DUAL union all
16614: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16615: from DUAL union all
16616: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16617: from DUAL

Line 16615: from DUAL union all

16611: from DUAL union all
16612: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16613: from DUAL union all
16614: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16615: from DUAL union all
16616: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16617: from DUAL
16618: ) fin_plan,
16619: (

Line 16617: from DUAL

16613: from DUAL union all
16614: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16615: from DUAL union all
16616: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16617: from DUAL
16618: ) fin_plan,
16619: (
16620: select 1 WBS_SUP_LEVEL,
16621: 1 WBS_SUB_LEVEL,

Line 16623: from DUAL

16619: (
16620: select 1 WBS_SUP_LEVEL,
16621: 1 WBS_SUB_LEVEL,
16622: 'PRJ' INVERT_ID
16623: from DUAL
16624: union all
16625: select 1 WBS_SUP_LEVEL,
16626: 1 WBS_SUB_LEVEL,
16627: 'WBS' INVERT_ID

Line 16628: from DUAL

16624: union all
16625: select 1 WBS_SUP_LEVEL,
16626: 1 WBS_SUB_LEVEL,
16627: 'WBS' INVERT_ID
16628: from DUAL
16629: ) top_slice
16630: where
16631: prg.STRUCT_TYPE = 'PRG' and
16632: prg.SUP_LEVEL = l_level and

Line 16758: from DUAL union all

16754: (
16755: select 'Y' CB_FLAG,
16756: 'N' CO_FLAG,
16757: -3 PLAN_VERSION_ID
16758: from DUAL union all
16759: select 'N' CB_FLAG,
16760: 'Y' CO_FLAG,
16761: -4 PLAN_VERSION_ID
16762: from DUAL union all

Line 16762: from DUAL union all

16758: from DUAL union all
16759: select 'N' CB_FLAG,
16760: 'Y' CO_FLAG,
16761: -4 PLAN_VERSION_ID
16762: from DUAL union all
16763: select 'Y' CB_FLAG,
16764: 'Y' CO_FLAG,
16765: -3 PLAN_VERSION_ID
16766: from DUAL union all

Line 16766: from DUAL union all

16762: from DUAL union all
16763: select 'Y' CB_FLAG,
16764: 'Y' CO_FLAG,
16765: -3 PLAN_VERSION_ID
16766: from DUAL union all
16767: select 'Y' CB_FLAG,
16768: 'Y' CO_FLAG,
16769: -4 PLAN_VERSION_ID
16770: from DUAL

Line 16770: from DUAL

16766: from DUAL union all
16767: select 'Y' CB_FLAG,
16768: 'Y' CO_FLAG,
16769: -4 PLAN_VERSION_ID
16770: from DUAL
16771: ) fin_plan
16772: where
16773: prg.STRUCT_TYPE = 'PRG' and
16774: prg.SUP_LEVEL = l_level and

Line 16909: from DUAL union all

16905: PJI_XBS_DENORM prg,
16906: PJI_FP_XBS_ACCUM_F fpr,
16907: (
16908: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16909: from DUAL union all
16910: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16911: from DUAL union all
16912: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16913: from DUAL union all

Line 16911: from DUAL union all

16907: (
16908: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16909: from DUAL union all
16910: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16911: from DUAL union all
16912: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16913: from DUAL union all
16914: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16915: from DUAL union all

Line 16913: from DUAL union all

16909: from DUAL union all
16910: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16911: from DUAL union all
16912: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16913: from DUAL union all
16914: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16915: from DUAL union all
16916: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16917: from DUAL union all

Line 16915: from DUAL union all

16911: from DUAL union all
16912: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16913: from DUAL union all
16914: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16915: from DUAL union all
16916: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16917: from DUAL union all
16918: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16919: from DUAL union all

Line 16917: from DUAL union all

16913: from DUAL union all
16914: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16915: from DUAL union all
16916: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16917: from DUAL union all
16918: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16919: from DUAL union all
16920: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16921: from DUAL union all

Line 16919: from DUAL union all

16915: from DUAL union all
16916: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16917: from DUAL union all
16918: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16919: from DUAL union all
16920: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16921: from DUAL union all
16922: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16923: from DUAL

Line 16921: from DUAL union all

16917: from DUAL union all
16918: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16919: from DUAL union all
16920: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16921: from DUAL union all
16922: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16923: from DUAL
16924: ) fin_plan,
16925: (

Line 16923: from DUAL

16919: from DUAL union all
16920: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16921: from DUAL union all
16922: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16923: from DUAL
16924: ) fin_plan,
16925: (
16926: select 1 WBS_SUP_LEVEL,
16927: 1 WBS_SUB_LEVEL,

Line 16929: from DUAL

16925: (
16926: select 1 WBS_SUP_LEVEL,
16927: 1 WBS_SUB_LEVEL,
16928: 'PRJ' INVERT_ID
16929: from DUAL
16930: union all
16931: select 1 WBS_SUP_LEVEL,
16932: 1 WBS_SUB_LEVEL,
16933: 'WBS' INVERT_ID

Line 16934: from DUAL

16930: union all
16931: select 1 WBS_SUP_LEVEL,
16932: 1 WBS_SUB_LEVEL,
16933: 'WBS' INVERT_ID
16934: from DUAL
16935: ) top_slice
16936: where
16937: prg.STRUCT_TYPE = 'PRG' and
16938: prg.SUP_LEVEL = l_level and

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

16991: from
16992: PJI_PJP_PROJ_BATCH_MAP map,
16993: PJI_XBS_DENORM prg,
16994: (
16995: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16996: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
16997: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16998: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
16999: ) invert,

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

16992: PJI_PJP_PROJ_BATCH_MAP map,
16993: PJI_XBS_DENORM prg,
16994: (
16995: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16996: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
16997: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16998: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
16999: ) invert,
17000: PJI_XBS_DENORM_DELTA prg_delta

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

16993: PJI_XBS_DENORM prg,
16994: (
16995: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16996: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
16997: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16998: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
16999: ) invert,
17000: PJI_XBS_DENORM_DELTA prg_delta
17001: where

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

16994: (
16995: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16996: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
16997: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16998: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
16999: ) invert,
17000: PJI_XBS_DENORM_DELTA prg_delta
17001: where
17002: prg.STRUCT_TYPE = 'PRG' and

Line 18097: from DUAL union all

18093: PA_XBS_DENORM wbs,
18094: PJI_XBS_DENORM prg,
18095: (
18096: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18097: from DUAL union all
18098: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18099: from DUAL union all
18100: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18101: from DUAL union all

Line 18099: from DUAL union all

18095: (
18096: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18097: from DUAL union all
18098: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18099: from DUAL union all
18100: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18101: from DUAL union all
18102: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18103: from DUAL union all

Line 18101: from DUAL union all

18097: from DUAL union all
18098: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18099: from DUAL union all
18100: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18101: from DUAL union all
18102: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18103: from DUAL union all
18104: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18105: from DUAL union all

Line 18103: from DUAL union all

18099: from DUAL union all
18100: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18101: from DUAL union all
18102: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18103: from DUAL union all
18104: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18105: from DUAL union all
18106: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18107: from DUAL union all

Line 18105: from DUAL union all

18101: from DUAL union all
18102: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18103: from DUAL union all
18104: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18105: from DUAL union all
18106: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18107: from DUAL union all
18108: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18109: from DUAL union all

Line 18107: from DUAL union all

18103: from DUAL union all
18104: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18105: from DUAL union all
18106: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18107: from DUAL union all
18108: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18109: from DUAL union all
18110: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18111: from DUAL

Line 18109: from DUAL union all

18105: from DUAL union all
18106: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18107: from DUAL union all
18108: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18109: from DUAL union all
18110: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18111: from DUAL
18112: ) fin_plan,
18113: (

Line 18111: from DUAL

18107: from DUAL union all
18108: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18109: from DUAL union all
18110: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18111: from DUAL
18112: ) fin_plan,
18113: (
18114: select 1 WBS_SUP_LEVEL,
18115: 1 WBS_SUB_LEVEL,

Line 18117: from DUAL

18113: (
18114: select 1 WBS_SUP_LEVEL,
18115: 1 WBS_SUB_LEVEL,
18116: 'PRJ' INVERT_ID
18117: from DUAL
18118: union all
18119: select 1 WBS_SUP_LEVEL,
18120: 1 WBS_SUB_LEVEL,
18121: 'WBS' INVERT_ID

Line 18122: from DUAL

18118: union all
18119: select 1 WBS_SUP_LEVEL,
18120: 1 WBS_SUB_LEVEL,
18121: 'WBS' INVERT_ID
18122: from DUAL
18123: ) top_slice
18124: where
18125: prg.STRUCT_TYPE = 'PRG' and
18126: prg.SUP_LEVEL = l_level and

Line 18252: from DUAL union all

18248: (
18249: select 'Y' CB_FLAG,
18250: 'N' CO_FLAG,
18251: -3 PLAN_VERSION_ID
18252: from DUAL union all
18253: select 'N' CB_FLAG,
18254: 'Y' CO_FLAG,
18255: -4 PLAN_VERSION_ID
18256: from DUAL union all

Line 18256: from DUAL union all

18252: from DUAL union all
18253: select 'N' CB_FLAG,
18254: 'Y' CO_FLAG,
18255: -4 PLAN_VERSION_ID
18256: from DUAL union all
18257: select 'Y' CB_FLAG,
18258: 'Y' CO_FLAG,
18259: -3 PLAN_VERSION_ID
18260: from DUAL union all

Line 18260: from DUAL union all

18256: from DUAL union all
18257: select 'Y' CB_FLAG,
18258: 'Y' CO_FLAG,
18259: -3 PLAN_VERSION_ID
18260: from DUAL union all
18261: select 'Y' CB_FLAG,
18262: 'Y' CO_FLAG,
18263: -4 PLAN_VERSION_ID
18264: from DUAL

Line 18264: from DUAL

18260: from DUAL union all
18261: select 'Y' CB_FLAG,
18262: 'Y' CO_FLAG,
18263: -4 PLAN_VERSION_ID
18264: from DUAL
18265: ) fin_plan
18266: where
18267: prg.STRUCT_TYPE = 'PRG' and
18268: prg.SUP_LEVEL = l_level and

Line 18403: from DUAL union all

18399: PJI_XBS_DENORM prg,
18400: PJI_FP_XBS_ACCUM_F fpr,
18401: (
18402: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18403: from DUAL union all
18404: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18405: from DUAL union all
18406: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18407: from DUAL union all

Line 18405: from DUAL union all

18401: (
18402: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18403: from DUAL union all
18404: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18405: from DUAL union all
18406: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18407: from DUAL union all
18408: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18409: from DUAL union all

Line 18407: from DUAL union all

18403: from DUAL union all
18404: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18405: from DUAL union all
18406: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18407: from DUAL union all
18408: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18409: from DUAL union all
18410: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18411: from DUAL union all

Line 18409: from DUAL union all

18405: from DUAL union all
18406: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18407: from DUAL union all
18408: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18409: from DUAL union all
18410: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18411: from DUAL union all
18412: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18413: from DUAL union all

Line 18411: from DUAL union all

18407: from DUAL union all
18408: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18409: from DUAL union all
18410: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18411: from DUAL union all
18412: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18413: from DUAL union all
18414: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18415: from DUAL union all

Line 18413: from DUAL union all

18409: from DUAL union all
18410: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
18411: from DUAL union all
18412: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18413: from DUAL union all
18414: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18415: from DUAL union all
18416: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18417: from DUAL

Line 18415: from DUAL union all

18411: from DUAL union all
18412: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18413: from DUAL union all
18414: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18415: from DUAL union all
18416: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18417: from DUAL
18418: ) fin_plan,
18419: (

Line 18417: from DUAL

18413: from DUAL union all
18414: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
18415: from DUAL union all
18416: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
18417: from DUAL
18418: ) fin_plan,
18419: (
18420: select 1 WBS_SUP_LEVEL,
18421: 1 WBS_SUB_LEVEL,

Line 18423: from DUAL

18419: (
18420: select 1 WBS_SUP_LEVEL,
18421: 1 WBS_SUB_LEVEL,
18422: 'PRJ' INVERT_ID
18423: from DUAL
18424: union all
18425: select 1 WBS_SUP_LEVEL,
18426: 1 WBS_SUB_LEVEL,
18427: 'WBS' INVERT_ID

Line 18428: from DUAL

18424: union all
18425: select 1 WBS_SUP_LEVEL,
18426: 1 WBS_SUB_LEVEL,
18427: 'WBS' INVERT_ID
18428: from DUAL
18429: ) top_slice
18430: where
18431: prg.STRUCT_TYPE = 'PRG' and
18432: prg.SUP_LEVEL = l_level and

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

18485: from
18486: PJI_PJP_PROJ_BATCH_MAP map,
18487: PJI_XBS_DENORM prg,
18488: (
18489: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18490: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
18491: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18492: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
18493: ) invert,

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

18486: PJI_PJP_PROJ_BATCH_MAP map,
18487: PJI_XBS_DENORM prg,
18488: (
18489: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18490: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
18491: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18492: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
18493: ) invert,
18494: PJI_XBS_DENORM_DELTA prg_delta

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

18487: PJI_XBS_DENORM prg,
18488: (
18489: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18490: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
18491: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18492: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
18493: ) invert,
18494: PJI_XBS_DENORM_DELTA prg_delta
18495: where

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

18488: (
18489: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18490: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
18491: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
18492: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
18493: ) invert,
18494: PJI_XBS_DENORM_DELTA prg_delta
18495: where
18496: prg.STRUCT_TYPE = 'PRG' and

Line 19591: from DUAL union all

19587: PA_XBS_DENORM wbs,
19588: PJI_XBS_DENORM prg,
19589: (
19590: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19591: from DUAL union all
19592: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19593: from DUAL union all
19594: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19595: from DUAL union all

Line 19593: from DUAL union all

19589: (
19590: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19591: from DUAL union all
19592: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19593: from DUAL union all
19594: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19595: from DUAL union all
19596: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19597: from DUAL union all

Line 19595: from DUAL union all

19591: from DUAL union all
19592: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19593: from DUAL union all
19594: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19595: from DUAL union all
19596: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19597: from DUAL union all
19598: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19599: from DUAL union all

Line 19597: from DUAL union all

19593: from DUAL union all
19594: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19595: from DUAL union all
19596: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19597: from DUAL union all
19598: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19599: from DUAL union all
19600: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19601: from DUAL union all

Line 19599: from DUAL union all

19595: from DUAL union all
19596: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19597: from DUAL union all
19598: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19599: from DUAL union all
19600: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19601: from DUAL union all
19602: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19603: from DUAL union all

Line 19601: from DUAL union all

19597: from DUAL union all
19598: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19599: from DUAL union all
19600: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19601: from DUAL union all
19602: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19603: from DUAL union all
19604: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19605: from DUAL

Line 19603: from DUAL union all

19599: from DUAL union all
19600: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19601: from DUAL union all
19602: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19603: from DUAL union all
19604: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19605: from DUAL
19606: ) fin_plan,
19607: (

Line 19605: from DUAL

19601: from DUAL union all
19602: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19603: from DUAL union all
19604: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19605: from DUAL
19606: ) fin_plan,
19607: (
19608: select 1 WBS_SUP_LEVEL,
19609: 1 WBS_SUB_LEVEL,

Line 19611: from DUAL

19607: (
19608: select 1 WBS_SUP_LEVEL,
19609: 1 WBS_SUB_LEVEL,
19610: 'PRJ' INVERT_ID
19611: from DUAL
19612: union all
19613: select 1 WBS_SUP_LEVEL,
19614: 1 WBS_SUB_LEVEL,
19615: 'WBS' INVERT_ID

Line 19616: from DUAL

19612: union all
19613: select 1 WBS_SUP_LEVEL,
19614: 1 WBS_SUB_LEVEL,
19615: 'WBS' INVERT_ID
19616: from DUAL
19617: ) top_slice
19618: where
19619: prg.STRUCT_TYPE = 'PRG' and
19620: prg.SUP_LEVEL = l_level and

Line 19746: from DUAL union all

19742: (
19743: select 'Y' CB_FLAG,
19744: 'N' CO_FLAG,
19745: -3 PLAN_VERSION_ID
19746: from DUAL union all
19747: select 'N' CB_FLAG,
19748: 'Y' CO_FLAG,
19749: -4 PLAN_VERSION_ID
19750: from DUAL union all

Line 19750: from DUAL union all

19746: from DUAL union all
19747: select 'N' CB_FLAG,
19748: 'Y' CO_FLAG,
19749: -4 PLAN_VERSION_ID
19750: from DUAL union all
19751: select 'Y' CB_FLAG,
19752: 'Y' CO_FLAG,
19753: -3 PLAN_VERSION_ID
19754: from DUAL union all

Line 19754: from DUAL union all

19750: from DUAL union all
19751: select 'Y' CB_FLAG,
19752: 'Y' CO_FLAG,
19753: -3 PLAN_VERSION_ID
19754: from DUAL union all
19755: select 'Y' CB_FLAG,
19756: 'Y' CO_FLAG,
19757: -4 PLAN_VERSION_ID
19758: from DUAL

Line 19758: from DUAL

19754: from DUAL union all
19755: select 'Y' CB_FLAG,
19756: 'Y' CO_FLAG,
19757: -4 PLAN_VERSION_ID
19758: from DUAL
19759: ) fin_plan
19760: where
19761: prg.STRUCT_TYPE = 'PRG' and
19762: prg.SUP_LEVEL = l_level and

Line 19897: from DUAL union all

19893: PJI_XBS_DENORM prg,
19894: PJI_FP_XBS_ACCUM_F fpr,
19895: (
19896: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19897: from DUAL union all
19898: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19899: from DUAL union all
19900: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19901: from DUAL union all

Line 19899: from DUAL union all

19895: (
19896: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19897: from DUAL union all
19898: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19899: from DUAL union all
19900: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19901: from DUAL union all
19902: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19903: from DUAL union all

Line 19901: from DUAL union all

19897: from DUAL union all
19898: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19899: from DUAL union all
19900: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19901: from DUAL union all
19902: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19903: from DUAL union all
19904: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19905: from DUAL union all

Line 19903: from DUAL union all

19899: from DUAL union all
19900: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19901: from DUAL union all
19902: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19903: from DUAL union all
19904: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19905: from DUAL union all
19906: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19907: from DUAL union all

Line 19905: from DUAL union all

19901: from DUAL union all
19902: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19903: from DUAL union all
19904: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19905: from DUAL union all
19906: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19907: from DUAL union all
19908: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19909: from DUAL union all

Line 19907: from DUAL union all

19903: from DUAL union all
19904: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
19905: from DUAL union all
19906: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19907: from DUAL union all
19908: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19909: from DUAL union all
19910: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19911: from DUAL

Line 19909: from DUAL union all

19905: from DUAL union all
19906: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19907: from DUAL union all
19908: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19909: from DUAL union all
19910: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19911: from DUAL
19912: ) fin_plan,
19913: (

Line 19911: from DUAL

19907: from DUAL union all
19908: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
19909: from DUAL union all
19910: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
19911: from DUAL
19912: ) fin_plan,
19913: (
19914: select 1 WBS_SUP_LEVEL,
19915: 1 WBS_SUB_LEVEL,

Line 19917: from DUAL

19913: (
19914: select 1 WBS_SUP_LEVEL,
19915: 1 WBS_SUB_LEVEL,
19916: 'PRJ' INVERT_ID
19917: from DUAL
19918: union all
19919: select 1 WBS_SUP_LEVEL,
19920: 1 WBS_SUB_LEVEL,
19921: 'WBS' INVERT_ID

Line 19922: from DUAL

19918: union all
19919: select 1 WBS_SUP_LEVEL,
19920: 1 WBS_SUB_LEVEL,
19921: 'WBS' INVERT_ID
19922: from DUAL
19923: ) top_slice
19924: where
19925: prg.STRUCT_TYPE = 'PRG' and
19926: prg.SUP_LEVEL = l_level and

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

19979: from
19980: PJI_PJP_PROJ_BATCH_MAP map,
19981: PJI_XBS_DENORM prg,
19982: (
19983: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19984: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
19985: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19986: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
19987: ) invert,

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

19980: PJI_PJP_PROJ_BATCH_MAP map,
19981: PJI_XBS_DENORM prg,
19982: (
19983: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19984: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
19985: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19986: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
19987: ) invert,
19988: PJI_XBS_DENORM_DELTA prg_delta

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

19981: PJI_XBS_DENORM prg,
19982: (
19983: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19984: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
19985: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19986: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
19987: ) invert,
19988: PJI_XBS_DENORM_DELTA prg_delta
19989: where

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

19982: (
19983: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19984: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
19985: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
19986: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
19987: ) invert,
19988: PJI_XBS_DENORM_DELTA prg_delta
19989: where
19990: prg.STRUCT_TYPE = 'PRG' and

Line 21085: from DUAL union all

21081: PA_XBS_DENORM wbs,
21082: PJI_XBS_DENORM prg,
21083: (
21084: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21085: from DUAL union all
21086: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21087: from DUAL union all
21088: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21089: from DUAL union all

Line 21087: from DUAL union all

21083: (
21084: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21085: from DUAL union all
21086: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21087: from DUAL union all
21088: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21089: from DUAL union all
21090: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21091: from DUAL union all

Line 21089: from DUAL union all

21085: from DUAL union all
21086: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21087: from DUAL union all
21088: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21089: from DUAL union all
21090: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21091: from DUAL union all
21092: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21093: from DUAL union all

Line 21091: from DUAL union all

21087: from DUAL union all
21088: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21089: from DUAL union all
21090: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21091: from DUAL union all
21092: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21093: from DUAL union all
21094: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21095: from DUAL union all

Line 21093: from DUAL union all

21089: from DUAL union all
21090: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21091: from DUAL union all
21092: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21093: from DUAL union all
21094: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21095: from DUAL union all
21096: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21097: from DUAL union all

Line 21095: from DUAL union all

21091: from DUAL union all
21092: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21093: from DUAL union all
21094: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21095: from DUAL union all
21096: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21097: from DUAL union all
21098: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21099: from DUAL

Line 21097: from DUAL union all

21093: from DUAL union all
21094: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21095: from DUAL union all
21096: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21097: from DUAL union all
21098: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21099: from DUAL
21100: ) fin_plan,
21101: (

Line 21099: from DUAL

21095: from DUAL union all
21096: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21097: from DUAL union all
21098: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21099: from DUAL
21100: ) fin_plan,
21101: (
21102: select 1 WBS_SUP_LEVEL,
21103: 1 WBS_SUB_LEVEL,

Line 21105: from DUAL

21101: (
21102: select 1 WBS_SUP_LEVEL,
21103: 1 WBS_SUB_LEVEL,
21104: 'PRJ' INVERT_ID
21105: from DUAL
21106: union all
21107: select 1 WBS_SUP_LEVEL,
21108: 1 WBS_SUB_LEVEL,
21109: 'WBS' INVERT_ID

Line 21110: from DUAL

21106: union all
21107: select 1 WBS_SUP_LEVEL,
21108: 1 WBS_SUB_LEVEL,
21109: 'WBS' INVERT_ID
21110: from DUAL
21111: ) top_slice
21112: where
21113: prg.STRUCT_TYPE = 'PRG' and
21114: prg.SUP_LEVEL = l_level and

Line 21240: from DUAL union all

21236: (
21237: select 'Y' CB_FLAG,
21238: 'N' CO_FLAG,
21239: -3 PLAN_VERSION_ID
21240: from DUAL union all
21241: select 'N' CB_FLAG,
21242: 'Y' CO_FLAG,
21243: -4 PLAN_VERSION_ID
21244: from DUAL union all

Line 21244: from DUAL union all

21240: from DUAL union all
21241: select 'N' CB_FLAG,
21242: 'Y' CO_FLAG,
21243: -4 PLAN_VERSION_ID
21244: from DUAL union all
21245: select 'Y' CB_FLAG,
21246: 'Y' CO_FLAG,
21247: -3 PLAN_VERSION_ID
21248: from DUAL union all

Line 21248: from DUAL union all

21244: from DUAL union all
21245: select 'Y' CB_FLAG,
21246: 'Y' CO_FLAG,
21247: -3 PLAN_VERSION_ID
21248: from DUAL union all
21249: select 'Y' CB_FLAG,
21250: 'Y' CO_FLAG,
21251: -4 PLAN_VERSION_ID
21252: from DUAL

Line 21252: from DUAL

21248: from DUAL union all
21249: select 'Y' CB_FLAG,
21250: 'Y' CO_FLAG,
21251: -4 PLAN_VERSION_ID
21252: from DUAL
21253: ) fin_plan
21254: where
21255: prg.STRUCT_TYPE = 'PRG' and
21256: prg.SUP_LEVEL = l_level and

Line 21391: from DUAL union all

21387: PJI_XBS_DENORM prg,
21388: PJI_FP_XBS_ACCUM_F fpr,
21389: (
21390: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21391: from DUAL union all
21392: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21393: from DUAL union all
21394: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21395: from DUAL union all

Line 21393: from DUAL union all

21389: (
21390: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21391: from DUAL union all
21392: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21393: from DUAL union all
21394: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21395: from DUAL union all
21396: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21397: from DUAL union all

Line 21395: from DUAL union all

21391: from DUAL union all
21392: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21393: from DUAL union all
21394: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21395: from DUAL union all
21396: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21397: from DUAL union all
21398: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21399: from DUAL union all

Line 21397: from DUAL union all

21393: from DUAL union all
21394: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21395: from DUAL union all
21396: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21397: from DUAL union all
21398: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21399: from DUAL union all
21400: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21401: from DUAL union all

Line 21399: from DUAL union all

21395: from DUAL union all
21396: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21397: from DUAL union all
21398: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21399: from DUAL union all
21400: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21401: from DUAL union all
21402: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21403: from DUAL union all

Line 21401: from DUAL union all

21397: from DUAL union all
21398: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
21399: from DUAL union all
21400: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21401: from DUAL union all
21402: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21403: from DUAL union all
21404: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21405: from DUAL

Line 21403: from DUAL union all

21399: from DUAL union all
21400: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21401: from DUAL union all
21402: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21403: from DUAL union all
21404: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21405: from DUAL
21406: ) fin_plan,
21407: (

Line 21405: from DUAL

21401: from DUAL union all
21402: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
21403: from DUAL union all
21404: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
21405: from DUAL
21406: ) fin_plan,
21407: (
21408: select 1 WBS_SUP_LEVEL,
21409: 1 WBS_SUB_LEVEL,

Line 21411: from DUAL

21407: (
21408: select 1 WBS_SUP_LEVEL,
21409: 1 WBS_SUB_LEVEL,
21410: 'PRJ' INVERT_ID
21411: from DUAL
21412: union all
21413: select 1 WBS_SUP_LEVEL,
21414: 1 WBS_SUB_LEVEL,
21415: 'WBS' INVERT_ID

Line 21416: from DUAL

21412: union all
21413: select 1 WBS_SUP_LEVEL,
21414: 1 WBS_SUB_LEVEL,
21415: 'WBS' INVERT_ID
21416: from DUAL
21417: ) top_slice
21418: where
21419: prg.STRUCT_TYPE = 'PRG' and
21420: prg.SUP_LEVEL = l_level and

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

21473: from
21474: PJI_PJP_PROJ_BATCH_MAP map,
21475: PJI_XBS_DENORM prg,
21476: (
21477: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
21478: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
21479: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
21480: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
21481: ) invert,

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

21474: PJI_PJP_PROJ_BATCH_MAP map,
21475: PJI_XBS_DENORM prg,
21476: (
21477: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
21478: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
21479: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
21480: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
21481: ) invert,
21482: PJI_XBS_DENORM_DELTA prg_delta

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

21475: PJI_XBS_DENORM prg,
21476: (
21477: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
21478: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
21479: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
21480: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
21481: ) invert,
21482: PJI_XBS_DENORM_DELTA prg_delta
21483: where

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

21476: (
21477: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
21478: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
21479: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
21480: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
21481: ) invert,
21482: PJI_XBS_DENORM_DELTA prg_delta
21483: where
21484: prg.STRUCT_TYPE = 'PRG' and