APPS.WSH_USA_ACTIONS_PVT dependencies on WSH_NEW_DELIVERIES

Line 41: from wsh_delivery_assignments_v wda, wsh_new_deliveries wnd

37: wdd.ship_set_id = c_p_set_id and
38: wdd.source_code = 'OE' and
39: wdd.source_header_id = c_p_source_header_id and
40: ((wdd.released_status = 'C') or exists (select wda.delivery_detail_id
41: from wsh_delivery_assignments_v wda, wsh_new_deliveries wnd
42: where wda.delivery_detail_id = wdd.delivery_detail_id
43: and wda.delivery_id = wnd.delivery_id
44: and wnd.status_code in ('CO', 'IT', 'CL', 'SR', 'SC')))
45: AND rownum = 1;