143: SELECT 'x'
144: FROM pa_proj_element_versions pev_l
145: ,pa_lifecycle_usages plu
146: ,pa_proj_element_versions pev_p
147: ,pa_proj_elements ppe_p
148: ,pa_project_statuses pc
149: WHERE pev_l.object_type = 'PA_STRUCTURES'
150: AND pev_l.proj_element_id = p_lifecycle_id
151: AND pev_l.project_id = 0
200: SELECT pev_p.proj_element_id
201: FROM pa_proj_element_versions pev_l
202: ,pa_lifecycle_usages plu
203: ,pa_proj_element_versions pev_p
204: ,pa_proj_elements ppe_p
205: ,pa_project_statuses pc
206: WHERE pev_l.object_type = 'PA_STRUCTURES'
207: AND pev_l.proj_element_id = p_lifecycle_id
208: AND pev_l.project_id = 0