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.

[Home] [Help]

APPS.PJI_PROCESS_UTIL dependencies on PA_PROJ_WORKPLAN_ATTR

Line 8910: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
8914: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 9000: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
9004: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 10231: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
10235: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 10321: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
10325: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 11550: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
11554: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 11640: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
11644: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 12868: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
12872: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 12958: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
12962: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 14186: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
14190: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 14276: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
14280: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 15504: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
15508: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 15594: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
15598: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 16822: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
16826: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 16912: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
16916: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 18140: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
18144: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 18230: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
18234: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 19458: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
19462: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 19548: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
19552: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 20776: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
20780: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 20866: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
20870: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 21474: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
21478: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 22056: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
22060: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 22638: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
22642: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 23220: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
23224: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 23802: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
23806: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 24384: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
24388: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 24966: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
24970: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 25548: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
25552: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 26130: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
26134: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 26712: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
26716: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 27734: PA_PROJ_WORKPLAN_ATTR sup_wpa,

27730: wbs_hdr.CB_FLAG = fin_plan.CB (+) and
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,

Line 28779: PA_PROJ_WORKPLAN_ATTR sup_wpa,

28775: wbs_hdr.CB_FLAG = fin_plan.CB (+) and
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,

Line 29824: PA_PROJ_WORKPLAN_ATTR sup_wpa,

29820: wbs_hdr.CB_FLAG = fin_plan.CB (+) and
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,

Line 30869: PA_PROJ_WORKPLAN_ATTR sup_wpa,

30865: wbs_hdr.CB_FLAG = fin_plan.CB (+) and
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,

Line 31914: PA_PROJ_WORKPLAN_ATTR sup_wpa,

31910: wbs_hdr.CB_FLAG = fin_plan.CB (+) and
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,

Line 32959: PA_PROJ_WORKPLAN_ATTR sup_wpa,

32955: wbs_hdr.CB_FLAG = fin_plan.CB (+) and
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,

Line 34004: PA_PROJ_WORKPLAN_ATTR sup_wpa,

34000: wbs_hdr.CB_FLAG = fin_plan.CB (+) and
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,

Line 35049: PA_PROJ_WORKPLAN_ATTR sup_wpa,

35045: wbs_hdr.CB_FLAG = fin_plan.CB (+) and
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,

Line 36094: PA_PROJ_WORKPLAN_ATTR sup_wpa,

36090: wbs_hdr.CB_FLAG = fin_plan.CB (+) and
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,

Line 37139: PA_PROJ_WORKPLAN_ATTR sup_wpa,

37135: wbs_hdr.CB_FLAG = fin_plan.CB (+) and
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,

Line 37517: PA_PROJ_WORKPLAN_ATTR sup_wpa,

37513: wbs_hdr.PROJECT_ID = pjp1.PROJECT_ID and
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,

Line 37860: PA_PROJ_WORKPLAN_ATTR sup_wpa,

37856: wbs_hdr.PROJECT_ID = pjp1.PROJECT_ID and
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,

Line 38202: PA_PROJ_WORKPLAN_ATTR sup_wpa,

38198: wbs_hdr.PROJECT_ID = pjp1.PROJECT_ID and
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,

Line 38544: PA_PROJ_WORKPLAN_ATTR sup_wpa,

38540: wbs_hdr.PROJECT_ID = pjp1.PROJECT_ID and
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,

Line 38886: PA_PROJ_WORKPLAN_ATTR sup_wpa,

38882: wbs_hdr.PROJECT_ID = pjp1.PROJECT_ID and
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,

Line 39228: PA_PROJ_WORKPLAN_ATTR sup_wpa,

39224: wbs_hdr.PROJECT_ID = pjp1.PROJECT_ID and
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,

Line 39570: PA_PROJ_WORKPLAN_ATTR sup_wpa,

39566: wbs_hdr.PROJECT_ID = pjp1.PROJECT_ID and
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,

Line 39912: PA_PROJ_WORKPLAN_ATTR sup_wpa,

39908: wbs_hdr.PROJECT_ID = pjp1.PROJECT_ID and
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,

Line 40254: PA_PROJ_WORKPLAN_ATTR sup_wpa,

40250: wbs_hdr.PROJECT_ID = pjp1.PROJECT_ID and
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,

Line 40596: PA_PROJ_WORKPLAN_ATTR sup_wpa,

40592: wbs_hdr.PROJECT_ID = pjp1.PROJECT_ID and
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,

Line 46479: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
46483: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 46569: PA_PROJ_WORKPLAN_ATTR sup_wpa

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
46573: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and