DBA Data[Home] [Help]

APPS.CSD_SOO_PVT dependencies on WSH_LOOKUPS

Line 208: from wsh_lookups

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)