APPS.PJI_PJP_SUM_ROLLUP dependencies on PA_PROJ_WORKPLAN_ATTR

Line 1468: PA_PROJ_WORKPLAN_ATTR sup_wpa

1464: PJI_PJP_WBS_HEADER_T wbs_hdr,
1465: -- End of Commenting and adding code for testing 0802
1466: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
1467: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
1468: PA_PROJ_WORKPLAN_ATTR sup_wpa
1469: where
1470: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
1471: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and
1472: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 1558: PA_PROJ_WORKPLAN_ATTR sup_wpa

1554: wbs_hdr.PLAN_TYPE_ID)),
1555: pjp.PLAN_TYPE_CODE
1556: ) pjp1_i,
1557: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
1558: PA_PROJ_WORKPLAN_ATTR sup_wpa
1559: where
1560: pjp1_i.INSERT_FLAG = 'Y' and
1561: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and
1562: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 2842: PA_PROJ_WORKPLAN_ATTR sup_wpa

2838: ) prg,
2839: PJI_PJP_WBS_HEADER wbs_hdr,
2840: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
2841: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
2842: PA_PROJ_WORKPLAN_ATTR sup_wpa
2843: where
2844: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
2845: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and
2846: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 2932: PA_PROJ_WORKPLAN_ATTR sup_wpa

2928: wbs_hdr.PLAN_TYPE_ID)),
2929: pjp.PLAN_TYPE_CODE
2930: ) pjp1_i,
2931: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
2932: PA_PROJ_WORKPLAN_ATTR sup_wpa
2933: where
2934: pjp1_i.INSERT_FLAG = 'Y' and
2935: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and
2936: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 13097: PA_PROJ_WORKPLAN_ATTR sup_wpa

13093: ) prg,
13094: PJI_PJP_WBS_HEADER wbs_hdr,
13095: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
13096: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
13097: PA_PROJ_WORKPLAN_ATTR sup_wpa
13098: where
13099: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
13100: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and
13101: 'STRUCTURE_PUBLISHED' = sub_ver.STATUS_CODE (+) and

Line 13187: PA_PROJ_WORKPLAN_ATTR sup_wpa

13183: wbs_hdr.PLAN_TYPE_ID)),
13184: pjp.PLAN_TYPE_CODE
13185: ) pjp1_i,
13186: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
13187: PA_PROJ_WORKPLAN_ATTR sup_wpa
13188: where
13189: pjp1_i.INSERT_FLAG = 'Y' and
13190: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and
13191: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 14839: PA_PROJ_WORKPLAN_ATTR sup_wpa

14835: pjp.CURR_RECORD_TYPE_ID,
14836: pjp.CURRENCY_CODE
14837: ) pjp1_i,
14838: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
14839: PA_PROJ_WORKPLAN_ATTR sup_wpa
14840: where
14841: pjp1_i.INSERT_FLAG = 'Y' and
14842: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and
14843: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 15461: PA_PROJ_WORKPLAN_ATTR sup_wpa

15457: pjp.CURR_RECORD_TYPE_ID,
15458: pjp.CURRENCY_CODE
15459: ) pjp1_i,
15460: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
15461: PA_PROJ_WORKPLAN_ATTR sup_wpa
15462: where
15463: pjp1_i.INSERT_FLAG = 'Y' and
15464: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and
15465: pjp1_i.SUP_ID = sup_fin_ver.ELEMENT_VERSION_ID (+) and

Line 16633: PA_PROJ_WORKPLAN_ATTR sup_wpa,

16629: wbs_hdr.CB_FLAG = fin_plan.CB (+) and
16630: wbs_hdr.CO_FLAG = fin_plan.CO (+)
16631: ) pjp,
16632: PJI_PJP_PROJ_BATCH_MAP map,
16633: PA_PROJ_WORKPLAN_ATTR sup_wpa,
16634: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
16635: PA_XBS_DENORM wbs,
16636: (
16637: select 1 WBS_SUP_LEVEL,

Line 17187: PA_PROJ_WORKPLAN_ATTR sup_wpa,

17183: wbs_hdr.PROJECT_ID = pjp1.PROJECT_ID and
17184: wbs_hdr.PLAN_VERSION_ID = -1
17185: ) pjp,
17186: PJI_PJP_PROJ_BATCH_MAP map,
17187: PA_PROJ_WORKPLAN_ATTR sup_wpa,
17188: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
17189: PA_XBS_DENORM wbs,
17190: (
17191: select 1 WBS_SUP_LEVEL,