DBA Data[Home] [Help]

APPS.PJI_PJP_SUM_MAIN dependencies on PA_PROJ_WORKPLAN_ATTR

Line 2307: PA_PROJ_WORKPLAN_ATTR sup_wpa

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

Line 2397: PA_PROJ_WORKPLAN_ATTR sup_wpa

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