148: FROM pa_proj_element_versions pev_l
149: ,pa_lifecycle_usages plu
150: ,pa_proj_element_versions pev_p
151: ,pa_proj_elements ppe_p
152: ,pa_project_statuses pc
153: WHERE pev_l.object_type = 'PA_STRUCTURES'
154: AND pev_l.proj_element_id = p_lifecycle_id
155: AND pev_l.project_id = 0
156: AND plu.usage_type = 'PRODUCTS'
205: FROM pa_proj_element_versions pev_l
206: ,pa_lifecycle_usages plu
207: ,pa_proj_element_versions pev_p
208: ,pa_proj_elements ppe_p
209: ,pa_project_statuses pc
210: WHERE pev_l.object_type = 'PA_STRUCTURES'
211: AND pev_l.proj_element_id = p_lifecycle_id
212: AND pev_l.project_id = 0
213: AND plu.usage_type = 'PRODUCTS'