204: and nvl(end_date_active, sysdate + 1);
205:
206: CURSOR c_wsh_delivery_status(c_status_code VARCHAR2) IS
207: select meaning 208: from wsh_lookups 209: where lookup_type = 'PICK_STATUS' and
210: lookup_code = c_status_code and
211: enabled_flag = 'Y' and
212: trunc(sysdate) between nvl(start_date_active, sysdate - 1)