APPS.PJI_PJP_SUM_MAIN dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 2305: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,

2301: prg.SUP_LEVEL, 'A',
2302: prg.RELATIONSHIP_TYPE) = invert.INVERT_ID
2303: ) prg,
2304: PJI_PJP_WBS_HEADER wbs_hdr,
2305: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
2306: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
2307: PA_PROJ_WORKPLAN_ATTR sup_wpa
2308: where
2309: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and

Line 2306: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,

2302: prg.RELATIONSHIP_TYPE) = invert.INVERT_ID
2303: ) prg,
2304: PJI_PJP_WBS_HEADER wbs_hdr,
2305: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
2306: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
2307: PA_PROJ_WORKPLAN_ATTR sup_wpa
2308: where
2309: pjp.PROJECT_ID = sub_ver.PROJECT_ID (+) and
2310: pjp.WBS_VERSION_ID = sub_ver.ELEMENT_VERSION_ID (+) and

Line 2396: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,

2392: -4, pjp.PLAN_TYPE_ID,
2393: wbs_hdr.PLAN_TYPE_ID)),
2394: pjp.PLAN_TYPE_CODE
2395: ) pjp1_i,
2396: PA_PROJ_ELEM_VER_STRUCTURE sup_fin_ver,
2397: PA_PROJ_WORKPLAN_ATTR sup_wpa
2398: where
2399: pjp1_i.INSERT_FLAG = 'Y' and
2400: pjp1_i.PROJECT_ID = sup_fin_ver.PROJECT_ID (+) and