APPS.CLN_SHOWSHIP_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS
Line 222: wsh_delivery_assignments wda
218:
219: -- Validations
220: select count(*) into cnt
221: from wsh_new_deliveries wnd, 222: wsh_delivery_assignments wda 223: where wnd.delivery_id = wda.delivery_id
224: and wda.delivery_id = p_delivery_id
225: and wnd.status_code not in ('SR','SC','OP');
226: