DBA Data[Home] [Help]

APPS.EGO_INV_ITEM_CATALOG_PVT dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 134: FROM PA_PROJ_ELEMENT_VERSIONS pev_l,

130: ) IS
131:
132: CURSOR c_get_default_phase_id (cp_lifecycle_id IN NUMBER) IS
133: SELECT pev_p.PROJ_ELEMENT_ID
134: FROM PA_PROJ_ELEMENT_VERSIONS pev_l,
135: PA_LIFECYCLE_USAGES plu,
136: PA_PROJ_ELEMENT_VERSIONS pev_p,
137: PA_PROJ_ELEMENTS PPE_P,
138: PA_PROJECT_STATUSES pc

Line 136: PA_PROJ_ELEMENT_VERSIONS pev_p,

132: CURSOR c_get_default_phase_id (cp_lifecycle_id IN NUMBER) IS
133: SELECT pev_p.PROJ_ELEMENT_ID
134: FROM PA_PROJ_ELEMENT_VERSIONS pev_l,
135: PA_LIFECYCLE_USAGES plu,
136: PA_PROJ_ELEMENT_VERSIONS pev_p,
137: PA_PROJ_ELEMENTS PPE_P,
138: PA_PROJECT_STATUSES pc
139: WHERE pev_l.OBJECT_TYPE = 'PA_STRUCTURES'
140: AND pev_l.PROJ_ELEMENT_ID = cp_lifecycle_id