DBA Data[Home] [Help]

APPS.INV_EGO_REVISION_VALIDATE dependencies on PA_LIFECYCLE_USAGES

Line 145: ,pa_lifecycle_usages plu

141: p_lifecycle_phase_id NUMBER) IS
142: --4932389 : Perf fixes for lifecycle-phase-status queries.
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'

Line 202: ,pa_lifecycle_usages plu

198: CURSOR c_Get_Lifecyle_Phase ( p_lifecycle_id NUMBER) IS
199: --4932389 : Perf fixes for lifecycle-phase-status queries.
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'