[Home] [Help]
2931: , l_vers_enabled_flags(l_count)
2932: , l_published_flags(l_count)
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
3985: WHERE EXISTS (
3986: SELECT 1
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
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
3996: , PA_PROJ_STRUCTURE_TYPES ppst2
3997: , PA_STRUCTURE_TYPES pst2
3998: , PA_PROJ_ELEM_VER_STRUCTURE ppevs2