8986: Select ppevs.element_version_id
8987: FROM PA_Proj_Elem_Ver_Structure ppevs,
8988: PA_Proj_Elements ppe,
8989: PA_Proj_Structure_Types ppst,
8990: PA_Structure_types pst
8991: WHERE ppevs.Project_ID = P_Project_ID
8992: AND ppevs.status_code = 'STRUCTURE_PUBLISHED'
8993: AND ppevs.proj_element_id = ppe.Proj_Element_ID
8994: AND ppe.Project_ID = ppevs.Project_ID
21547: Select count(1)
21548: FROM PA_Proj_Elem_Ver_Structure ppevs,
21549: PA_Proj_Elements ppe,
21550: PA_Proj_Structure_Types ppst,
21551: PA_Structure_types pst
21552: WHERE ppevs.Project_ID = P_Project_ID
21553: AND ppevs.status_code = 'STRUCTURE_PUBLISHED'
21554: AND ppevs.proj_element_id = ppe.Proj_Element_ID
21555: AND ppe.Project_ID = ppevs.Project_ID