APPS.WSH_USA_ACTIONS_PVT dependencies on WSH_NEW_DELIVERIES

Line 26: from wsh_delivery_assignments_v wda, wsh_new_deliveries wnd

22: wdd.ship_set_id = c_p_set_id and
23: wdd.source_code = 'OE' and
24: wdd.source_header_id = c_p_source_header_id and
25: ((wdd.released_status = 'C') or exists (select wda.delivery_detail_id
26: from wsh_delivery_assignments_v wda, wsh_new_deliveries wnd
27: where wda.delivery_detail_id = wdd.delivery_detail_id
28: and wda.delivery_id = wnd.delivery_id
29: and wnd.status_code in ('CO', 'IT', 'CL', 'SR', 'SC')))
30: AND rownum = 1;