DBA Data[Home] [Help]

APPS.INV_EGO_REVISION_VALIDATE dependencies on PA_PROJ_ELEMENTS

Line 147: ,pa_proj_elements ppe_p

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

Line 204: ,pa_proj_elements ppe_p

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