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

APPS.PJI_PROCESS_UTIL dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 8908: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

8904: -1 = prg_delta.SIGN (+) and
8905: prg_delta.SUP_PROJECT_ID is null
8906: ) prg,
8907: PJI_PJP_WBS_HEADER wbs_hdr,
8908: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
8909: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
8910: PA_PROJ_WORKPLAN_ATTR sup_wpa
8911: where
8912: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 8909: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

8905: prg_delta.SUP_PROJECT_ID is null
8906: ) prg,
8907: PJI_PJP_WBS_HEADER wbs_hdr,
8908: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
8909: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
8910: PA_PROJ_WORKPLAN_ATTR sup_wpa
8911: where
8912: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
8913: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 8999: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

8995: -4, pjp.PLAN_TYPE_ID,
8996: wbs_hdr.PLAN_TYPE_ID)),
8997: pjp.PLAN_TYPE_CODE
8998: ) pjp1_i,
8999: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
9000: PA_PROJ_WORKPLAN_ATTR sup_wpa
9001: where
9002: pjp1_i.INSERT_FLAG = 'Y' and
9003: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 10229: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

10225: -1 = prg_delta.SIGN (+) and
10226: prg_delta.SUP_PROJECT_ID is null
10227: ) prg,
10228: PJI_PJP_WBS_HEADER wbs_hdr,
10229: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
10230: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
10231: PA_PROJ_WORKPLAN_ATTR sup_wpa
10232: where
10233: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 10230: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

10226: prg_delta.SUP_PROJECT_ID is null
10227: ) prg,
10228: PJI_PJP_WBS_HEADER wbs_hdr,
10229: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
10230: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
10231: PA_PROJ_WORKPLAN_ATTR sup_wpa
10232: where
10233: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
10234: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 10320: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

10316: -4, pjp.PLAN_TYPE_ID,
10317: wbs_hdr.PLAN_TYPE_ID)),
10318: pjp.PLAN_TYPE_CODE
10319: ) pjp1_i,
10320: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
10321: PA_PROJ_WORKPLAN_ATTR sup_wpa
10322: where
10323: pjp1_i.INSERT_FLAG = 'Y' and
10324: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 11548: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

11544: -1 = prg_delta.SIGN (+) and
11545: prg_delta.SUP_PROJECT_ID is null
11546: ) prg,
11547: PJI_PJP_WBS_HEADER wbs_hdr,
11548: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
11549: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
11550: PA_PROJ_WORKPLAN_ATTR sup_wpa
11551: where
11552: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 11549: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

11545: prg_delta.SUP_PROJECT_ID is null
11546: ) prg,
11547: PJI_PJP_WBS_HEADER wbs_hdr,
11548: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
11549: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
11550: PA_PROJ_WORKPLAN_ATTR sup_wpa
11551: where
11552: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
11553: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 11639: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

11635: -4, pjp.PLAN_TYPE_ID,
11636: wbs_hdr.PLAN_TYPE_ID)),
11637: pjp.PLAN_TYPE_CODE
11638: ) pjp1_i,
11639: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
11640: PA_PROJ_WORKPLAN_ATTR sup_wpa
11641: where
11642: pjp1_i.INSERT_FLAG = 'Y' and
11643: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 12866: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

12862: -1 = prg_delta.SIGN (+) and
12863: prg_delta.SUP_PROJECT_ID is null
12864: ) prg,
12865: PJI_PJP_WBS_HEADER wbs_hdr,
12866: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
12867: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
12868: PA_PROJ_WORKPLAN_ATTR sup_wpa
12869: where
12870: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 12867: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

12863: prg_delta.SUP_PROJECT_ID is null
12864: ) prg,
12865: PJI_PJP_WBS_HEADER wbs_hdr,
12866: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
12867: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
12868: PA_PROJ_WORKPLAN_ATTR sup_wpa
12869: where
12870: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
12871: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 12957: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

12953: -4, pjp.PLAN_TYPE_ID,
12954: wbs_hdr.PLAN_TYPE_ID)),
12955: pjp.PLAN_TYPE_CODE
12956: ) pjp1_i,
12957: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
12958: PA_PROJ_WORKPLAN_ATTR sup_wpa
12959: where
12960: pjp1_i.INSERT_FLAG = 'Y' and
12961: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 14184: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

14180: -1 = prg_delta.SIGN (+) and
14181: prg_delta.SUP_PROJECT_ID is null
14182: ) prg,
14183: PJI_PJP_WBS_HEADER wbs_hdr,
14184: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
14185: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
14186: PA_PROJ_WORKPLAN_ATTR sup_wpa
14187: where
14188: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 14185: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

14181: prg_delta.SUP_PROJECT_ID is null
14182: ) prg,
14183: PJI_PJP_WBS_HEADER wbs_hdr,
14184: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
14185: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
14186: PA_PROJ_WORKPLAN_ATTR sup_wpa
14187: where
14188: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
14189: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 14275: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

14271: -4, pjp.PLAN_TYPE_ID,
14272: wbs_hdr.PLAN_TYPE_ID)),
14273: pjp.PLAN_TYPE_CODE
14274: ) pjp1_i,
14275: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
14276: PA_PROJ_WORKPLAN_ATTR sup_wpa
14277: where
14278: pjp1_i.INSERT_FLAG = 'Y' and
14279: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 15502: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

15498: -1 = prg_delta.SIGN (+) and
15499: prg_delta.SUP_PROJECT_ID is null
15500: ) prg,
15501: PJI_PJP_WBS_HEADER wbs_hdr,
15502: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
15503: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
15504: PA_PROJ_WORKPLAN_ATTR sup_wpa
15505: where
15506: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 15503: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

15499: prg_delta.SUP_PROJECT_ID is null
15500: ) prg,
15501: PJI_PJP_WBS_HEADER wbs_hdr,
15502: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
15503: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
15504: PA_PROJ_WORKPLAN_ATTR sup_wpa
15505: where
15506: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
15507: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 15593: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

15589: -4, pjp.PLAN_TYPE_ID,
15590: wbs_hdr.PLAN_TYPE_ID)),
15591: pjp.PLAN_TYPE_CODE
15592: ) pjp1_i,
15593: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
15594: PA_PROJ_WORKPLAN_ATTR sup_wpa
15595: where
15596: pjp1_i.INSERT_FLAG = 'Y' and
15597: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 16820: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

16816: -1 = prg_delta.SIGN (+) and
16817: prg_delta.SUP_PROJECT_ID is null
16818: ) prg,
16819: PJI_PJP_WBS_HEADER wbs_hdr,
16820: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
16821: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
16822: PA_PROJ_WORKPLAN_ATTR sup_wpa
16823: where
16824: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 16821: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

16817: prg_delta.SUP_PROJECT_ID is null
16818: ) prg,
16819: PJI_PJP_WBS_HEADER wbs_hdr,
16820: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
16821: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
16822: PA_PROJ_WORKPLAN_ATTR sup_wpa
16823: where
16824: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
16825: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 16911: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

16907: -4, pjp.PLAN_TYPE_ID,
16908: wbs_hdr.PLAN_TYPE_ID)),
16909: pjp.PLAN_TYPE_CODE
16910: ) pjp1_i,
16911: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
16912: PA_PROJ_WORKPLAN_ATTR sup_wpa
16913: where
16914: pjp1_i.INSERT_FLAG = 'Y' and
16915: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 18138: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

18134: -1 = prg_delta.SIGN (+) and
18135: prg_delta.SUP_PROJECT_ID is null
18136: ) prg,
18137: PJI_PJP_WBS_HEADER wbs_hdr,
18138: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
18139: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
18140: PA_PROJ_WORKPLAN_ATTR sup_wpa
18141: where
18142: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 18139: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

18135: prg_delta.SUP_PROJECT_ID is null
18136: ) prg,
18137: PJI_PJP_WBS_HEADER wbs_hdr,
18138: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
18139: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
18140: PA_PROJ_WORKPLAN_ATTR sup_wpa
18141: where
18142: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
18143: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 18229: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

18225: -4, pjp.PLAN_TYPE_ID,
18226: wbs_hdr.PLAN_TYPE_ID)),
18227: pjp.PLAN_TYPE_CODE
18228: ) pjp1_i,
18229: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
18230: PA_PROJ_WORKPLAN_ATTR sup_wpa
18231: where
18232: pjp1_i.INSERT_FLAG = 'Y' and
18233: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 19456: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

19452: -1 = prg_delta.SIGN (+) and
19453: prg_delta.SUP_PROJECT_ID is null
19454: ) prg,
19455: PJI_PJP_WBS_HEADER wbs_hdr,
19456: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
19457: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
19458: PA_PROJ_WORKPLAN_ATTR sup_wpa
19459: where
19460: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 19457: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

19453: prg_delta.SUP_PROJECT_ID is null
19454: ) prg,
19455: PJI_PJP_WBS_HEADER wbs_hdr,
19456: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
19457: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
19458: PA_PROJ_WORKPLAN_ATTR sup_wpa
19459: where
19460: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
19461: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 19547: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

19543: -4, pjp.PLAN_TYPE_ID,
19544: wbs_hdr.PLAN_TYPE_ID)),
19545: pjp.PLAN_TYPE_CODE
19546: ) pjp1_i,
19547: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
19548: PA_PROJ_WORKPLAN_ATTR sup_wpa
19549: where
19550: pjp1_i.INSERT_FLAG = 'Y' and
19551: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 20774: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

20770: -1 = prg_delta.SIGN (+) and
20771: prg_delta.SUP_PROJECT_ID is null
20772: ) prg,
20773: PJI_PJP_WBS_HEADER wbs_hdr,
20774: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
20775: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
20776: PA_PROJ_WORKPLAN_ATTR sup_wpa
20777: where
20778: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 20775: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

20771: prg_delta.SUP_PROJECT_ID is null
20772: ) prg,
20773: PJI_PJP_WBS_HEADER wbs_hdr,
20774: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
20775: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
20776: PA_PROJ_WORKPLAN_ATTR sup_wpa
20777: where
20778: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
20779: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 20865: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

20861: -4, pjp.PLAN_TYPE_ID,
20862: wbs_hdr.PLAN_TYPE_ID)),
20863: pjp.PLAN_TYPE_CODE
20864: ) pjp1_i,
20865: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
20866: PA_PROJ_WORKPLAN_ATTR sup_wpa
20867: where
20868: pjp1_i.INSERT_FLAG = 'Y' and
20869: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 21473: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

21469: pjp.PRG_ROLLUP_FLAG, 'Y'),
21470: pjp.CURR_RECORD_TYPE_ID,
21471: pjp.CURRENCY_CODE
21472: ) pjp1_i,
21473: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
21474: PA_PROJ_WORKPLAN_ATTR sup_wpa
21475: where
21476: pjp1_i.INSERT_FLAG = 'Y' and
21477: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 22055: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

22051: pjp.PRG_ROLLUP_FLAG, 'Y'),
22052: pjp.CURR_RECORD_TYPE_ID,
22053: pjp.CURRENCY_CODE
22054: ) pjp1_i,
22055: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
22056: PA_PROJ_WORKPLAN_ATTR sup_wpa
22057: where
22058: pjp1_i.INSERT_FLAG = 'Y' and
22059: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 22637: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

22633: pjp.PRG_ROLLUP_FLAG, 'Y'),
22634: pjp.CURR_RECORD_TYPE_ID,
22635: pjp.CURRENCY_CODE
22636: ) pjp1_i,
22637: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
22638: PA_PROJ_WORKPLAN_ATTR sup_wpa
22639: where
22640: pjp1_i.INSERT_FLAG = 'Y' and
22641: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 23219: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

23215: pjp.PRG_ROLLUP_FLAG, 'Y'),
23216: pjp.CURR_RECORD_TYPE_ID,
23217: pjp.CURRENCY_CODE
23218: ) pjp1_i,
23219: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
23220: PA_PROJ_WORKPLAN_ATTR sup_wpa
23221: where
23222: pjp1_i.INSERT_FLAG = 'Y' and
23223: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 23801: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

23797: pjp.PRG_ROLLUP_FLAG, 'Y'),
23798: pjp.CURR_RECORD_TYPE_ID,
23799: pjp.CURRENCY_CODE
23800: ) pjp1_i,
23801: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
23802: PA_PROJ_WORKPLAN_ATTR sup_wpa
23803: where
23804: pjp1_i.INSERT_FLAG = 'Y' and
23805: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 24383: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

24379: pjp.PRG_ROLLUP_FLAG, 'Y'),
24380: pjp.CURR_RECORD_TYPE_ID,
24381: pjp.CURRENCY_CODE
24382: ) pjp1_i,
24383: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
24384: PA_PROJ_WORKPLAN_ATTR sup_wpa
24385: where
24386: pjp1_i.INSERT_FLAG = 'Y' and
24387: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 24965: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

24961: pjp.PRG_ROLLUP_FLAG, 'Y'),
24962: pjp.CURR_RECORD_TYPE_ID,
24963: pjp.CURRENCY_CODE
24964: ) pjp1_i,
24965: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
24966: PA_PROJ_WORKPLAN_ATTR sup_wpa
24967: where
24968: pjp1_i.INSERT_FLAG = 'Y' and
24969: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 25547: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

25543: pjp.PRG_ROLLUP_FLAG, 'Y'),
25544: pjp.CURR_RECORD_TYPE_ID,
25545: pjp.CURRENCY_CODE
25546: ) pjp1_i,
25547: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
25548: PA_PROJ_WORKPLAN_ATTR sup_wpa
25549: where
25550: pjp1_i.INSERT_FLAG = 'Y' and
25551: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 26129: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

26125: pjp.PRG_ROLLUP_FLAG, 'Y'),
26126: pjp.CURR_RECORD_TYPE_ID,
26127: pjp.CURRENCY_CODE
26128: ) pjp1_i,
26129: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
26130: PA_PROJ_WORKPLAN_ATTR sup_wpa
26131: where
26132: pjp1_i.INSERT_FLAG = 'Y' and
26133: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 26711: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

26707: pjp.PRG_ROLLUP_FLAG, 'Y'),
26708: pjp.CURR_RECORD_TYPE_ID,
26709: pjp.CURRENCY_CODE
26710: ) pjp1_i,
26711: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
26712: PA_PROJ_WORKPLAN_ATTR sup_wpa
26713: where
26714: pjp1_i.INSERT_FLAG = 'Y' and
26715: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and

Line 27238: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

27234: PA_PROJ_ELEMENTS prj_emt,
27235: PJI_PJP_WBS_HEADER wbs_hdr,
27236: PJI_FP_XBS_ACCUM_F fpr,
27237: PJI_PJP_WBS_HEADER sup_wbs_hdr,
27238: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
27239: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
27240: (
27241: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
27242: from DUAL union all

Line 27239: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

27235: PJI_PJP_WBS_HEADER wbs_hdr,
27236: PJI_FP_XBS_ACCUM_F fpr,
27237: PJI_PJP_WBS_HEADER sup_wbs_hdr,
27238: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
27239: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
27240: (
27241: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
27242: from DUAL union all
27243: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 27639: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

27635: PA_PROJ_ELEMENTS prj_emt,
27636: PA_XBS_DENORM prg,
27637: PJI_XBS_DENORM_DELTA prg_delta,
27638: PJI_PJP_WBS_HEADER sup_wbs_hdr,
27639: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
27640: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
27641: (
27642: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
27643: from DUAL union all

Line 27640: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

27636: PA_XBS_DENORM prg,
27637: PJI_XBS_DENORM_DELTA prg_delta,
27638: PJI_PJP_WBS_HEADER sup_wbs_hdr,
27639: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
27640: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
27641: (
27642: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
27643: from DUAL union all
27644: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 27735: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

27731: wbs_hdr.CO_FLAG = fin_plan.CO (+)
27732: ) pjp,
27733: PJI_PJP_PROJ_BATCH_MAP map,
27734: PA_PROJ_WORKPLAN_ATTR sup_wpa,
27735: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
27736: PA_XBS_DENORM wbs,
27737: (
27738: select 1 WBS_SUP_LEVEL,
27739: 'PRJ' INVERT_ID

Line 28283: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

28279: PA_PROJ_ELEMENTS prj_emt,
28280: PJI_PJP_WBS_HEADER wbs_hdr,
28281: PJI_FP_XBS_ACCUM_F fpr,
28282: PJI_PJP_WBS_HEADER sup_wbs_hdr,
28283: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
28284: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
28285: (
28286: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
28287: from DUAL union all

Line 28284: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

28280: PJI_PJP_WBS_HEADER wbs_hdr,
28281: PJI_FP_XBS_ACCUM_F fpr,
28282: PJI_PJP_WBS_HEADER sup_wbs_hdr,
28283: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
28284: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
28285: (
28286: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
28287: from DUAL union all
28288: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 28684: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

28680: PA_PROJ_ELEMENTS prj_emt,
28681: PA_XBS_DENORM prg,
28682: PJI_XBS_DENORM_DELTA prg_delta,
28683: PJI_PJP_WBS_HEADER sup_wbs_hdr,
28684: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
28685: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
28686: (
28687: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
28688: from DUAL union all

Line 28685: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

28681: PA_XBS_DENORM prg,
28682: PJI_XBS_DENORM_DELTA prg_delta,
28683: PJI_PJP_WBS_HEADER sup_wbs_hdr,
28684: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
28685: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
28686: (
28687: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
28688: from DUAL union all
28689: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 28780: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

28776: wbs_hdr.CO_FLAG = fin_plan.CO (+)
28777: ) pjp,
28778: PJI_PJP_PROJ_BATCH_MAP map,
28779: PA_PROJ_WORKPLAN_ATTR sup_wpa,
28780: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
28781: PA_XBS_DENORM wbs,
28782: (
28783: select 1 WBS_SUP_LEVEL,
28784: 'PRJ' INVERT_ID

Line 29328: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

29324: PA_PROJ_ELEMENTS prj_emt,
29325: PJI_PJP_WBS_HEADER wbs_hdr,
29326: PJI_FP_XBS_ACCUM_F fpr,
29327: PJI_PJP_WBS_HEADER sup_wbs_hdr,
29328: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
29329: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
29330: (
29331: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
29332: from DUAL union all

Line 29329: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

29325: PJI_PJP_WBS_HEADER wbs_hdr,
29326: PJI_FP_XBS_ACCUM_F fpr,
29327: PJI_PJP_WBS_HEADER sup_wbs_hdr,
29328: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
29329: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
29330: (
29331: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
29332: from DUAL union all
29333: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 29729: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

29725: PA_PROJ_ELEMENTS prj_emt,
29726: PA_XBS_DENORM prg,
29727: PJI_XBS_DENORM_DELTA prg_delta,
29728: PJI_PJP_WBS_HEADER sup_wbs_hdr,
29729: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
29730: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
29731: (
29732: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
29733: from DUAL union all

Line 29730: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

29726: PA_XBS_DENORM prg,
29727: PJI_XBS_DENORM_DELTA prg_delta,
29728: PJI_PJP_WBS_HEADER sup_wbs_hdr,
29729: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
29730: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
29731: (
29732: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
29733: from DUAL union all
29734: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 29825: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

29821: wbs_hdr.CO_FLAG = fin_plan.CO (+)
29822: ) pjp,
29823: PJI_PJP_PROJ_BATCH_MAP map,
29824: PA_PROJ_WORKPLAN_ATTR sup_wpa,
29825: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
29826: PA_XBS_DENORM wbs,
29827: (
29828: select 1 WBS_SUP_LEVEL,
29829: 'PRJ' INVERT_ID

Line 30373: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

30369: PA_PROJ_ELEMENTS prj_emt,
30370: PJI_PJP_WBS_HEADER wbs_hdr,
30371: PJI_FP_XBS_ACCUM_F fpr,
30372: PJI_PJP_WBS_HEADER sup_wbs_hdr,
30373: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
30374: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
30375: (
30376: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
30377: from DUAL union all

Line 30374: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

30370: PJI_PJP_WBS_HEADER wbs_hdr,
30371: PJI_FP_XBS_ACCUM_F fpr,
30372: PJI_PJP_WBS_HEADER sup_wbs_hdr,
30373: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
30374: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
30375: (
30376: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
30377: from DUAL union all
30378: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 30774: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

30770: PA_PROJ_ELEMENTS prj_emt,
30771: PA_XBS_DENORM prg,
30772: PJI_XBS_DENORM_DELTA prg_delta,
30773: PJI_PJP_WBS_HEADER sup_wbs_hdr,
30774: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
30775: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
30776: (
30777: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
30778: from DUAL union all

Line 30775: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

30771: PA_XBS_DENORM prg,
30772: PJI_XBS_DENORM_DELTA prg_delta,
30773: PJI_PJP_WBS_HEADER sup_wbs_hdr,
30774: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
30775: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
30776: (
30777: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
30778: from DUAL union all
30779: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 30870: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

30866: wbs_hdr.CO_FLAG = fin_plan.CO (+)
30867: ) pjp,
30868: PJI_PJP_PROJ_BATCH_MAP map,
30869: PA_PROJ_WORKPLAN_ATTR sup_wpa,
30870: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
30871: PA_XBS_DENORM wbs,
30872: (
30873: select 1 WBS_SUP_LEVEL,
30874: 'PRJ' INVERT_ID

Line 31418: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

31414: PA_PROJ_ELEMENTS prj_emt,
31415: PJI_PJP_WBS_HEADER wbs_hdr,
31416: PJI_FP_XBS_ACCUM_F fpr,
31417: PJI_PJP_WBS_HEADER sup_wbs_hdr,
31418: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
31419: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
31420: (
31421: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
31422: from DUAL union all

Line 31419: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

31415: PJI_PJP_WBS_HEADER wbs_hdr,
31416: PJI_FP_XBS_ACCUM_F fpr,
31417: PJI_PJP_WBS_HEADER sup_wbs_hdr,
31418: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
31419: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
31420: (
31421: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
31422: from DUAL union all
31423: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 31819: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

31815: PA_PROJ_ELEMENTS prj_emt,
31816: PA_XBS_DENORM prg,
31817: PJI_XBS_DENORM_DELTA prg_delta,
31818: PJI_PJP_WBS_HEADER sup_wbs_hdr,
31819: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
31820: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
31821: (
31822: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
31823: from DUAL union all

Line 31820: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

31816: PA_XBS_DENORM prg,
31817: PJI_XBS_DENORM_DELTA prg_delta,
31818: PJI_PJP_WBS_HEADER sup_wbs_hdr,
31819: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
31820: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
31821: (
31822: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
31823: from DUAL union all
31824: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 31915: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

31911: wbs_hdr.CO_FLAG = fin_plan.CO (+)
31912: ) pjp,
31913: PJI_PJP_PROJ_BATCH_MAP map,
31914: PA_PROJ_WORKPLAN_ATTR sup_wpa,
31915: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
31916: PA_XBS_DENORM wbs,
31917: (
31918: select 1 WBS_SUP_LEVEL,
31919: 'PRJ' INVERT_ID

Line 32463: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

32459: PA_PROJ_ELEMENTS prj_emt,
32460: PJI_PJP_WBS_HEADER wbs_hdr,
32461: PJI_FP_XBS_ACCUM_F fpr,
32462: PJI_PJP_WBS_HEADER sup_wbs_hdr,
32463: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
32464: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
32465: (
32466: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
32467: from DUAL union all

Line 32464: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

32460: PJI_PJP_WBS_HEADER wbs_hdr,
32461: PJI_FP_XBS_ACCUM_F fpr,
32462: PJI_PJP_WBS_HEADER sup_wbs_hdr,
32463: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
32464: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
32465: (
32466: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
32467: from DUAL union all
32468: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 32864: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

32860: PA_PROJ_ELEMENTS prj_emt,
32861: PA_XBS_DENORM prg,
32862: PJI_XBS_DENORM_DELTA prg_delta,
32863: PJI_PJP_WBS_HEADER sup_wbs_hdr,
32864: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
32865: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
32866: (
32867: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
32868: from DUAL union all

Line 32865: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

32861: PA_XBS_DENORM prg,
32862: PJI_XBS_DENORM_DELTA prg_delta,
32863: PJI_PJP_WBS_HEADER sup_wbs_hdr,
32864: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
32865: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
32866: (
32867: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
32868: from DUAL union all
32869: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 32960: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

32956: wbs_hdr.CO_FLAG = fin_plan.CO (+)
32957: ) pjp,
32958: PJI_PJP_PROJ_BATCH_MAP map,
32959: PA_PROJ_WORKPLAN_ATTR sup_wpa,
32960: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
32961: PA_XBS_DENORM wbs,
32962: (
32963: select 1 WBS_SUP_LEVEL,
32964: 'PRJ' INVERT_ID

Line 33508: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

33504: PA_PROJ_ELEMENTS prj_emt,
33505: PJI_PJP_WBS_HEADER wbs_hdr,
33506: PJI_FP_XBS_ACCUM_F fpr,
33507: PJI_PJP_WBS_HEADER sup_wbs_hdr,
33508: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
33509: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
33510: (
33511: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
33512: from DUAL union all

Line 33509: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

33505: PJI_PJP_WBS_HEADER wbs_hdr,
33506: PJI_FP_XBS_ACCUM_F fpr,
33507: PJI_PJP_WBS_HEADER sup_wbs_hdr,
33508: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
33509: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
33510: (
33511: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
33512: from DUAL union all
33513: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 33909: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

33905: PA_PROJ_ELEMENTS prj_emt,
33906: PA_XBS_DENORM prg,
33907: PJI_XBS_DENORM_DELTA prg_delta,
33908: PJI_PJP_WBS_HEADER sup_wbs_hdr,
33909: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
33910: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
33911: (
33912: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
33913: from DUAL union all

Line 33910: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

33906: PA_XBS_DENORM prg,
33907: PJI_XBS_DENORM_DELTA prg_delta,
33908: PJI_PJP_WBS_HEADER sup_wbs_hdr,
33909: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
33910: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
33911: (
33912: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
33913: from DUAL union all
33914: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 34005: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

34001: wbs_hdr.CO_FLAG = fin_plan.CO (+)
34002: ) pjp,
34003: PJI_PJP_PROJ_BATCH_MAP map,
34004: PA_PROJ_WORKPLAN_ATTR sup_wpa,
34005: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
34006: PA_XBS_DENORM wbs,
34007: (
34008: select 1 WBS_SUP_LEVEL,
34009: 'PRJ' INVERT_ID

Line 34553: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

34549: PA_PROJ_ELEMENTS prj_emt,
34550: PJI_PJP_WBS_HEADER wbs_hdr,
34551: PJI_FP_XBS_ACCUM_F fpr,
34552: PJI_PJP_WBS_HEADER sup_wbs_hdr,
34553: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
34554: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
34555: (
34556: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
34557: from DUAL union all

Line 34554: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

34550: PJI_PJP_WBS_HEADER wbs_hdr,
34551: PJI_FP_XBS_ACCUM_F fpr,
34552: PJI_PJP_WBS_HEADER sup_wbs_hdr,
34553: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
34554: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
34555: (
34556: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
34557: from DUAL union all
34558: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 34954: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

34950: PA_PROJ_ELEMENTS prj_emt,
34951: PA_XBS_DENORM prg,
34952: PJI_XBS_DENORM_DELTA prg_delta,
34953: PJI_PJP_WBS_HEADER sup_wbs_hdr,
34954: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
34955: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
34956: (
34957: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
34958: from DUAL union all

Line 34955: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

34951: PA_XBS_DENORM prg,
34952: PJI_XBS_DENORM_DELTA prg_delta,
34953: PJI_PJP_WBS_HEADER sup_wbs_hdr,
34954: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
34955: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
34956: (
34957: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
34958: from DUAL union all
34959: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 35050: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

35046: wbs_hdr.CO_FLAG = fin_plan.CO (+)
35047: ) pjp,
35048: PJI_PJP_PROJ_BATCH_MAP map,
35049: PA_PROJ_WORKPLAN_ATTR sup_wpa,
35050: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
35051: PA_XBS_DENORM wbs,
35052: (
35053: select 1 WBS_SUP_LEVEL,
35054: 'PRJ' INVERT_ID

Line 35598: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

35594: PA_PROJ_ELEMENTS prj_emt,
35595: PJI_PJP_WBS_HEADER wbs_hdr,
35596: PJI_FP_XBS_ACCUM_F fpr,
35597: PJI_PJP_WBS_HEADER sup_wbs_hdr,
35598: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
35599: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
35600: (
35601: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
35602: from DUAL union all

Line 35599: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

35595: PJI_PJP_WBS_HEADER wbs_hdr,
35596: PJI_FP_XBS_ACCUM_F fpr,
35597: PJI_PJP_WBS_HEADER sup_wbs_hdr,
35598: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
35599: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
35600: (
35601: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
35602: from DUAL union all
35603: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 35999: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

35995: PA_PROJ_ELEMENTS prj_emt,
35996: PA_XBS_DENORM prg,
35997: PJI_XBS_DENORM_DELTA prg_delta,
35998: PJI_PJP_WBS_HEADER sup_wbs_hdr,
35999: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
36000: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
36001: (
36002: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
36003: from DUAL union all

Line 36000: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

35996: PA_XBS_DENORM prg,
35997: PJI_XBS_DENORM_DELTA prg_delta,
35998: PJI_PJP_WBS_HEADER sup_wbs_hdr,
35999: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
36000: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
36001: (
36002: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
36003: from DUAL union all
36004: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 36095: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

36091: wbs_hdr.CO_FLAG = fin_plan.CO (+)
36092: ) pjp,
36093: PJI_PJP_PROJ_BATCH_MAP map,
36094: PA_PROJ_WORKPLAN_ATTR sup_wpa,
36095: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
36096: PA_XBS_DENORM wbs,
36097: (
36098: select 1 WBS_SUP_LEVEL,
36099: 'PRJ' INVERT_ID

Line 36643: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

36639: PA_PROJ_ELEMENTS prj_emt,
36640: PJI_PJP_WBS_HEADER wbs_hdr,
36641: PJI_FP_XBS_ACCUM_F fpr,
36642: PJI_PJP_WBS_HEADER sup_wbs_hdr,
36643: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
36644: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
36645: (
36646: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
36647: from DUAL union all

Line 36644: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

36640: PJI_PJP_WBS_HEADER wbs_hdr,
36641: PJI_FP_XBS_ACCUM_F fpr,
36642: PJI_PJP_WBS_HEADER sup_wbs_hdr,
36643: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
36644: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
36645: (
36646: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
36647: from DUAL union all
36648: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 37044: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

37040: PA_PROJ_ELEMENTS prj_emt,
37041: PA_XBS_DENORM prg,
37042: PJI_XBS_DENORM_DELTA prg_delta,
37043: PJI_PJP_WBS_HEADER sup_wbs_hdr,
37044: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
37045: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
37046: (
37047: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
37048: from DUAL union all

Line 37045: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

37041: PA_XBS_DENORM prg,
37042: PJI_XBS_DENORM_DELTA prg_delta,
37043: PJI_PJP_WBS_HEADER sup_wbs_hdr,
37044: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
37045: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
37046: (
37047: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
37048: from DUAL union all
37049: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID

Line 37140: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

37136: wbs_hdr.CO_FLAG = fin_plan.CO (+)
37137: ) pjp,
37138: PJI_PJP_PROJ_BATCH_MAP map,
37139: PA_PROJ_WORKPLAN_ATTR sup_wpa,
37140: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
37141: PA_XBS_DENORM wbs,
37142: (
37143: select 1 WBS_SUP_LEVEL,
37144: 'PRJ' INVERT_ID

Line 37518: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

37514: wbs_hdr.PLAN_VERSION_ID = -1
37515: ) pjp,
37516: PJI_PJP_PROJ_BATCH_MAP map,
37517: PA_PROJ_WORKPLAN_ATTR sup_wpa,
37518: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
37519: PA_XBS_DENORM wbs,
37520: (
37521: select 1 WBS_SUP_LEVEL,
37522: 'PRJ' INVERT_ID

Line 37861: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

37857: wbs_hdr.PLAN_VERSION_ID = -1
37858: ) pjp,
37859: PJI_PJP_PROJ_BATCH_MAP map,
37860: PA_PROJ_WORKPLAN_ATTR sup_wpa,
37861: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
37862: PA_XBS_DENORM wbs,
37863: (
37864: select 1 WBS_SUP_LEVEL,
37865: 'PRJ' INVERT_ID

Line 38203: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

38199: wbs_hdr.PLAN_VERSION_ID = -1
38200: ) pjp,
38201: PJI_PJP_PROJ_BATCH_MAP map,
38202: PA_PROJ_WORKPLAN_ATTR sup_wpa,
38203: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
38204: PA_XBS_DENORM wbs,
38205: (
38206: select 1 WBS_SUP_LEVEL,
38207: 'PRJ' INVERT_ID

Line 38545: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

38541: wbs_hdr.PLAN_VERSION_ID = -1
38542: ) pjp,
38543: PJI_PJP_PROJ_BATCH_MAP map,
38544: PA_PROJ_WORKPLAN_ATTR sup_wpa,
38545: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
38546: PA_XBS_DENORM wbs,
38547: (
38548: select 1 WBS_SUP_LEVEL,
38549: 'PRJ' INVERT_ID

Line 38887: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

38883: wbs_hdr.PLAN_VERSION_ID = -1
38884: ) pjp,
38885: PJI_PJP_PROJ_BATCH_MAP map,
38886: PA_PROJ_WORKPLAN_ATTR sup_wpa,
38887: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
38888: PA_XBS_DENORM wbs,
38889: (
38890: select 1 WBS_SUP_LEVEL,
38891: 'PRJ' INVERT_ID

Line 39229: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

39225: wbs_hdr.PLAN_VERSION_ID = -1
39226: ) pjp,
39227: PJI_PJP_PROJ_BATCH_MAP map,
39228: PA_PROJ_WORKPLAN_ATTR sup_wpa,
39229: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
39230: PA_XBS_DENORM wbs,
39231: (
39232: select 1 WBS_SUP_LEVEL,
39233: 'PRJ' INVERT_ID

Line 39571: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

39567: wbs_hdr.PLAN_VERSION_ID = -1
39568: ) pjp,
39569: PJI_PJP_PROJ_BATCH_MAP map,
39570: PA_PROJ_WORKPLAN_ATTR sup_wpa,
39571: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
39572: PA_XBS_DENORM wbs,
39573: (
39574: select 1 WBS_SUP_LEVEL,
39575: 'PRJ' INVERT_ID

Line 39913: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

39909: wbs_hdr.PLAN_VERSION_ID = -1
39910: ) pjp,
39911: PJI_PJP_PROJ_BATCH_MAP map,
39912: PA_PROJ_WORKPLAN_ATTR sup_wpa,
39913: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
39914: PA_XBS_DENORM wbs,
39915: (
39916: select 1 WBS_SUP_LEVEL,
39917: 'PRJ' INVERT_ID

Line 40255: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

40251: wbs_hdr.PLAN_VERSION_ID = -1
40252: ) pjp,
40253: PJI_PJP_PROJ_BATCH_MAP map,
40254: PA_PROJ_WORKPLAN_ATTR sup_wpa,
40255: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
40256: PA_XBS_DENORM wbs,
40257: (
40258: select 1 WBS_SUP_LEVEL,
40259: 'PRJ' INVERT_ID

Line 40597: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

40593: wbs_hdr.PLAN_VERSION_ID = -1
40594: ) pjp,
40595: PJI_PJP_PROJ_BATCH_MAP map,
40596: PA_PROJ_WORKPLAN_ATTR sup_wpa,
40597: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
40598: PA_XBS_DENORM wbs,
40599: (
40600: select 1 WBS_SUP_LEVEL,
40601: 'PRJ' INVERT_ID

Line 46477: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

46473: -1 = prg_delta.SIGN (+) and
46474: prg_delta.SUP_PROJECT_ID is null
46475: ) prg,
46476: PJI_PJP_WBS_HEADER_T wbs_hdr,
46477: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
46478: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
46479: PA_PROJ_WORKPLAN_ATTR sup_wpa
46480: where
46481: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 46478: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

46474: prg_delta.SUP_PROJECT_ID is null
46475: ) prg,
46476: PJI_PJP_WBS_HEADER_T wbs_hdr,
46477: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
46478: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
46479: PA_PROJ_WORKPLAN_ATTR sup_wpa
46480: where
46481: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
46482: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 46568: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

46564: -4, pjp.PLAN_TYPE_ID,
46565: wbs_hdr.PLAN_TYPE_ID)),
46566: pjp.PLAN_TYPE_CODE
46567: ) pjp1_i,
46568: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
46569: PA_PROJ_WORKPLAN_ATTR sup_wpa
46570: where
46571: pjp1_i.INSERT_FLAG = 'Y' and
46572: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and