[Home] [Help]
848: BEGIN
849: SELECT status.ITEM_STATUS_CODE
850: INTO l_status_code
851: FROM EGO_LCPHASE_ITEM_STATUS status
852: ,PA_EGO_PHASES_V phases
853: WHERE phases.PROJ_ELEMENT_ID = p_phase_id
854: AND status.PHASE_CODE = phases.PHASE_CODE
855: AND status.ITEM_STATUS_CODE = l_status_code;
856: EXCEPTION