APPS.MST_RELEASE dependencies on WSH_NEW_DEL_INTERFACE_S

Line 1281: -- , wsh_new_del_interface_s.nextval

1277: )
1278: , md.delivery_id
1279: , md.sr_delivery_id
1280: , md.out_of_scope
1281: -- , wsh_new_del_interface_s.nextval
1282: , nvl(md.status_code,1) status_code
1283: , md.pickup_date
1284: , md.dropoff_date
1285: , md.pickup_location_id

Line 1326: SET mrt.delivery_id_iface = wsh_new_del_interface_s.nextval

1322: );
1323:
1324: -- update delivery_id_iface and planned_flag for deliveries in mst_release_temp_gt
1325: UPDATE mst_release_temp_gt mrt
1326: SET mrt.delivery_id_iface = wsh_new_del_interface_s.nextval
1327: WHERE mrt.release_id = p_release_id
1328: AND mrt.delivery_id IS NOT NULL;
1329:
1330: -- update planned_flag for deliveries of RCF trips