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
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