eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_PJP_GEN_PERF_ALL dependencies on DUAL

Line 519: SELECT 4 INVERT_ID FROM dual UNION ALL

515: ) spread_bl
516: ---- end of third inline view 'spread_bl'...........
517: ,
518: (
519: SELECT 4 INVERT_ID FROM dual UNION ALL
520: SELECT 8 INVERT_ID FROM dual UNION ALL
521: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
522: ) invert
523: ) collapse_bl

Line 520: SELECT 8 INVERT_ID FROM dual UNION ALL

516: ---- end of third inline view 'spread_bl'...........
517: ,
518: (
519: SELECT 4 INVERT_ID FROM dual UNION ALL
520: SELECT 8 INVERT_ID FROM dual UNION ALL
521: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
522: ) invert
523: ) collapse_bl
524: ---- End of second inline view 'collapse_bl' ..........

Line 521: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

517: ,
518: (
519: SELECT 4 INVERT_ID FROM dual UNION ALL
520: SELECT 8 INVERT_ID FROM dual UNION ALL
521: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
522: ) invert
523: ) collapse_bl
524: ---- End of second inline view 'collapse_bl' ..........
525: GROUP BY

Line 1141: SELECT 4 INVERT_ID FROM dual UNION ALL

1137: ) spread_bl
1138: ---- end of third inline view 'spread_bl'...........
1139: ,
1140: (
1141: SELECT 4 INVERT_ID FROM dual UNION ALL
1142: SELECT 8 INVERT_ID FROM dual UNION ALL
1143: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
1144: ) invert
1145: ) collapse_bl

Line 1142: SELECT 8 INVERT_ID FROM dual UNION ALL

1138: ---- end of third inline view 'spread_bl'...........
1139: ,
1140: (
1141: SELECT 4 INVERT_ID FROM dual UNION ALL
1142: SELECT 8 INVERT_ID FROM dual UNION ALL
1143: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
1144: ) invert
1145: ) collapse_bl
1146: ---- End of second inline view 'collapse_bl' ..........

Line 1143: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

1139: ,
1140: (
1141: SELECT 4 INVERT_ID FROM dual UNION ALL
1142: SELECT 8 INVERT_ID FROM dual UNION ALL
1143: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
1144: ) invert
1145: ) collapse_bl
1146: ---- End of second inline view 'collapse_bl' ..........
1147: GROUP BY

Line 1584: SELECT 4 INVERT_ID FROM dual UNION ALL

1580: ) spread_bl
1581: ---- end of third inline view 'spread_bl'...........
1582: ,
1583: (
1584: SELECT 4 INVERT_ID FROM dual UNION ALL
1585: SELECT 8 INVERT_ID FROM dual UNION ALL
1586: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
1587: ) invert
1588: ) collapse_bl

Line 1585: SELECT 8 INVERT_ID FROM dual UNION ALL

1581: ---- end of third inline view 'spread_bl'...........
1582: ,
1583: (
1584: SELECT 4 INVERT_ID FROM dual UNION ALL
1585: SELECT 8 INVERT_ID FROM dual UNION ALL
1586: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
1587: ) invert
1588: ) collapse_bl
1589: ---- End of second inline view 'collapse_bl' ..........

Line 1586: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

1582: ,
1583: (
1584: SELECT 4 INVERT_ID FROM dual UNION ALL
1585: SELECT 8 INVERT_ID FROM dual UNION ALL
1586: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
1587: ) invert
1588: ) collapse_bl
1589: ---- End of second inline view 'collapse_bl' ..........
1590: GROUP BY

Line 2663: select 1 INVERT_ID from dual

2659: PJI_ORG_EXTR_INFO info,
2660: PJI_PJP_WBS_HEADER wbs_hdr,
2661: PA_PROJ_ELEMENT_VERSIONS ver,
2662: (
2663: select 1 INVERT_ID from dual
2664: where p_g1_currency_flag = 'Y' and /* Added for Bug 8497371 */
2665: p_g1_currency_code is not null union all
2666: select 2 INVERT_ID from dual
2667: where p_g2_currency_flag = 'Y' and

Line 2666: select 2 INVERT_ID from dual

2662: (
2663: select 1 INVERT_ID from dual
2664: where p_g1_currency_flag = 'Y' and /* Added for Bug 8497371 */
2665: p_g1_currency_code is not null union all
2666: select 2 INVERT_ID from dual
2667: where p_g2_currency_flag = 'Y' and
2668: p_g2_currency_code is not null union all
2669: select 4 INVERT_ID from dual union all
2670: select 8 INVERT_ID from dual union all

Line 2669: select 4 INVERT_ID from dual union all

2665: p_g1_currency_code is not null union all
2666: select 2 INVERT_ID from dual
2667: where p_g2_currency_flag = 'Y' and
2668: p_g2_currency_code is not null union all
2669: select 4 INVERT_ID from dual union all
2670: select 8 INVERT_ID from dual union all
2671: select 16 INVERT_ID from dual
2672: where p_txn_currency_flag = 'Y'
2673: ) invert

Line 2670: select 8 INVERT_ID from dual union all

2666: select 2 INVERT_ID from dual
2667: where p_g2_currency_flag = 'Y' and
2668: p_g2_currency_code is not null union all
2669: select 4 INVERT_ID from dual union all
2670: select 8 INVERT_ID from dual union all
2671: select 16 INVERT_ID from dual
2672: where p_txn_currency_flag = 'Y'
2673: ) invert
2674: where

Line 2671: select 16 INVERT_ID from dual

2667: where p_g2_currency_flag = 'Y' and
2668: p_g2_currency_code is not null union all
2669: select 4 INVERT_ID from dual union all
2670: select 8 INVERT_ID from dual union all
2671: select 16 INVERT_ID from dual
2672: where p_txn_currency_flag = 'Y'
2673: ) invert
2674: where
2675: src.TXN_ACCUM_HEADER_ID = rbs.TXN_ACCUM_HEADER_ID (+) and

Line 3938: from DUAL union all

3934: PA_XBS_DENORM wbs,
3935: PJI_XBS_DENORM prg,
3936: (
3937: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
3938: from DUAL union all
3939: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
3940: from DUAL union all
3941: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
3942: from DUAL union all

Line 3940: from DUAL union all

3936: (
3937: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
3938: from DUAL union all
3939: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
3940: from DUAL union all
3941: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
3942: from DUAL union all
3943: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
3944: from DUAL union all

Line 3942: from DUAL union all

3938: from DUAL union all
3939: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
3940: from DUAL union all
3941: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
3942: from DUAL union all
3943: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
3944: from DUAL union all
3945: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
3946: from DUAL union all

Line 3944: from DUAL union all

3940: from DUAL union all
3941: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
3942: from DUAL union all
3943: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
3944: from DUAL union all
3945: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
3946: from DUAL union all
3947: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
3948: from DUAL union all

Line 3946: from DUAL union all

3942: from DUAL union all
3943: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
3944: from DUAL union all
3945: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
3946: from DUAL union all
3947: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
3948: from DUAL union all
3949: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
3950: from DUAL union all

Line 3948: from DUAL union all

3944: from DUAL union all
3945: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
3946: from DUAL union all
3947: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
3948: from DUAL union all
3949: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
3950: from DUAL union all
3951: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
3952: from DUAL

Line 3950: from DUAL union all

3946: from DUAL union all
3947: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
3948: from DUAL union all
3949: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
3950: from DUAL union all
3951: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
3952: from DUAL
3953: ) fin_plan,
3954: (

Line 3952: from DUAL

3948: from DUAL union all
3949: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
3950: from DUAL union all
3951: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
3952: from DUAL
3953: ) fin_plan,
3954: (
3955: select 1 WBS_SUP_LEVEL,
3956: 1 WBS_SUB_LEVEL,

Line 3958: from DUAL

3954: (
3955: select 1 WBS_SUP_LEVEL,
3956: 1 WBS_SUB_LEVEL,
3957: 'PRJ' INVERT_ID
3958: from DUAL
3959: union all
3960: select 1 WBS_SUP_LEVEL,
3961: 1 WBS_SUB_LEVEL,
3962: 'WBS' INVERT_ID

Line 3963: from DUAL

3959: union all
3960: select 1 WBS_SUP_LEVEL,
3961: 1 WBS_SUB_LEVEL,
3962: 'WBS' INVERT_ID
3963: from DUAL
3964: ) top_slice
3965: where
3966: prg.STRUCT_TYPE = 'PRG' and
3967: prg.SUP_LEVEL = l_level and

Line 4092: from DUAL union all

4088: (
4089: select 'Y' CB_FLAG,
4090: 'N' CO_FLAG,
4091: -3 PLAN_VERSION_ID
4092: from DUAL union all
4093: select 'N' CB_FLAG,
4094: 'Y' CO_FLAG,
4095: -4 PLAN_VERSION_ID
4096: from DUAL union all

Line 4096: from DUAL union all

4092: from DUAL union all
4093: select 'N' CB_FLAG,
4094: 'Y' CO_FLAG,
4095: -4 PLAN_VERSION_ID
4096: from DUAL union all
4097: select 'Y' CB_FLAG,
4098: 'Y' CO_FLAG,
4099: -3 PLAN_VERSION_ID
4100: from DUAL union all

Line 4100: from DUAL union all

4096: from DUAL union all
4097: select 'Y' CB_FLAG,
4098: 'Y' CO_FLAG,
4099: -3 PLAN_VERSION_ID
4100: from DUAL union all
4101: select 'Y' CB_FLAG,
4102: 'Y' CO_FLAG,
4103: -4 PLAN_VERSION_ID
4104: from DUAL

Line 4104: from DUAL

4100: from DUAL union all
4101: select 'Y' CB_FLAG,
4102: 'Y' CO_FLAG,
4103: -4 PLAN_VERSION_ID
4104: from DUAL
4105: ) fin_plan
4106: where
4107: prg.STRUCT_TYPE = 'PRG' and
4108: prg.SUP_LEVEL = l_level and

Line 4243: from DUAL union all

4239: PJI_XBS_DENORM prg,
4240: PJI_FP_XBS_ACCUM_F fpr,
4241: (
4242: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
4243: from DUAL union all
4244: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
4245: from DUAL union all
4246: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
4247: from DUAL union all

Line 4245: from DUAL union all

4241: (
4242: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
4243: from DUAL union all
4244: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
4245: from DUAL union all
4246: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
4247: from DUAL union all
4248: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
4249: from DUAL union all

Line 4247: from DUAL union all

4243: from DUAL union all
4244: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
4245: from DUAL union all
4246: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
4247: from DUAL union all
4248: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
4249: from DUAL union all
4250: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
4251: from DUAL union all

Line 4249: from DUAL union all

4245: from DUAL union all
4246: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
4247: from DUAL union all
4248: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
4249: from DUAL union all
4250: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
4251: from DUAL union all
4252: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
4253: from DUAL union all

Line 4251: from DUAL union all

4247: from DUAL union all
4248: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
4249: from DUAL union all
4250: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
4251: from DUAL union all
4252: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
4253: from DUAL union all
4254: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
4255: from DUAL union all

Line 4253: from DUAL union all

4249: from DUAL union all
4250: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
4251: from DUAL union all
4252: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
4253: from DUAL union all
4254: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
4255: from DUAL union all
4256: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
4257: from DUAL

Line 4255: from DUAL union all

4251: from DUAL union all
4252: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
4253: from DUAL union all
4254: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
4255: from DUAL union all
4256: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
4257: from DUAL
4258: ) fin_plan,
4259: (

Line 4257: from DUAL

4253: from DUAL union all
4254: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
4255: from DUAL union all
4256: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
4257: from DUAL
4258: ) fin_plan,
4259: (
4260: select 1 WBS_SUP_LEVEL,
4261: 1 WBS_SUB_LEVEL,

Line 4263: from DUAL

4259: (
4260: select 1 WBS_SUP_LEVEL,
4261: 1 WBS_SUB_LEVEL,
4262: 'PRJ' INVERT_ID
4263: from DUAL
4264: union all
4265: select 1 WBS_SUP_LEVEL,
4266: 1 WBS_SUB_LEVEL,
4267: 'WBS' INVERT_ID

Line 4268: from DUAL

4264: union all
4265: select 1 WBS_SUP_LEVEL,
4266: 1 WBS_SUB_LEVEL,
4267: 'WBS' INVERT_ID
4268: from DUAL
4269: ) top_slice
4270: where
4271: prg.STRUCT_TYPE = 'PRG' and
4272: prg.SUP_LEVEL = l_level and

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

4325: from
4326: PJI_PJP_PROJ_BATCH_MAP map,
4327: PJI_XBS_DENORM prg,
4328: (
4329: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
4330: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
4331: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
4332: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
4333: ) invert,

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

4326: PJI_PJP_PROJ_BATCH_MAP map,
4327: PJI_XBS_DENORM prg,
4328: (
4329: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
4330: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
4331: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
4332: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
4333: ) invert,
4334: PJI_XBS_DENORM_DELTA prg_delta

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

4327: PJI_XBS_DENORM prg,
4328: (
4329: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
4330: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
4331: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
4332: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
4333: ) invert,
4334: PJI_XBS_DENORM_DELTA prg_delta
4335: where

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

4328: (
4329: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
4330: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
4331: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
4332: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
4333: ) invert,
4334: PJI_XBS_DENORM_DELTA prg_delta
4335: where
4336: prg.STRUCT_TYPE = 'PRG' and

Line 5253: from DUAL union all

5249: PA_XBS_DENORM wbs,
5250: PJI_XBS_DENORM prg,
5251: (
5252: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
5253: from DUAL union all
5254: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5255: from DUAL union all
5256: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
5257: from DUAL union all

Line 5255: from DUAL union all

5251: (
5252: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
5253: from DUAL union all
5254: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5255: from DUAL union all
5256: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
5257: from DUAL union all
5258: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5259: from DUAL union all

Line 5257: from DUAL union all

5253: from DUAL union all
5254: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5255: from DUAL union all
5256: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
5257: from DUAL union all
5258: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5259: from DUAL union all
5260: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
5261: from DUAL union all

Line 5259: from DUAL union all

5255: from DUAL union all
5256: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
5257: from DUAL union all
5258: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5259: from DUAL union all
5260: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
5261: from DUAL union all
5262: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5263: from DUAL union all

Line 5261: from DUAL union all

5257: from DUAL union all
5258: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5259: from DUAL union all
5260: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
5261: from DUAL union all
5262: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5263: from DUAL union all
5264: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
5265: from DUAL union all

Line 5263: from DUAL union all

5259: from DUAL union all
5260: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
5261: from DUAL union all
5262: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5263: from DUAL union all
5264: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
5265: from DUAL union all
5266: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5267: from DUAL

Line 5265: from DUAL union all

5261: from DUAL union all
5262: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5263: from DUAL union all
5264: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
5265: from DUAL union all
5266: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5267: from DUAL
5268: ) fin_plan,
5269: (

Line 5267: from DUAL

5263: from DUAL union all
5264: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
5265: from DUAL union all
5266: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5267: from DUAL
5268: ) fin_plan,
5269: (
5270: select 1 WBS_SUP_LEVEL,
5271: 1 WBS_SUB_LEVEL,

Line 5273: from DUAL

5269: (
5270: select 1 WBS_SUP_LEVEL,
5271: 1 WBS_SUB_LEVEL,
5272: 'PRJ' INVERT_ID
5273: from DUAL
5274: union all
5275: select 1 WBS_SUP_LEVEL,
5276: 1 WBS_SUB_LEVEL,
5277: 'WBS' INVERT_ID

Line 5278: from DUAL

5274: union all
5275: select 1 WBS_SUP_LEVEL,
5276: 1 WBS_SUB_LEVEL,
5277: 'WBS' INVERT_ID
5278: from DUAL
5279: ) top_slice
5280: where
5281: prg.STRUCT_TYPE = 'PRG' and
5282: prg.SUP_LEVEL = l_level and

Line 5407: from DUAL union all

5403: (
5404: select 'Y' CB_FLAG,
5405: 'N' CO_FLAG,
5406: -3 PLAN_VERSION_ID
5407: from DUAL union all
5408: select 'N' CB_FLAG,
5409: 'Y' CO_FLAG,
5410: -4 PLAN_VERSION_ID
5411: from DUAL union all

Line 5411: from DUAL union all

5407: from DUAL union all
5408: select 'N' CB_FLAG,
5409: 'Y' CO_FLAG,
5410: -4 PLAN_VERSION_ID
5411: from DUAL union all
5412: select 'Y' CB_FLAG,
5413: 'Y' CO_FLAG,
5414: -3 PLAN_VERSION_ID
5415: from DUAL union all

Line 5415: from DUAL union all

5411: from DUAL union all
5412: select 'Y' CB_FLAG,
5413: 'Y' CO_FLAG,
5414: -3 PLAN_VERSION_ID
5415: from DUAL union all
5416: select 'Y' CB_FLAG,
5417: 'Y' CO_FLAG,
5418: -4 PLAN_VERSION_ID
5419: from DUAL

Line 5419: from DUAL

5415: from DUAL union all
5416: select 'Y' CB_FLAG,
5417: 'Y' CO_FLAG,
5418: -4 PLAN_VERSION_ID
5419: from DUAL
5420: ) fin_plan
5421: where
5422: prg.STRUCT_TYPE = 'PRG' and
5423: prg.SUP_LEVEL = l_level and

Line 5558: from DUAL union all

5554: PJI_XBS_DENORM prg,
5555: PJI_FP_XBS_ACCUM_F fpr,
5556: (
5557: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
5558: from DUAL union all
5559: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5560: from DUAL union all
5561: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
5562: from DUAL union all

Line 5560: from DUAL union all

5556: (
5557: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
5558: from DUAL union all
5559: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5560: from DUAL union all
5561: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
5562: from DUAL union all
5563: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5564: from DUAL union all

Line 5562: from DUAL union all

5558: from DUAL union all
5559: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5560: from DUAL union all
5561: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
5562: from DUAL union all
5563: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5564: from DUAL union all
5565: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
5566: from DUAL union all

Line 5564: from DUAL union all

5560: from DUAL union all
5561: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
5562: from DUAL union all
5563: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5564: from DUAL union all
5565: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
5566: from DUAL union all
5567: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5568: from DUAL union all

Line 5566: from DUAL union all

5562: from DUAL union all
5563: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5564: from DUAL union all
5565: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
5566: from DUAL union all
5567: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5568: from DUAL union all
5569: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
5570: from DUAL union all

Line 5568: from DUAL union all

5564: from DUAL union all
5565: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
5566: from DUAL union all
5567: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5568: from DUAL union all
5569: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
5570: from DUAL union all
5571: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5572: from DUAL

Line 5570: from DUAL union all

5566: from DUAL union all
5567: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5568: from DUAL union all
5569: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
5570: from DUAL union all
5571: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5572: from DUAL
5573: ) fin_plan,
5574: (

Line 5572: from DUAL

5568: from DUAL union all
5569: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
5570: from DUAL union all
5571: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
5572: from DUAL
5573: ) fin_plan,
5574: (
5575: select 1 WBS_SUP_LEVEL,
5576: 1 WBS_SUB_LEVEL,

Line 5578: from DUAL

5574: (
5575: select 1 WBS_SUP_LEVEL,
5576: 1 WBS_SUB_LEVEL,
5577: 'PRJ' INVERT_ID
5578: from DUAL
5579: union all
5580: select 1 WBS_SUP_LEVEL,
5581: 1 WBS_SUB_LEVEL,
5582: 'WBS' INVERT_ID

Line 5583: from DUAL

5579: union all
5580: select 1 WBS_SUP_LEVEL,
5581: 1 WBS_SUB_LEVEL,
5582: 'WBS' INVERT_ID
5583: from DUAL
5584: ) top_slice
5585: where
5586: prg.STRUCT_TYPE = 'PRG' and
5587: prg.SUP_LEVEL = l_level and

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

5640: from
5641: PJI_PJP_PROJ_BATCH_MAP map,
5642: PJI_XBS_DENORM prg,
5643: (
5644: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
5645: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
5646: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
5647: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
5648: ) invert,

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

5641: PJI_PJP_PROJ_BATCH_MAP map,
5642: PJI_XBS_DENORM prg,
5643: (
5644: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
5645: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
5646: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
5647: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
5648: ) invert,
5649: PJI_XBS_DENORM_DELTA prg_delta

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

5642: PJI_XBS_DENORM prg,
5643: (
5644: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
5645: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
5646: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
5647: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
5648: ) invert,
5649: PJI_XBS_DENORM_DELTA prg_delta
5650: where

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

5643: (
5644: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
5645: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
5646: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
5647: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
5648: ) invert,
5649: PJI_XBS_DENORM_DELTA prg_delta
5650: where
5651: prg.STRUCT_TYPE = 'PRG' and

Line 6568: from DUAL union all

6564: PA_XBS_DENORM wbs,
6565: PJI_XBS_DENORM prg,
6566: (
6567: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
6568: from DUAL union all
6569: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6570: from DUAL union all
6571: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
6572: from DUAL union all

Line 6570: from DUAL union all

6566: (
6567: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
6568: from DUAL union all
6569: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6570: from DUAL union all
6571: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
6572: from DUAL union all
6573: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6574: from DUAL union all

Line 6572: from DUAL union all

6568: from DUAL union all
6569: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6570: from DUAL union all
6571: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
6572: from DUAL union all
6573: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6574: from DUAL union all
6575: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
6576: from DUAL union all

Line 6574: from DUAL union all

6570: from DUAL union all
6571: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
6572: from DUAL union all
6573: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6574: from DUAL union all
6575: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
6576: from DUAL union all
6577: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6578: from DUAL union all

Line 6576: from DUAL union all

6572: from DUAL union all
6573: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6574: from DUAL union all
6575: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
6576: from DUAL union all
6577: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6578: from DUAL union all
6579: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
6580: from DUAL union all

Line 6578: from DUAL union all

6574: from DUAL union all
6575: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
6576: from DUAL union all
6577: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6578: from DUAL union all
6579: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
6580: from DUAL union all
6581: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6582: from DUAL

Line 6580: from DUAL union all

6576: from DUAL union all
6577: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6578: from DUAL union all
6579: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
6580: from DUAL union all
6581: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6582: from DUAL
6583: ) fin_plan,
6584: (

Line 6582: from DUAL

6578: from DUAL union all
6579: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
6580: from DUAL union all
6581: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6582: from DUAL
6583: ) fin_plan,
6584: (
6585: select 1 WBS_SUP_LEVEL,
6586: 1 WBS_SUB_LEVEL,

Line 6588: from DUAL

6584: (
6585: select 1 WBS_SUP_LEVEL,
6586: 1 WBS_SUB_LEVEL,
6587: 'PRJ' INVERT_ID
6588: from DUAL
6589: union all
6590: select 1 WBS_SUP_LEVEL,
6591: 1 WBS_SUB_LEVEL,
6592: 'WBS' INVERT_ID

Line 6593: from DUAL

6589: union all
6590: select 1 WBS_SUP_LEVEL,
6591: 1 WBS_SUB_LEVEL,
6592: 'WBS' INVERT_ID
6593: from DUAL
6594: ) top_slice
6595: where
6596: prg.STRUCT_TYPE = 'PRG' and
6597: prg.SUP_LEVEL = l_level and

Line 6722: from DUAL union all

6718: (
6719: select 'Y' CB_FLAG,
6720: 'N' CO_FLAG,
6721: -3 PLAN_VERSION_ID
6722: from DUAL union all
6723: select 'N' CB_FLAG,
6724: 'Y' CO_FLAG,
6725: -4 PLAN_VERSION_ID
6726: from DUAL union all

Line 6726: from DUAL union all

6722: from DUAL union all
6723: select 'N' CB_FLAG,
6724: 'Y' CO_FLAG,
6725: -4 PLAN_VERSION_ID
6726: from DUAL union all
6727: select 'Y' CB_FLAG,
6728: 'Y' CO_FLAG,
6729: -3 PLAN_VERSION_ID
6730: from DUAL union all

Line 6730: from DUAL union all

6726: from DUAL union all
6727: select 'Y' CB_FLAG,
6728: 'Y' CO_FLAG,
6729: -3 PLAN_VERSION_ID
6730: from DUAL union all
6731: select 'Y' CB_FLAG,
6732: 'Y' CO_FLAG,
6733: -4 PLAN_VERSION_ID
6734: from DUAL

Line 6734: from DUAL

6730: from DUAL union all
6731: select 'Y' CB_FLAG,
6732: 'Y' CO_FLAG,
6733: -4 PLAN_VERSION_ID
6734: from DUAL
6735: ) fin_plan
6736: where
6737: prg.STRUCT_TYPE = 'PRG' and
6738: prg.SUP_LEVEL = l_level and

Line 6873: from DUAL union all

6869: PJI_XBS_DENORM prg,
6870: PJI_FP_XBS_ACCUM_F fpr,
6871: (
6872: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
6873: from DUAL union all
6874: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6875: from DUAL union all
6876: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
6877: from DUAL union all

Line 6875: from DUAL union all

6871: (
6872: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
6873: from DUAL union all
6874: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6875: from DUAL union all
6876: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
6877: from DUAL union all
6878: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6879: from DUAL union all

Line 6877: from DUAL union all

6873: from DUAL union all
6874: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6875: from DUAL union all
6876: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
6877: from DUAL union all
6878: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6879: from DUAL union all
6880: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
6881: from DUAL union all

Line 6879: from DUAL union all

6875: from DUAL union all
6876: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
6877: from DUAL union all
6878: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6879: from DUAL union all
6880: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
6881: from DUAL union all
6882: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6883: from DUAL union all

Line 6881: from DUAL union all

6877: from DUAL union all
6878: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6879: from DUAL union all
6880: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
6881: from DUAL union all
6882: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6883: from DUAL union all
6884: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
6885: from DUAL union all

Line 6883: from DUAL union all

6879: from DUAL union all
6880: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
6881: from DUAL union all
6882: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6883: from DUAL union all
6884: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
6885: from DUAL union all
6886: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6887: from DUAL

Line 6885: from DUAL union all

6881: from DUAL union all
6882: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6883: from DUAL union all
6884: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
6885: from DUAL union all
6886: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6887: from DUAL
6888: ) fin_plan,
6889: (

Line 6887: from DUAL

6883: from DUAL union all
6884: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
6885: from DUAL union all
6886: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
6887: from DUAL
6888: ) fin_plan,
6889: (
6890: select 1 WBS_SUP_LEVEL,
6891: 1 WBS_SUB_LEVEL,

Line 6893: from DUAL

6889: (
6890: select 1 WBS_SUP_LEVEL,
6891: 1 WBS_SUB_LEVEL,
6892: 'PRJ' INVERT_ID
6893: from DUAL
6894: union all
6895: select 1 WBS_SUP_LEVEL,
6896: 1 WBS_SUB_LEVEL,
6897: 'WBS' INVERT_ID

Line 6898: from DUAL

6894: union all
6895: select 1 WBS_SUP_LEVEL,
6896: 1 WBS_SUB_LEVEL,
6897: 'WBS' INVERT_ID
6898: from DUAL
6899: ) top_slice
6900: where
6901: prg.STRUCT_TYPE = 'PRG' and
6902: prg.SUP_LEVEL = l_level and

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

6955: from
6956: PJI_PJP_PROJ_BATCH_MAP map,
6957: PJI_XBS_DENORM prg,
6958: (
6959: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
6960: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
6961: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
6962: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
6963: ) invert,

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

6956: PJI_PJP_PROJ_BATCH_MAP map,
6957: PJI_XBS_DENORM prg,
6958: (
6959: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
6960: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
6961: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
6962: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
6963: ) invert,
6964: PJI_XBS_DENORM_DELTA prg_delta

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

6957: PJI_XBS_DENORM prg,
6958: (
6959: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
6960: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
6961: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
6962: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
6963: ) invert,
6964: PJI_XBS_DENORM_DELTA prg_delta
6965: where

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

6958: (
6959: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
6960: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
6961: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
6962: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
6963: ) invert,
6964: PJI_XBS_DENORM_DELTA prg_delta
6965: where
6966: prg.STRUCT_TYPE = 'PRG' and

Line 7882: from DUAL union all

7878: PA_XBS_DENORM wbs,
7879: PJI_XBS_DENORM prg,
7880: (
7881: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7882: from DUAL union all
7883: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7884: from DUAL union all
7885: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7886: from DUAL union all

Line 7884: from DUAL union all

7880: (
7881: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7882: from DUAL union all
7883: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7884: from DUAL union all
7885: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7886: from DUAL union all
7887: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7888: from DUAL union all

Line 7886: from DUAL union all

7882: from DUAL union all
7883: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7884: from DUAL union all
7885: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7886: from DUAL union all
7887: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7888: from DUAL union all
7889: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7890: from DUAL union all

Line 7888: from DUAL union all

7884: from DUAL union all
7885: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7886: from DUAL union all
7887: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7888: from DUAL union all
7889: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7890: from DUAL union all
7891: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7892: from DUAL union all

Line 7890: from DUAL union all

7886: from DUAL union all
7887: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7888: from DUAL union all
7889: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7890: from DUAL union all
7891: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7892: from DUAL union all
7893: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7894: from DUAL union all

Line 7892: from DUAL union all

7888: from DUAL union all
7889: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
7890: from DUAL union all
7891: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7892: from DUAL union all
7893: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7894: from DUAL union all
7895: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7896: from DUAL

Line 7894: from DUAL union all

7890: from DUAL union all
7891: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7892: from DUAL union all
7893: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7894: from DUAL union all
7895: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7896: from DUAL
7897: ) fin_plan,
7898: (

Line 7896: from DUAL

7892: from DUAL union all
7893: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
7894: from DUAL union all
7895: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
7896: from DUAL
7897: ) fin_plan,
7898: (
7899: select 1 WBS_SUP_LEVEL,
7900: 1 WBS_SUB_LEVEL,

Line 7902: from DUAL

7898: (
7899: select 1 WBS_SUP_LEVEL,
7900: 1 WBS_SUB_LEVEL,
7901: 'PRJ' INVERT_ID
7902: from DUAL
7903: union all
7904: select 1 WBS_SUP_LEVEL,
7905: 1 WBS_SUB_LEVEL,
7906: 'WBS' INVERT_ID

Line 7907: from DUAL

7903: union all
7904: select 1 WBS_SUP_LEVEL,
7905: 1 WBS_SUB_LEVEL,
7906: 'WBS' INVERT_ID
7907: from DUAL
7908: ) top_slice
7909: where
7910: prg.STRUCT_TYPE = 'PRG' and
7911: prg.SUP_LEVEL = l_level and

Line 8036: from DUAL union all

8032: (
8033: select 'Y' CB_FLAG,
8034: 'N' CO_FLAG,
8035: -3 PLAN_VERSION_ID
8036: from DUAL union all
8037: select 'N' CB_FLAG,
8038: 'Y' CO_FLAG,
8039: -4 PLAN_VERSION_ID
8040: from DUAL union all

Line 8040: from DUAL union all

8036: from DUAL union all
8037: select 'N' CB_FLAG,
8038: 'Y' CO_FLAG,
8039: -4 PLAN_VERSION_ID
8040: from DUAL union all
8041: select 'Y' CB_FLAG,
8042: 'Y' CO_FLAG,
8043: -3 PLAN_VERSION_ID
8044: from DUAL union all

Line 8044: from DUAL union all

8040: from DUAL union all
8041: select 'Y' CB_FLAG,
8042: 'Y' CO_FLAG,
8043: -3 PLAN_VERSION_ID
8044: from DUAL union all
8045: select 'Y' CB_FLAG,
8046: 'Y' CO_FLAG,
8047: -4 PLAN_VERSION_ID
8048: from DUAL

Line 8048: from DUAL

8044: from DUAL union all
8045: select 'Y' CB_FLAG,
8046: 'Y' CO_FLAG,
8047: -4 PLAN_VERSION_ID
8048: from DUAL
8049: ) fin_plan
8050: where
8051: prg.STRUCT_TYPE = 'PRG' and
8052: prg.SUP_LEVEL = l_level and

Line 8187: from DUAL union all

8183: PJI_XBS_DENORM prg,
8184: PJI_FP_XBS_ACCUM_F fpr,
8185: (
8186: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8187: from DUAL union all
8188: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8189: from DUAL union all
8190: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8191: from DUAL union all

Line 8189: from DUAL union all

8185: (
8186: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8187: from DUAL union all
8188: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8189: from DUAL union all
8190: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8191: from DUAL union all
8192: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8193: from DUAL union all

Line 8191: from DUAL union all

8187: from DUAL union all
8188: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8189: from DUAL union all
8190: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8191: from DUAL union all
8192: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8193: from DUAL union all
8194: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8195: from DUAL union all

Line 8193: from DUAL union all

8189: from DUAL union all
8190: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8191: from DUAL union all
8192: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8193: from DUAL union all
8194: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8195: from DUAL union all
8196: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8197: from DUAL union all

Line 8195: from DUAL union all

8191: from DUAL union all
8192: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8193: from DUAL union all
8194: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8195: from DUAL union all
8196: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8197: from DUAL union all
8198: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8199: from DUAL union all

Line 8197: from DUAL union all

8193: from DUAL union all
8194: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8195: from DUAL union all
8196: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8197: from DUAL union all
8198: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8199: from DUAL union all
8200: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8201: from DUAL

Line 8199: from DUAL union all

8195: from DUAL union all
8196: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8197: from DUAL union all
8198: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8199: from DUAL union all
8200: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8201: from DUAL
8202: ) fin_plan,
8203: (

Line 8201: from DUAL

8197: from DUAL union all
8198: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8199: from DUAL union all
8200: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8201: from DUAL
8202: ) fin_plan,
8203: (
8204: select 1 WBS_SUP_LEVEL,
8205: 1 WBS_SUB_LEVEL,

Line 8207: from DUAL

8203: (
8204: select 1 WBS_SUP_LEVEL,
8205: 1 WBS_SUB_LEVEL,
8206: 'PRJ' INVERT_ID
8207: from DUAL
8208: union all
8209: select 1 WBS_SUP_LEVEL,
8210: 1 WBS_SUB_LEVEL,
8211: 'WBS' INVERT_ID

Line 8212: from DUAL

8208: union all
8209: select 1 WBS_SUP_LEVEL,
8210: 1 WBS_SUB_LEVEL,
8211: 'WBS' INVERT_ID
8212: from DUAL
8213: ) top_slice
8214: where
8215: prg.STRUCT_TYPE = 'PRG' and
8216: prg.SUP_LEVEL = l_level and

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

8269: from
8270: PJI_PJP_PROJ_BATCH_MAP map,
8271: PJI_XBS_DENORM prg,
8272: (
8273: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8274: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8275: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8276: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
8277: ) invert,

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

8270: PJI_PJP_PROJ_BATCH_MAP map,
8271: PJI_XBS_DENORM prg,
8272: (
8273: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8274: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8275: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8276: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
8277: ) invert,
8278: PJI_XBS_DENORM_DELTA prg_delta

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

8271: PJI_XBS_DENORM prg,
8272: (
8273: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8274: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8275: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8276: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
8277: ) invert,
8278: PJI_XBS_DENORM_DELTA prg_delta
8279: where

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

8272: (
8273: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8274: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8275: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8276: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
8277: ) invert,
8278: PJI_XBS_DENORM_DELTA prg_delta
8279: where
8280: prg.STRUCT_TYPE = 'PRG' and

Line 9196: from DUAL union all

9192: PA_XBS_DENORM wbs,
9193: PJI_XBS_DENORM prg,
9194: (
9195: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9196: from DUAL union all
9197: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9198: from DUAL union all
9199: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9200: from DUAL union all

Line 9198: from DUAL union all

9194: (
9195: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9196: from DUAL union all
9197: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9198: from DUAL union all
9199: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9200: from DUAL union all
9201: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9202: from DUAL union all

Line 9200: from DUAL union all

9196: from DUAL union all
9197: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9198: from DUAL union all
9199: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9200: from DUAL union all
9201: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9202: from DUAL union all
9203: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9204: from DUAL union all

Line 9202: from DUAL union all

9198: from DUAL union all
9199: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9200: from DUAL union all
9201: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9202: from DUAL union all
9203: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9204: from DUAL union all
9205: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9206: from DUAL union all

Line 9204: from DUAL union all

9200: from DUAL union all
9201: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9202: from DUAL union all
9203: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9204: from DUAL union all
9205: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9206: from DUAL union all
9207: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9208: from DUAL union all

Line 9206: from DUAL union all

9202: from DUAL union all
9203: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9204: from DUAL union all
9205: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9206: from DUAL union all
9207: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9208: from DUAL union all
9209: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9210: from DUAL

Line 9208: from DUAL union all

9204: from DUAL union all
9205: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9206: from DUAL union all
9207: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9208: from DUAL union all
9209: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9210: from DUAL
9211: ) fin_plan,
9212: (

Line 9210: from DUAL

9206: from DUAL union all
9207: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9208: from DUAL union all
9209: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9210: from DUAL
9211: ) fin_plan,
9212: (
9213: select 1 WBS_SUP_LEVEL,
9214: 1 WBS_SUB_LEVEL,

Line 9216: from DUAL

9212: (
9213: select 1 WBS_SUP_LEVEL,
9214: 1 WBS_SUB_LEVEL,
9215: 'PRJ' INVERT_ID
9216: from DUAL
9217: union all
9218: select 1 WBS_SUP_LEVEL,
9219: 1 WBS_SUB_LEVEL,
9220: 'WBS' INVERT_ID

Line 9221: from DUAL

9217: union all
9218: select 1 WBS_SUP_LEVEL,
9219: 1 WBS_SUB_LEVEL,
9220: 'WBS' INVERT_ID
9221: from DUAL
9222: ) top_slice
9223: where
9224: prg.STRUCT_TYPE = 'PRG' and
9225: prg.SUP_LEVEL = l_level and

Line 9350: from DUAL union all

9346: (
9347: select 'Y' CB_FLAG,
9348: 'N' CO_FLAG,
9349: -3 PLAN_VERSION_ID
9350: from DUAL union all
9351: select 'N' CB_FLAG,
9352: 'Y' CO_FLAG,
9353: -4 PLAN_VERSION_ID
9354: from DUAL union all

Line 9354: from DUAL union all

9350: from DUAL union all
9351: select 'N' CB_FLAG,
9352: 'Y' CO_FLAG,
9353: -4 PLAN_VERSION_ID
9354: from DUAL union all
9355: select 'Y' CB_FLAG,
9356: 'Y' CO_FLAG,
9357: -3 PLAN_VERSION_ID
9358: from DUAL union all

Line 9358: from DUAL union all

9354: from DUAL union all
9355: select 'Y' CB_FLAG,
9356: 'Y' CO_FLAG,
9357: -3 PLAN_VERSION_ID
9358: from DUAL union all
9359: select 'Y' CB_FLAG,
9360: 'Y' CO_FLAG,
9361: -4 PLAN_VERSION_ID
9362: from DUAL

Line 9362: from DUAL

9358: from DUAL union all
9359: select 'Y' CB_FLAG,
9360: 'Y' CO_FLAG,
9361: -4 PLAN_VERSION_ID
9362: from DUAL
9363: ) fin_plan
9364: where
9365: prg.STRUCT_TYPE = 'PRG' and
9366: prg.SUP_LEVEL = l_level and

Line 9501: from DUAL union all

9497: PJI_XBS_DENORM prg,
9498: PJI_FP_XBS_ACCUM_F fpr,
9499: (
9500: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9501: from DUAL union all
9502: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9503: from DUAL union all
9504: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9505: from DUAL union all

Line 9503: from DUAL union all

9499: (
9500: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9501: from DUAL union all
9502: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9503: from DUAL union all
9504: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9505: from DUAL union all
9506: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9507: from DUAL union all

Line 9505: from DUAL union all

9501: from DUAL union all
9502: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9503: from DUAL union all
9504: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9505: from DUAL union all
9506: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9507: from DUAL union all
9508: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9509: from DUAL union all

Line 9507: from DUAL union all

9503: from DUAL union all
9504: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9505: from DUAL union all
9506: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9507: from DUAL union all
9508: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9509: from DUAL union all
9510: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9511: from DUAL union all

Line 9509: from DUAL union all

9505: from DUAL union all
9506: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9507: from DUAL union all
9508: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9509: from DUAL union all
9510: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9511: from DUAL union all
9512: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9513: from DUAL union all

Line 9511: from DUAL union all

9507: from DUAL union all
9508: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9509: from DUAL union all
9510: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9511: from DUAL union all
9512: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9513: from DUAL union all
9514: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9515: from DUAL

Line 9513: from DUAL union all

9509: from DUAL union all
9510: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9511: from DUAL union all
9512: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9513: from DUAL union all
9514: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9515: from DUAL
9516: ) fin_plan,
9517: (

Line 9515: from DUAL

9511: from DUAL union all
9512: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9513: from DUAL union all
9514: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9515: from DUAL
9516: ) fin_plan,
9517: (
9518: select 1 WBS_SUP_LEVEL,
9519: 1 WBS_SUB_LEVEL,

Line 9521: from DUAL

9517: (
9518: select 1 WBS_SUP_LEVEL,
9519: 1 WBS_SUB_LEVEL,
9520: 'PRJ' INVERT_ID
9521: from DUAL
9522: union all
9523: select 1 WBS_SUP_LEVEL,
9524: 1 WBS_SUB_LEVEL,
9525: 'WBS' INVERT_ID

Line 9526: from DUAL

9522: union all
9523: select 1 WBS_SUP_LEVEL,
9524: 1 WBS_SUB_LEVEL,
9525: 'WBS' INVERT_ID
9526: from DUAL
9527: ) top_slice
9528: where
9529: prg.STRUCT_TYPE = 'PRG' and
9530: prg.SUP_LEVEL = l_level and

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

9583: from
9584: PJI_PJP_PROJ_BATCH_MAP map,
9585: PJI_XBS_DENORM prg,
9586: (
9587: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9588: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
9589: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9590: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
9591: ) invert,

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

9584: PJI_PJP_PROJ_BATCH_MAP map,
9585: PJI_XBS_DENORM prg,
9586: (
9587: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9588: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
9589: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9590: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
9591: ) invert,
9592: PJI_XBS_DENORM_DELTA prg_delta

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

9585: PJI_XBS_DENORM prg,
9586: (
9587: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9588: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
9589: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9590: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
9591: ) invert,
9592: PJI_XBS_DENORM_DELTA prg_delta
9593: where

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

9586: (
9587: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9588: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
9589: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
9590: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
9591: ) invert,
9592: PJI_XBS_DENORM_DELTA prg_delta
9593: where
9594: prg.STRUCT_TYPE = 'PRG' and

Line 10510: from DUAL union all

10506: PA_XBS_DENORM wbs,
10507: PJI_XBS_DENORM prg,
10508: (
10509: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10510: from DUAL union all
10511: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10512: from DUAL union all
10513: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10514: from DUAL union all

Line 10512: from DUAL union all

10508: (
10509: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10510: from DUAL union all
10511: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10512: from DUAL union all
10513: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10514: from DUAL union all
10515: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10516: from DUAL union all

Line 10514: from DUAL union all

10510: from DUAL union all
10511: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10512: from DUAL union all
10513: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10514: from DUAL union all
10515: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10516: from DUAL union all
10517: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10518: from DUAL union all

Line 10516: from DUAL union all

10512: from DUAL union all
10513: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10514: from DUAL union all
10515: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10516: from DUAL union all
10517: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10518: from DUAL union all
10519: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10520: from DUAL union all

Line 10518: from DUAL union all

10514: from DUAL union all
10515: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10516: from DUAL union all
10517: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10518: from DUAL union all
10519: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10520: from DUAL union all
10521: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10522: from DUAL union all

Line 10520: from DUAL union all

10516: from DUAL union all
10517: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10518: from DUAL union all
10519: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10520: from DUAL union all
10521: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10522: from DUAL union all
10523: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10524: from DUAL

Line 10522: from DUAL union all

10518: from DUAL union all
10519: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10520: from DUAL union all
10521: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10522: from DUAL union all
10523: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10524: from DUAL
10525: ) fin_plan,
10526: (

Line 10524: from DUAL

10520: from DUAL union all
10521: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10522: from DUAL union all
10523: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10524: from DUAL
10525: ) fin_plan,
10526: (
10527: select 1 WBS_SUP_LEVEL,
10528: 1 WBS_SUB_LEVEL,

Line 10530: from DUAL

10526: (
10527: select 1 WBS_SUP_LEVEL,
10528: 1 WBS_SUB_LEVEL,
10529: 'PRJ' INVERT_ID
10530: from DUAL
10531: union all
10532: select 1 WBS_SUP_LEVEL,
10533: 1 WBS_SUB_LEVEL,
10534: 'WBS' INVERT_ID

Line 10535: from DUAL

10531: union all
10532: select 1 WBS_SUP_LEVEL,
10533: 1 WBS_SUB_LEVEL,
10534: 'WBS' INVERT_ID
10535: from DUAL
10536: ) top_slice
10537: where
10538: prg.STRUCT_TYPE = 'PRG' and
10539: prg.SUP_LEVEL = l_level and

Line 10664: from DUAL union all

10660: (
10661: select 'Y' CB_FLAG,
10662: 'N' CO_FLAG,
10663: -3 PLAN_VERSION_ID
10664: from DUAL union all
10665: select 'N' CB_FLAG,
10666: 'Y' CO_FLAG,
10667: -4 PLAN_VERSION_ID
10668: from DUAL union all

Line 10668: from DUAL union all

10664: from DUAL union all
10665: select 'N' CB_FLAG,
10666: 'Y' CO_FLAG,
10667: -4 PLAN_VERSION_ID
10668: from DUAL union all
10669: select 'Y' CB_FLAG,
10670: 'Y' CO_FLAG,
10671: -3 PLAN_VERSION_ID
10672: from DUAL union all

Line 10672: from DUAL union all

10668: from DUAL union all
10669: select 'Y' CB_FLAG,
10670: 'Y' CO_FLAG,
10671: -3 PLAN_VERSION_ID
10672: from DUAL union all
10673: select 'Y' CB_FLAG,
10674: 'Y' CO_FLAG,
10675: -4 PLAN_VERSION_ID
10676: from DUAL

Line 10676: from DUAL

10672: from DUAL union all
10673: select 'Y' CB_FLAG,
10674: 'Y' CO_FLAG,
10675: -4 PLAN_VERSION_ID
10676: from DUAL
10677: ) fin_plan
10678: where
10679: prg.STRUCT_TYPE = 'PRG' and
10680: prg.SUP_LEVEL = l_level and

Line 10815: from DUAL union all

10811: PJI_XBS_DENORM prg,
10812: PJI_FP_XBS_ACCUM_F fpr,
10813: (
10814: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10815: from DUAL union all
10816: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10817: from DUAL union all
10818: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10819: from DUAL union all

Line 10817: from DUAL union all

10813: (
10814: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10815: from DUAL union all
10816: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10817: from DUAL union all
10818: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10819: from DUAL union all
10820: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10821: from DUAL union all

Line 10819: from DUAL union all

10815: from DUAL union all
10816: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10817: from DUAL union all
10818: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10819: from DUAL union all
10820: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10821: from DUAL union all
10822: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10823: from DUAL union all

Line 10821: from DUAL union all

10817: from DUAL union all
10818: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10819: from DUAL union all
10820: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10821: from DUAL union all
10822: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10823: from DUAL union all
10824: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10825: from DUAL union all

Line 10823: from DUAL union all

10819: from DUAL union all
10820: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10821: from DUAL union all
10822: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10823: from DUAL union all
10824: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10825: from DUAL union all
10826: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10827: from DUAL union all

Line 10825: from DUAL union all

10821: from DUAL union all
10822: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10823: from DUAL union all
10824: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10825: from DUAL union all
10826: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10827: from DUAL union all
10828: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10829: from DUAL

Line 10827: from DUAL union all

10823: from DUAL union all
10824: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10825: from DUAL union all
10826: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10827: from DUAL union all
10828: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10829: from DUAL
10830: ) fin_plan,
10831: (

Line 10829: from DUAL

10825: from DUAL union all
10826: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10827: from DUAL union all
10828: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10829: from DUAL
10830: ) fin_plan,
10831: (
10832: select 1 WBS_SUP_LEVEL,
10833: 1 WBS_SUB_LEVEL,

Line 10835: from DUAL

10831: (
10832: select 1 WBS_SUP_LEVEL,
10833: 1 WBS_SUB_LEVEL,
10834: 'PRJ' INVERT_ID
10835: from DUAL
10836: union all
10837: select 1 WBS_SUP_LEVEL,
10838: 1 WBS_SUB_LEVEL,
10839: 'WBS' INVERT_ID

Line 10840: from DUAL

10836: union all
10837: select 1 WBS_SUP_LEVEL,
10838: 1 WBS_SUB_LEVEL,
10839: 'WBS' INVERT_ID
10840: from DUAL
10841: ) top_slice
10842: where
10843: prg.STRUCT_TYPE = 'PRG' and
10844: prg.SUP_LEVEL = l_level and

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

10897: from
10898: PJI_PJP_PROJ_BATCH_MAP map,
10899: PJI_XBS_DENORM prg,
10900: (
10901: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10902: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
10903: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10904: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
10905: ) invert,

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

10898: PJI_PJP_PROJ_BATCH_MAP map,
10899: PJI_XBS_DENORM prg,
10900: (
10901: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10902: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
10903: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10904: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
10905: ) invert,
10906: PJI_XBS_DENORM_DELTA prg_delta

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

10899: PJI_XBS_DENORM prg,
10900: (
10901: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10902: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
10903: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10904: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
10905: ) invert,
10906: PJI_XBS_DENORM_DELTA prg_delta
10907: where

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

10900: (
10901: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10902: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
10903: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10904: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
10905: ) invert,
10906: PJI_XBS_DENORM_DELTA prg_delta
10907: where
10908: prg.STRUCT_TYPE = 'PRG' and

Line 11824: from DUAL union all

11820: PA_XBS_DENORM wbs,
11821: PJI_XBS_DENORM prg,
11822: (
11823: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11824: from DUAL union all
11825: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11826: from DUAL union all
11827: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11828: from DUAL union all

Line 11826: from DUAL union all

11822: (
11823: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11824: from DUAL union all
11825: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11826: from DUAL union all
11827: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11828: from DUAL union all
11829: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11830: from DUAL union all

Line 11828: from DUAL union all

11824: from DUAL union all
11825: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11826: from DUAL union all
11827: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11828: from DUAL union all
11829: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11830: from DUAL union all
11831: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11832: from DUAL union all

Line 11830: from DUAL union all

11826: from DUAL union all
11827: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11828: from DUAL union all
11829: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11830: from DUAL union all
11831: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11832: from DUAL union all
11833: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11834: from DUAL union all

Line 11832: from DUAL union all

11828: from DUAL union all
11829: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11830: from DUAL union all
11831: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11832: from DUAL union all
11833: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11834: from DUAL union all
11835: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11836: from DUAL union all

Line 11834: from DUAL union all

11830: from DUAL union all
11831: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11832: from DUAL union all
11833: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11834: from DUAL union all
11835: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11836: from DUAL union all
11837: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11838: from DUAL

Line 11836: from DUAL union all

11832: from DUAL union all
11833: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11834: from DUAL union all
11835: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11836: from DUAL union all
11837: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11838: from DUAL
11839: ) fin_plan,
11840: (

Line 11838: from DUAL

11834: from DUAL union all
11835: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11836: from DUAL union all
11837: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11838: from DUAL
11839: ) fin_plan,
11840: (
11841: select 1 WBS_SUP_LEVEL,
11842: 1 WBS_SUB_LEVEL,

Line 11844: from DUAL

11840: (
11841: select 1 WBS_SUP_LEVEL,
11842: 1 WBS_SUB_LEVEL,
11843: 'PRJ' INVERT_ID
11844: from DUAL
11845: union all
11846: select 1 WBS_SUP_LEVEL,
11847: 1 WBS_SUB_LEVEL,
11848: 'WBS' INVERT_ID

Line 11849: from DUAL

11845: union all
11846: select 1 WBS_SUP_LEVEL,
11847: 1 WBS_SUB_LEVEL,
11848: 'WBS' INVERT_ID
11849: from DUAL
11850: ) top_slice
11851: where
11852: prg.STRUCT_TYPE = 'PRG' and
11853: prg.SUP_LEVEL = l_level and

Line 11978: from DUAL union all

11974: (
11975: select 'Y' CB_FLAG,
11976: 'N' CO_FLAG,
11977: -3 PLAN_VERSION_ID
11978: from DUAL union all
11979: select 'N' CB_FLAG,
11980: 'Y' CO_FLAG,
11981: -4 PLAN_VERSION_ID
11982: from DUAL union all

Line 11982: from DUAL union all

11978: from DUAL union all
11979: select 'N' CB_FLAG,
11980: 'Y' CO_FLAG,
11981: -4 PLAN_VERSION_ID
11982: from DUAL union all
11983: select 'Y' CB_FLAG,
11984: 'Y' CO_FLAG,
11985: -3 PLAN_VERSION_ID
11986: from DUAL union all

Line 11986: from DUAL union all

11982: from DUAL union all
11983: select 'Y' CB_FLAG,
11984: 'Y' CO_FLAG,
11985: -3 PLAN_VERSION_ID
11986: from DUAL union all
11987: select 'Y' CB_FLAG,
11988: 'Y' CO_FLAG,
11989: -4 PLAN_VERSION_ID
11990: from DUAL

Line 11990: from DUAL

11986: from DUAL union all
11987: select 'Y' CB_FLAG,
11988: 'Y' CO_FLAG,
11989: -4 PLAN_VERSION_ID
11990: from DUAL
11991: ) fin_plan
11992: where
11993: prg.STRUCT_TYPE = 'PRG' and
11994: prg.SUP_LEVEL = l_level and

Line 12129: from DUAL union all

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

Line 12131: from DUAL union all

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

Line 12133: from DUAL union all

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

Line 12135: from DUAL union all

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

Line 12137: from DUAL union all

12133: from DUAL union all
12134: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12135: from DUAL union all
12136: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12137: from DUAL union all
12138: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12139: from DUAL union all
12140: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12141: from DUAL union all

Line 12139: from DUAL union all

12135: from DUAL union all
12136: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12137: from DUAL union all
12138: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12139: from DUAL union all
12140: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12141: from DUAL union all
12142: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12143: from DUAL

Line 12141: from DUAL union all

12137: from DUAL union all
12138: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12139: from DUAL union all
12140: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12141: from DUAL union all
12142: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12143: from DUAL
12144: ) fin_plan,
12145: (

Line 12143: from DUAL

12139: from DUAL union all
12140: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12141: from DUAL union all
12142: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12143: from DUAL
12144: ) fin_plan,
12145: (
12146: select 1 WBS_SUP_LEVEL,
12147: 1 WBS_SUB_LEVEL,

Line 12149: from DUAL

12145: (
12146: select 1 WBS_SUP_LEVEL,
12147: 1 WBS_SUB_LEVEL,
12148: 'PRJ' INVERT_ID
12149: from DUAL
12150: union all
12151: select 1 WBS_SUP_LEVEL,
12152: 1 WBS_SUB_LEVEL,
12153: 'WBS' INVERT_ID

Line 12154: from DUAL

12150: union all
12151: select 1 WBS_SUP_LEVEL,
12152: 1 WBS_SUB_LEVEL,
12153: 'WBS' INVERT_ID
12154: from DUAL
12155: ) top_slice
12156: where
12157: prg.STRUCT_TYPE = 'PRG' and
12158: prg.SUP_LEVEL = l_level and

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

12211: from
12212: PJI_PJP_PROJ_BATCH_MAP map,
12213: PJI_XBS_DENORM prg,
12214: (
12215: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12216: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
12217: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12218: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
12219: ) invert,

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

12212: PJI_PJP_PROJ_BATCH_MAP map,
12213: PJI_XBS_DENORM prg,
12214: (
12215: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12216: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
12217: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12218: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
12219: ) invert,
12220: PJI_XBS_DENORM_DELTA prg_delta

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

12213: PJI_XBS_DENORM prg,
12214: (
12215: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12216: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
12217: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12218: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
12219: ) invert,
12220: PJI_XBS_DENORM_DELTA prg_delta
12221: where

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

12214: (
12215: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12216: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
12217: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
12218: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
12219: ) invert,
12220: PJI_XBS_DENORM_DELTA prg_delta
12221: where
12222: prg.STRUCT_TYPE = 'PRG' and

Line 13138: from DUAL union all

13134: PA_XBS_DENORM wbs,
13135: PJI_XBS_DENORM prg,
13136: (
13137: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13138: from DUAL union all
13139: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13140: from DUAL union all
13141: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13142: from DUAL union all

Line 13140: from DUAL union all

13136: (
13137: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13138: from DUAL union all
13139: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13140: from DUAL union all
13141: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13142: from DUAL union all
13143: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13144: from DUAL union all

Line 13142: from DUAL union all

13138: from DUAL union all
13139: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13140: from DUAL union all
13141: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13142: from DUAL union all
13143: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13144: from DUAL union all
13145: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13146: from DUAL union all

Line 13144: from DUAL union all

13140: from DUAL union all
13141: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13142: from DUAL union all
13143: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13144: from DUAL union all
13145: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13146: from DUAL union all
13147: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13148: from DUAL union all

Line 13146: from DUAL union all

13142: from DUAL union all
13143: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13144: from DUAL union all
13145: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13146: from DUAL union all
13147: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13148: from DUAL union all
13149: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13150: from DUAL union all

Line 13148: from DUAL union all

13144: from DUAL union all
13145: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13146: from DUAL union all
13147: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13148: from DUAL union all
13149: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13150: from DUAL union all
13151: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13152: from DUAL

Line 13150: from DUAL union all

13146: from DUAL union all
13147: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13148: from DUAL union all
13149: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13150: from DUAL union all
13151: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13152: from DUAL
13153: ) fin_plan,
13154: (

Line 13152: from DUAL

13148: from DUAL union all
13149: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13150: from DUAL union all
13151: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13152: from DUAL
13153: ) fin_plan,
13154: (
13155: select 1 WBS_SUP_LEVEL,
13156: 1 WBS_SUB_LEVEL,

Line 13158: from DUAL

13154: (
13155: select 1 WBS_SUP_LEVEL,
13156: 1 WBS_SUB_LEVEL,
13157: 'PRJ' INVERT_ID
13158: from DUAL
13159: union all
13160: select 1 WBS_SUP_LEVEL,
13161: 1 WBS_SUB_LEVEL,
13162: 'WBS' INVERT_ID

Line 13163: from DUAL

13159: union all
13160: select 1 WBS_SUP_LEVEL,
13161: 1 WBS_SUB_LEVEL,
13162: 'WBS' INVERT_ID
13163: from DUAL
13164: ) top_slice
13165: where
13166: prg.STRUCT_TYPE = 'PRG' and
13167: prg.SUP_LEVEL = l_level and

Line 13292: from DUAL union all

13288: (
13289: select 'Y' CB_FLAG,
13290: 'N' CO_FLAG,
13291: -3 PLAN_VERSION_ID
13292: from DUAL union all
13293: select 'N' CB_FLAG,
13294: 'Y' CO_FLAG,
13295: -4 PLAN_VERSION_ID
13296: from DUAL union all

Line 13296: from DUAL union all

13292: from DUAL union all
13293: select 'N' CB_FLAG,
13294: 'Y' CO_FLAG,
13295: -4 PLAN_VERSION_ID
13296: from DUAL union all
13297: select 'Y' CB_FLAG,
13298: 'Y' CO_FLAG,
13299: -3 PLAN_VERSION_ID
13300: from DUAL union all

Line 13300: from DUAL union all

13296: from DUAL union all
13297: select 'Y' CB_FLAG,
13298: 'Y' CO_FLAG,
13299: -3 PLAN_VERSION_ID
13300: from DUAL union all
13301: select 'Y' CB_FLAG,
13302: 'Y' CO_FLAG,
13303: -4 PLAN_VERSION_ID
13304: from DUAL

Line 13304: from DUAL

13300: from DUAL union all
13301: select 'Y' CB_FLAG,
13302: 'Y' CO_FLAG,
13303: -4 PLAN_VERSION_ID
13304: from DUAL
13305: ) fin_plan
13306: where
13307: prg.STRUCT_TYPE = 'PRG' and
13308: prg.SUP_LEVEL = l_level and

Line 13443: from DUAL union all

13439: PJI_XBS_DENORM prg,
13440: PJI_FP_XBS_ACCUM_F fpr,
13441: (
13442: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13443: from DUAL union all
13444: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13445: from DUAL union all
13446: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13447: from DUAL union all

Line 13445: from DUAL union all

13441: (
13442: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13443: from DUAL union all
13444: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13445: from DUAL union all
13446: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13447: from DUAL union all
13448: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13449: from DUAL union all

Line 13447: from DUAL union all

13443: from DUAL union all
13444: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13445: from DUAL union all
13446: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13447: from DUAL union all
13448: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13449: from DUAL union all
13450: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13451: from DUAL union all

Line 13449: from DUAL union all

13445: from DUAL union all
13446: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13447: from DUAL union all
13448: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13449: from DUAL union all
13450: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13451: from DUAL union all
13452: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13453: from DUAL union all

Line 13451: from DUAL union all

13447: from DUAL union all
13448: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13449: from DUAL union all
13450: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13451: from DUAL union all
13452: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13453: from DUAL union all
13454: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13455: from DUAL union all

Line 13453: from DUAL union all

13449: from DUAL union all
13450: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
13451: from DUAL union all
13452: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13453: from DUAL union all
13454: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13455: from DUAL union all
13456: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13457: from DUAL

Line 13455: from DUAL union all

13451: from DUAL union all
13452: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13453: from DUAL union all
13454: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13455: from DUAL union all
13456: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13457: from DUAL
13458: ) fin_plan,
13459: (

Line 13457: from DUAL

13453: from DUAL union all
13454: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
13455: from DUAL union all
13456: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
13457: from DUAL
13458: ) fin_plan,
13459: (
13460: select 1 WBS_SUP_LEVEL,
13461: 1 WBS_SUB_LEVEL,

Line 13463: from DUAL

13459: (
13460: select 1 WBS_SUP_LEVEL,
13461: 1 WBS_SUB_LEVEL,
13462: 'PRJ' INVERT_ID
13463: from DUAL
13464: union all
13465: select 1 WBS_SUP_LEVEL,
13466: 1 WBS_SUB_LEVEL,
13467: 'WBS' INVERT_ID

Line 13468: from DUAL

13464: union all
13465: select 1 WBS_SUP_LEVEL,
13466: 1 WBS_SUB_LEVEL,
13467: 'WBS' INVERT_ID
13468: from DUAL
13469: ) top_slice
13470: where
13471: prg.STRUCT_TYPE = 'PRG' and
13472: prg.SUP_LEVEL = l_level and

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

13525: from
13526: PJI_PJP_PROJ_BATCH_MAP map,
13527: PJI_XBS_DENORM prg,
13528: (
13529: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
13530: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
13531: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
13532: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
13533: ) invert,

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

13526: PJI_PJP_PROJ_BATCH_MAP map,
13527: PJI_XBS_DENORM prg,
13528: (
13529: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
13530: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
13531: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
13532: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
13533: ) invert,
13534: PJI_XBS_DENORM_DELTA prg_delta

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

13527: PJI_XBS_DENORM prg,
13528: (
13529: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
13530: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
13531: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
13532: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
13533: ) invert,
13534: PJI_XBS_DENORM_DELTA prg_delta
13535: where

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

13528: (
13529: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
13530: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
13531: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
13532: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
13533: ) invert,
13534: PJI_XBS_DENORM_DELTA prg_delta
13535: where
13536: prg.STRUCT_TYPE = 'PRG' and

Line 14452: from DUAL union all

14448: PA_XBS_DENORM wbs,
14449: PJI_XBS_DENORM prg,
14450: (
14451: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
14452: from DUAL union all
14453: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14454: from DUAL union all
14455: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14456: from DUAL union all

Line 14454: from DUAL union all

14450: (
14451: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
14452: from DUAL union all
14453: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14454: from DUAL union all
14455: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14456: from DUAL union all
14457: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14458: from DUAL union all

Line 14456: from DUAL union all

14452: from DUAL union all
14453: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14454: from DUAL union all
14455: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14456: from DUAL union all
14457: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14458: from DUAL union all
14459: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
14460: from DUAL union all

Line 14458: from DUAL union all

14454: from DUAL union all
14455: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14456: from DUAL union all
14457: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14458: from DUAL union all
14459: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
14460: from DUAL union all
14461: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14462: from DUAL union all

Line 14460: from DUAL union all

14456: from DUAL union all
14457: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14458: from DUAL union all
14459: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
14460: from DUAL union all
14461: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14462: from DUAL union all
14463: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14464: from DUAL union all

Line 14462: from DUAL union all

14458: from DUAL union all
14459: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
14460: from DUAL union all
14461: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14462: from DUAL union all
14463: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14464: from DUAL union all
14465: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14466: from DUAL

Line 14464: from DUAL union all

14460: from DUAL union all
14461: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14462: from DUAL union all
14463: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14464: from DUAL union all
14465: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14466: from DUAL
14467: ) fin_plan,
14468: (

Line 14466: from DUAL

14462: from DUAL union all
14463: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14464: from DUAL union all
14465: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14466: from DUAL
14467: ) fin_plan,
14468: (
14469: select 1 WBS_SUP_LEVEL,
14470: 1 WBS_SUB_LEVEL,

Line 14472: from DUAL

14468: (
14469: select 1 WBS_SUP_LEVEL,
14470: 1 WBS_SUB_LEVEL,
14471: 'PRJ' INVERT_ID
14472: from DUAL
14473: union all
14474: select 1 WBS_SUP_LEVEL,
14475: 1 WBS_SUB_LEVEL,
14476: 'WBS' INVERT_ID

Line 14477: from DUAL

14473: union all
14474: select 1 WBS_SUP_LEVEL,
14475: 1 WBS_SUB_LEVEL,
14476: 'WBS' INVERT_ID
14477: from DUAL
14478: ) top_slice
14479: where
14480: prg.STRUCT_TYPE = 'PRG' and
14481: prg.SUP_LEVEL = l_level and

Line 14606: from DUAL union all

14602: (
14603: select 'Y' CB_FLAG,
14604: 'N' CO_FLAG,
14605: -3 PLAN_VERSION_ID
14606: from DUAL union all
14607: select 'N' CB_FLAG,
14608: 'Y' CO_FLAG,
14609: -4 PLAN_VERSION_ID
14610: from DUAL union all

Line 14610: from DUAL union all

14606: from DUAL union all
14607: select 'N' CB_FLAG,
14608: 'Y' CO_FLAG,
14609: -4 PLAN_VERSION_ID
14610: from DUAL union all
14611: select 'Y' CB_FLAG,
14612: 'Y' CO_FLAG,
14613: -3 PLAN_VERSION_ID
14614: from DUAL union all

Line 14614: from DUAL union all

14610: from DUAL union all
14611: select 'Y' CB_FLAG,
14612: 'Y' CO_FLAG,
14613: -3 PLAN_VERSION_ID
14614: from DUAL union all
14615: select 'Y' CB_FLAG,
14616: 'Y' CO_FLAG,
14617: -4 PLAN_VERSION_ID
14618: from DUAL

Line 14618: from DUAL

14614: from DUAL union all
14615: select 'Y' CB_FLAG,
14616: 'Y' CO_FLAG,
14617: -4 PLAN_VERSION_ID
14618: from DUAL
14619: ) fin_plan
14620: where
14621: prg.STRUCT_TYPE = 'PRG' and
14622: prg.SUP_LEVEL = l_level and

Line 14757: from DUAL union all

14753: PJI_XBS_DENORM prg,
14754: PJI_FP_XBS_ACCUM_F fpr,
14755: (
14756: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
14757: from DUAL union all
14758: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14759: from DUAL union all
14760: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14761: from DUAL union all

Line 14759: from DUAL union all

14755: (
14756: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
14757: from DUAL union all
14758: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14759: from DUAL union all
14760: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14761: from DUAL union all
14762: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14763: from DUAL union all

Line 14761: from DUAL union all

14757: from DUAL union all
14758: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14759: from DUAL union all
14760: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14761: from DUAL union all
14762: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14763: from DUAL union all
14764: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
14765: from DUAL union all

Line 14763: from DUAL union all

14759: from DUAL union all
14760: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14761: from DUAL union all
14762: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14763: from DUAL union all
14764: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
14765: from DUAL union all
14766: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14767: from DUAL union all

Line 14765: from DUAL union all

14761: from DUAL union all
14762: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14763: from DUAL union all
14764: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
14765: from DUAL union all
14766: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14767: from DUAL union all
14768: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14769: from DUAL union all

Line 14767: from DUAL union all

14763: from DUAL union all
14764: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
14765: from DUAL union all
14766: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14767: from DUAL union all
14768: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14769: from DUAL union all
14770: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14771: from DUAL

Line 14769: from DUAL union all

14765: from DUAL union all
14766: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14767: from DUAL union all
14768: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14769: from DUAL union all
14770: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14771: from DUAL
14772: ) fin_plan,
14773: (

Line 14771: from DUAL

14767: from DUAL union all
14768: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
14769: from DUAL union all
14770: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
14771: from DUAL
14772: ) fin_plan,
14773: (
14774: select 1 WBS_SUP_LEVEL,
14775: 1 WBS_SUB_LEVEL,

Line 14777: from DUAL

14773: (
14774: select 1 WBS_SUP_LEVEL,
14775: 1 WBS_SUB_LEVEL,
14776: 'PRJ' INVERT_ID
14777: from DUAL
14778: union all
14779: select 1 WBS_SUP_LEVEL,
14780: 1 WBS_SUB_LEVEL,
14781: 'WBS' INVERT_ID

Line 14782: from DUAL

14778: union all
14779: select 1 WBS_SUP_LEVEL,
14780: 1 WBS_SUB_LEVEL,
14781: 'WBS' INVERT_ID
14782: from DUAL
14783: ) top_slice
14784: where
14785: prg.STRUCT_TYPE = 'PRG' and
14786: prg.SUP_LEVEL = l_level and

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

14839: from
14840: PJI_PJP_PROJ_BATCH_MAP map,
14841: PJI_XBS_DENORM prg,
14842: (
14843: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14844: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
14845: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14846: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
14847: ) invert,

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

14840: PJI_PJP_PROJ_BATCH_MAP map,
14841: PJI_XBS_DENORM prg,
14842: (
14843: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14844: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
14845: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14846: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
14847: ) invert,
14848: PJI_XBS_DENORM_DELTA prg_delta

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

14841: PJI_XBS_DENORM prg,
14842: (
14843: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14844: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
14845: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14846: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
14847: ) invert,
14848: PJI_XBS_DENORM_DELTA prg_delta
14849: where

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

14842: (
14843: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14844: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
14845: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
14846: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
14847: ) invert,
14848: PJI_XBS_DENORM_DELTA prg_delta
14849: where
14850: prg.STRUCT_TYPE = 'PRG' and

Line 15766: from DUAL union all

15762: PA_XBS_DENORM wbs,
15763: PJI_XBS_DENORM prg,
15764: (
15765: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15766: from DUAL union all
15767: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15768: from DUAL union all
15769: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15770: from DUAL union all

Line 15768: from DUAL union all

15764: (
15765: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15766: from DUAL union all
15767: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15768: from DUAL union all
15769: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15770: from DUAL union all
15771: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15772: from DUAL union all

Line 15770: from DUAL union all

15766: from DUAL union all
15767: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15768: from DUAL union all
15769: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15770: from DUAL union all
15771: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15772: from DUAL union all
15773: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15774: from DUAL union all

Line 15772: from DUAL union all

15768: from DUAL union all
15769: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15770: from DUAL union all
15771: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15772: from DUAL union all
15773: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15774: from DUAL union all
15775: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15776: from DUAL union all

Line 15774: from DUAL union all

15770: from DUAL union all
15771: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15772: from DUAL union all
15773: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15774: from DUAL union all
15775: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15776: from DUAL union all
15777: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15778: from DUAL union all

Line 15776: from DUAL union all

15772: from DUAL union all
15773: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
15774: from DUAL union all
15775: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15776: from DUAL union all
15777: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15778: from DUAL union all
15779: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15780: from DUAL

Line 15778: from DUAL union all

15774: from DUAL union all
15775: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15776: from DUAL union all
15777: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15778: from DUAL union all
15779: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15780: from DUAL
15781: ) fin_plan,
15782: (

Line 15780: from DUAL

15776: from DUAL union all
15777: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
15778: from DUAL union all
15779: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
15780: from DUAL
15781: ) fin_plan,
15782: (
15783: select 1 WBS_SUP_LEVEL,
15784: 1 WBS_SUB_LEVEL,

Line 15786: from DUAL

15782: (
15783: select 1 WBS_SUP_LEVEL,
15784: 1 WBS_SUB_LEVEL,
15785: 'PRJ' INVERT_ID
15786: from DUAL
15787: union all
15788: select 1 WBS_SUP_LEVEL,
15789: 1 WBS_SUB_LEVEL,
15790: 'WBS' INVERT_ID

Line 15791: from DUAL

15787: union all
15788: select 1 WBS_SUP_LEVEL,
15789: 1 WBS_SUB_LEVEL,
15790: 'WBS' INVERT_ID
15791: from DUAL
15792: ) top_slice
15793: where
15794: prg.STRUCT_TYPE = 'PRG' and
15795: prg.SUP_LEVEL = l_level and

Line 15920: from DUAL union all

15916: (
15917: select 'Y' CB_FLAG,
15918: 'N' CO_FLAG,
15919: -3 PLAN_VERSION_ID
15920: from DUAL union all
15921: select 'N' CB_FLAG,
15922: 'Y' CO_FLAG,
15923: -4 PLAN_VERSION_ID
15924: from DUAL union all

Line 15924: from DUAL union all

15920: from DUAL union all
15921: select 'N' CB_FLAG,
15922: 'Y' CO_FLAG,
15923: -4 PLAN_VERSION_ID
15924: from DUAL union all
15925: select 'Y' CB_FLAG,
15926: 'Y' CO_FLAG,
15927: -3 PLAN_VERSION_ID
15928: from DUAL union all

Line 15928: from DUAL union all

15924: from DUAL union all
15925: select 'Y' CB_FLAG,
15926: 'Y' CO_FLAG,
15927: -3 PLAN_VERSION_ID
15928: from DUAL union all
15929: select 'Y' CB_FLAG,
15930: 'Y' CO_FLAG,
15931: -4 PLAN_VERSION_ID
15932: from DUAL

Line 15932: from DUAL

15928: from DUAL union all
15929: select 'Y' CB_FLAG,
15930: 'Y' CO_FLAG,
15931: -4 PLAN_VERSION_ID
15932: from DUAL
15933: ) fin_plan
15934: where
15935: prg.STRUCT_TYPE = 'PRG' and
15936: prg.SUP_LEVEL = l_level and

Line 16071: from DUAL union all

16067: PJI_XBS_DENORM prg,
16068: PJI_FP_XBS_ACCUM_F fpr,
16069: (
16070: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16071: from DUAL union all
16072: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16073: from DUAL union all
16074: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16075: from DUAL union all

Line 16073: from DUAL union all

16069: (
16070: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16071: from DUAL union all
16072: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16073: from DUAL union all
16074: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16075: from DUAL union all
16076: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16077: from DUAL union all

Line 16075: from DUAL union all

16071: from DUAL union all
16072: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16073: from DUAL union all
16074: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16075: from DUAL union all
16076: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16077: from DUAL union all
16078: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16079: from DUAL union all

Line 16077: from DUAL union all

16073: from DUAL union all
16074: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16075: from DUAL union all
16076: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16077: from DUAL union all
16078: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16079: from DUAL union all
16080: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16081: from DUAL union all

Line 16079: from DUAL union all

16075: from DUAL union all
16076: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16077: from DUAL union all
16078: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16079: from DUAL union all
16080: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16081: from DUAL union all
16082: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16083: from DUAL union all

Line 16081: from DUAL union all

16077: from DUAL union all
16078: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
16079: from DUAL union all
16080: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16081: from DUAL union all
16082: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16083: from DUAL union all
16084: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16085: from DUAL

Line 16083: from DUAL union all

16079: from DUAL union all
16080: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16081: from DUAL union all
16082: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16083: from DUAL union all
16084: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16085: from DUAL
16086: ) fin_plan,
16087: (

Line 16085: from DUAL

16081: from DUAL union all
16082: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
16083: from DUAL union all
16084: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
16085: from DUAL
16086: ) fin_plan,
16087: (
16088: select 1 WBS_SUP_LEVEL,
16089: 1 WBS_SUB_LEVEL,

Line 16091: from DUAL

16087: (
16088: select 1 WBS_SUP_LEVEL,
16089: 1 WBS_SUB_LEVEL,
16090: 'PRJ' INVERT_ID
16091: from DUAL
16092: union all
16093: select 1 WBS_SUP_LEVEL,
16094: 1 WBS_SUB_LEVEL,
16095: 'WBS' INVERT_ID

Line 16096: from DUAL

16092: union all
16093: select 1 WBS_SUP_LEVEL,
16094: 1 WBS_SUB_LEVEL,
16095: 'WBS' INVERT_ID
16096: from DUAL
16097: ) top_slice
16098: where
16099: prg.STRUCT_TYPE = 'PRG' and
16100: prg.SUP_LEVEL = l_level and

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

16153: from
16154: PJI_PJP_PROJ_BATCH_MAP map,
16155: PJI_XBS_DENORM prg,
16156: (
16157: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16158: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
16159: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16160: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
16161: ) invert,

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

16154: PJI_PJP_PROJ_BATCH_MAP map,
16155: PJI_XBS_DENORM prg,
16156: (
16157: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16158: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
16159: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16160: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
16161: ) invert,
16162: PJI_XBS_DENORM_DELTA prg_delta

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

16155: PJI_XBS_DENORM prg,
16156: (
16157: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16158: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
16159: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16160: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
16161: ) invert,
16162: PJI_XBS_DENORM_DELTA prg_delta
16163: where

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

16156: (
16157: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16158: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
16159: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
16160: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
16161: ) invert,
16162: PJI_XBS_DENORM_DELTA prg_delta
16163: where
16164: prg.STRUCT_TYPE = 'PRG' and