DBA Data[Home] [Help]

APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on PA_PROJ_STRUCTURE_TYPES

Line 2561: , PA_PROJ_STRUCTURE_TYPES ppst

2557: , l_latest_pub_flags(l_count)
2558: , l_baselined_flags(l_count)
2559: FROM PA_PROJ_WORKPLAN_ATTR ppwa
2560: , PA_PROJ_ELEMENTS ppe
2561: , PA_PROJ_STRUCTURE_TYPES ppst
2562: , PA_STRUCTURE_TYPES pst
2563: , PA_PROJ_ELEM_VER_STRUCTURE ppevs
2564: , pji_pjp_wbs_header wh
2565: -- , pa_budget_versions bv -- can't depend on bv in plan delete flow.

Line 3615: , PA_PROJ_STRUCTURE_TYPES ppst1

3611: FROM pji_xbs_denorm den
3612: , pji_pjp_wbs_header hd2 -- SUB
3613: , PA_PROJ_WORKPLAN_ATTR ppwa1
3614: , PA_PROJ_ELEMENTS ppe1
3615: , PA_PROJ_STRUCTURE_TYPES ppst1
3616: , PA_STRUCTURE_TYPES pst1
3617: , PA_PROJ_ELEM_VER_STRUCTURE ppevs1
3618: , PA_PROJ_WORKPLAN_ATTR ppwa2
3619: , PA_PROJ_ELEMENTS ppe2

Line 3620: , PA_PROJ_STRUCTURE_TYPES ppst2

3616: , PA_STRUCTURE_TYPES pst1
3617: , PA_PROJ_ELEM_VER_STRUCTURE ppevs1
3618: , PA_PROJ_WORKPLAN_ATTR ppwa2
3619: , PA_PROJ_ELEMENTS ppe2
3620: , PA_PROJ_STRUCTURE_TYPES ppst2
3621: , PA_STRUCTURE_TYPES pst2
3622: , PA_PROJ_ELEM_VER_STRUCTURE ppevs2
3623: , PA_PJI_PROJ_EVENTS_LOG elog
3624: WHERE

Line 4395: pa_proj_structure_types ptyp,

4391: INTO
4392: l_struct_type
4393: FROM
4394: pa_structure_types typ,
4395: pa_proj_structure_types ptyp,
4396: pa_proj_element_versions ver
4397: WHERE
4398: typ.STRUCTURE_TYPE_ID = ptyp.STRUCTURE_TYPE_ID AND
4399: ptyp.PROJ_ELEMENT_ID = ver.PROJ_ELEMENT_ID AND