DBA Data[Home] [Help]

APPS.PJI_PJP_GEN_PERF_ALL dependencies on PA_PROJ_WORKPLAN_ATTR

Line 4358: PA_PROJ_WORKPLAN_ATTR sup_wpa

4354: ) prg,
4355: PJI_PJP_WBS_HEADER wbs_hdr,
4356: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
4357: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
4358: PA_PROJ_WORKPLAN_ATTR sup_wpa
4359: where
4360: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
4361: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and
4362: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 4448: PA_PROJ_WORKPLAN_ATTR sup_wpa

4444: wbs_hdr.PLAN_TYPE_ID)),
4445: pjp.PLAN_TYPE_CODE
4446: ) pjp1_i,
4447: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
4448: PA_PROJ_WORKPLAN_ATTR sup_wpa
4449: where
4450: pjp1_i.INSERT_FLAG = 'Y' and
4451: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and
4452: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 5673: PA_PROJ_WORKPLAN_ATTR sup_wpa

5669: ) prg,
5670: PJI_PJP_WBS_HEADER wbs_hdr,
5671: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
5672: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
5673: PA_PROJ_WORKPLAN_ATTR sup_wpa
5674: where
5675: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
5676: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and
5677: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 5763: PA_PROJ_WORKPLAN_ATTR sup_wpa

5759: wbs_hdr.PLAN_TYPE_ID)),
5760: pjp.PLAN_TYPE_CODE
5761: ) pjp1_i,
5762: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
5763: PA_PROJ_WORKPLAN_ATTR sup_wpa
5764: where
5765: pjp1_i.INSERT_FLAG = 'Y' and
5766: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and
5767: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 6988: PA_PROJ_WORKPLAN_ATTR sup_wpa

6984: ) prg,
6985: PJI_PJP_WBS_HEADER wbs_hdr,
6986: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
6987: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
6988: PA_PROJ_WORKPLAN_ATTR sup_wpa
6989: where
6990: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
6991: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and
6992: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 7078: PA_PROJ_WORKPLAN_ATTR sup_wpa

7074: wbs_hdr.PLAN_TYPE_ID)),
7075: pjp.PLAN_TYPE_CODE
7076: ) pjp1_i,
7077: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
7078: PA_PROJ_WORKPLAN_ATTR sup_wpa
7079: where
7080: pjp1_i.INSERT_FLAG = 'Y' and
7081: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and
7082: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 8302: PA_PROJ_WORKPLAN_ATTR sup_wpa

8298: ) prg,
8299: PJI_PJP_WBS_HEADER wbs_hdr,
8300: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
8301: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
8302: PA_PROJ_WORKPLAN_ATTR sup_wpa
8303: where
8304: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
8305: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and
8306: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 8392: PA_PROJ_WORKPLAN_ATTR sup_wpa

8388: wbs_hdr.PLAN_TYPE_ID)),
8389: pjp.PLAN_TYPE_CODE
8390: ) pjp1_i,
8391: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
8392: PA_PROJ_WORKPLAN_ATTR sup_wpa
8393: where
8394: pjp1_i.INSERT_FLAG = 'Y' and
8395: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and
8396: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 9616: PA_PROJ_WORKPLAN_ATTR sup_wpa

9612: ) prg,
9613: PJI_PJP_WBS_HEADER wbs_hdr,
9614: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
9615: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
9616: PA_PROJ_WORKPLAN_ATTR sup_wpa
9617: where
9618: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
9619: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and
9620: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 9706: PA_PROJ_WORKPLAN_ATTR sup_wpa

9702: wbs_hdr.PLAN_TYPE_ID)),
9703: pjp.PLAN_TYPE_CODE
9704: ) pjp1_i,
9705: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
9706: PA_PROJ_WORKPLAN_ATTR sup_wpa
9707: where
9708: pjp1_i.INSERT_FLAG = 'Y' and
9709: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and
9710: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 10930: PA_PROJ_WORKPLAN_ATTR sup_wpa

10926: ) prg,
10927: PJI_PJP_WBS_HEADER wbs_hdr,
10928: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
10929: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
10930: PA_PROJ_WORKPLAN_ATTR sup_wpa
10931: where
10932: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
10933: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and
10934: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 11020: PA_PROJ_WORKPLAN_ATTR sup_wpa

11016: wbs_hdr.PLAN_TYPE_ID)),
11017: pjp.PLAN_TYPE_CODE
11018: ) pjp1_i,
11019: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
11020: PA_PROJ_WORKPLAN_ATTR sup_wpa
11021: where
11022: pjp1_i.INSERT_FLAG = 'Y' and
11023: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and
11024: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 12244: PA_PROJ_WORKPLAN_ATTR sup_wpa

12240: ) prg,
12241: PJI_PJP_WBS_HEADER wbs_hdr,
12242: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
12243: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
12244: PA_PROJ_WORKPLAN_ATTR sup_wpa
12245: where
12246: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
12247: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and
12248: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 12334: PA_PROJ_WORKPLAN_ATTR sup_wpa

12330: wbs_hdr.PLAN_TYPE_ID)),
12331: pjp.PLAN_TYPE_CODE
12332: ) pjp1_i,
12333: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
12334: PA_PROJ_WORKPLAN_ATTR sup_wpa
12335: where
12336: pjp1_i.INSERT_FLAG = 'Y' and
12337: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and
12338: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 13558: PA_PROJ_WORKPLAN_ATTR sup_wpa

13554: ) prg,
13555: PJI_PJP_WBS_HEADER wbs_hdr,
13556: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
13557: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
13558: PA_PROJ_WORKPLAN_ATTR sup_wpa
13559: where
13560: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
13561: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and
13562: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 13648: PA_PROJ_WORKPLAN_ATTR sup_wpa

13644: wbs_hdr.PLAN_TYPE_ID)),
13645: pjp.PLAN_TYPE_CODE
13646: ) pjp1_i,
13647: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
13648: PA_PROJ_WORKPLAN_ATTR sup_wpa
13649: where
13650: pjp1_i.INSERT_FLAG = 'Y' and
13651: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and
13652: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 14872: PA_PROJ_WORKPLAN_ATTR sup_wpa

14868: ) prg,
14869: PJI_PJP_WBS_HEADER wbs_hdr,
14870: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
14871: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
14872: PA_PROJ_WORKPLAN_ATTR sup_wpa
14873: where
14874: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
14875: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and
14876: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 14962: PA_PROJ_WORKPLAN_ATTR sup_wpa

14958: wbs_hdr.PLAN_TYPE_ID)),
14959: pjp.PLAN_TYPE_CODE
14960: ) pjp1_i,
14961: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
14962: PA_PROJ_WORKPLAN_ATTR sup_wpa
14963: where
14964: pjp1_i.INSERT_FLAG = 'Y' and
14965: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and
14966: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 16186: PA_PROJ_WORKPLAN_ATTR sup_wpa

16182: ) prg,
16183: PJI_PJP_WBS_HEADER wbs_hdr,
16184: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
16185: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
16186: PA_PROJ_WORKPLAN_ATTR sup_wpa
16187: where
16188: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
16189: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and
16190: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 16276: PA_PROJ_WORKPLAN_ATTR sup_wpa

16272: wbs_hdr.PLAN_TYPE_ID)),
16273: pjp.PLAN_TYPE_CODE
16274: ) pjp1_i,
16275: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
16276: PA_PROJ_WORKPLAN_ATTR sup_wpa
16277: where
16278: pjp1_i.INSERT_FLAG = 'Y' and
16279: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and
16280: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and