APPS.WSH_SHIP_CONFIRM_ACTIONS2 dependencies on WSH_EXCEPTIONS

Line 1901: FROM wsh_exceptions

1897: l_closed VARCHAR2(30):='CLOSED';
1898:
1899: CURSOR c_exception IS
1900: SELECT decode(severity,'HIGH','H','MEDIUM','M','L') severity
1901: FROM wsh_exceptions
1902: WHERE delivery_detail_id = p_delivery_detail_id
1903: AND status not in (l_not_handled , l_no_action_reqd , l_closed)
1904: ORDER BY decode(severity,'H',1,'M',2,3);
1905: