APPS.WMS_TASK_MGMT_PUB dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 269: FROM wsh_delivery_assignments

265: AND ROWNUM = 1;*/
266: CURSOR c_get_delivery_id(p_delivery_detail_id NUMBER)
267: IS
268: SELECT delivery_id
269: FROM wsh_delivery_assignments
270: WHERE delivery_detail_id = p_delivery_detail_id;
271: CURSOR c_bulk_task(p_transaction_number NUMBER)
272: IS
273: SELECT '1'

Line 430: FROM wsh_delivery_assignments

426: LOOP
427: BEGIN
428: SELECT delivery_id
429: INTO l_temp_del_id
430: FROM wsh_delivery_assignments
431: WHERE delivery_detail_id = l_del_det_id_tab(i);
432: EXCEPTION
433: WHEN OTHERS THEN
434: l_temp_del_id := NULL;

Line 1240: FROM wsh_delivery_assignments

1236: AND ROWNUM = 1;
1237: CURSOR c_get_delivery_id(p_delivery_detail_id NUMBER)
1238: IS
1239: SELECT delivery_id
1240: FROM wsh_delivery_assignments
1241: WHERE delivery_detail_id = p_delivery_detail_id;
1242: CURSOR c_bulk_task(p_transaction_number NUMBER)
1243: IS
1244: SELECT '1'

Line 1370: FROM wsh_delivery_assignments

1366: LOOP
1367: BEGIN
1368: SELECT delivery_id
1369: INTO l_temp_del_id
1370: FROM wsh_delivery_assignments
1371: WHERE delivery_detail_id = l_del_det_id_tab(i);
1372: EXCEPTION
1373: WHEN OTHERS THEN
1374: l_temp_del_id := NULL;