APPS.WSH_NEW_DELIVERIES_PVT dependencies on WSH_NEW_DELIVERIES_S

Line 39: SELECT wsh_new_deliveries_s.nextval

35: x_return_status OUT NOCOPY VARCHAR2
36: ) IS
37:
38: CURSOR get_next_delivery IS
39: SELECT wsh_new_deliveries_s.nextval
40: FROM sys.dual;
41:
42: CURSOR count_delivery_rows (v_delivery_name VARCHAR2) IS
43: SELECT delivery_id

Line 2640: SELECT wsh_new_deliveries_s.nextval

2636: -- Generate delivery ID
2637: --
2638: CURSOR get_next_delivery
2639: IS
2640: SELECT wsh_new_deliveries_s.nextval
2641: FROM dual;
2642: --
2643: CURSOR dlvy_csr(p_delivery_id NUMBER)
2644: IS