APPS.WSH_SHIP_CONFIRM_ACTIONS2 dependencies on WSH_EXCEPTIONS

Line 2089: FROM wsh_exceptions

2085: l_closed VARCHAR2(30):='CLOSED';
2086:
2087: CURSOR c_exception IS
2088: SELECT decode(severity,'HIGH','H','MEDIUM','M','L') severity
2089: FROM wsh_exceptions
2090: WHERE delivery_detail_id = p_delivery_detail_id
2091: AND status not in (l_not_handled , l_no_action_reqd , l_closed)
2092: ORDER BY decode(severity,'H',1,'M',2,3);
2093: