DBA Data[Home] [Help]

APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on PA_PROJ_STRUCTURE_TYPES

Line 2937: , PA_PROJ_STRUCTURE_TYPES ppst

2933: , l_latest_pub_flags(l_count)
2934: , l_baselined_flags(l_count)
2935: FROM PA_PROJ_WORKPLAN_ATTR ppwa
2936: , PA_PROJ_ELEMENTS ppe
2937: , PA_PROJ_STRUCTURE_TYPES ppst
2938: , PA_STRUCTURE_TYPES pst
2939: , PA_PROJ_ELEM_VER_STRUCTURE ppevs
2940: , pji_pjp_wbs_header wh
2941: -- , pa_budget_versions bv -- can't depend on bv in plan delete flow.

Line 3991: , PA_PROJ_STRUCTURE_TYPES ppst1

3987: FROM pji_xbs_denorm den
3988: , pji_pjp_wbs_header hd2 -- SUB
3989: , PA_PROJ_WORKPLAN_ATTR ppwa1
3990: , PA_PROJ_ELEMENTS ppe1
3991: , PA_PROJ_STRUCTURE_TYPES ppst1
3992: , PA_STRUCTURE_TYPES pst1
3993: , PA_PROJ_ELEM_VER_STRUCTURE ppevs1
3994: , PA_PROJ_WORKPLAN_ATTR ppwa2
3995: , PA_PROJ_ELEMENTS ppe2

Line 3996: , PA_PROJ_STRUCTURE_TYPES ppst2

3992: , PA_STRUCTURE_TYPES pst1
3993: , PA_PROJ_ELEM_VER_STRUCTURE ppevs1
3994: , PA_PROJ_WORKPLAN_ATTR ppwa2
3995: , PA_PROJ_ELEMENTS ppe2
3996: , PA_PROJ_STRUCTURE_TYPES ppst2
3997: , PA_STRUCTURE_TYPES pst2
3998: , PA_PROJ_ELEM_VER_STRUCTURE ppevs2
3999: , PA_PJI_PROJ_EVENTS_LOG elog
4000: WHERE

Line 4773: pa_proj_structure_types ptyp,

4769: INTO
4770: l_struct_type
4771: FROM
4772: pa_structure_types typ,
4773: pa_proj_structure_types ptyp,
4774: pa_proj_element_versions ver
4775: WHERE
4776: typ.STRUCTURE_TYPE_ID = ptyp.STRUCTURE_TYPE_ID AND
4777: ptyp.PROJ_ELEMENT_ID = ver.PROJ_ELEMENT_ID AND