APPS.PJI_PJP_SUM_MAIN dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 2328: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

2324: prg.SUP_LEVEL, 'A',
2325: prg.RELATIONSHIP_TYPE) = invert.INVERT_ID
2326: ) prg,
2327: PJI_PJP_WBS_HEADER wbs_hdr,
2328: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
2329: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
2330: PA_PROJ_WORKPLAN_ATTR sup_wpa
2331: where
2332: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 2329: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

2325: prg.RELATIONSHIP_TYPE) = invert.INVERT_ID
2326: ) prg,
2327: PJI_PJP_WBS_HEADER wbs_hdr,
2328: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
2329: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
2330: PA_PROJ_WORKPLAN_ATTR sup_wpa
2331: where
2332: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
2333: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 2419: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

2415: -4, pjp.PLAN_TYPE_ID,
2416: wbs_hdr.PLAN_TYPE_ID)),
2417: pjp.PLAN_TYPE_CODE
2418: ) pjp1_i,
2419: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
2420: PA_PROJ_WORKPLAN_ATTR sup_wpa
2421: where
2422: pjp1_i.INSERT_FLAG = 'Y' and
2423: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and