APPS.WSH_CONTAINER_UTILITIES dependencies on WSH_NEW_DELIVERIES

Line 3158: FROM wsh_delivery_assignments_v wda, WSH_NEW_DELIVERIES wnd, WSH_DELIVERY_DETAILS wdd

3154: x_return_status OUT NOCOPY VARCHAR2) IS
3155:
3156: CURSOR Get_Delivery_Status (v_cont_instance_id NUMBER) IS
3157: SELECT wda.delivery_id, wnd.status_code
3158: FROM wsh_delivery_assignments_v wda, WSH_NEW_DELIVERIES wnd, WSH_DELIVERY_DETAILS wdd
3159: WHERE wda.delivery_detail_id = v_cont_instance_id
3160: AND wda.delivery_id = wnd.delivery_id
3161: AND wdd.delivery_detail_id = wda.delivery_detail_id
3162: AND wdd.container_flag in ('Y', 'C');