APPS.WSH_UPGRADE_PICK_SLIP_DATA_NEW dependencies on DUAL

Line 57: CURSOR C2 IS SELECT wsh_new_deliveries_s.nextval FROM sys.dual;

53:
54: PROCEDURE Get_Delivery(X_Delivery_ID IN OUT NOCOPY NUMBER,
55: X_name IN OUT NOCOPY VARCHAR2
56: ) IS
57: CURSOR C2 IS SELECT wsh_new_deliveries_s.nextval FROM sys.dual;
58:
59: CURSOR C3 (l_delivery_id NUMBER) IS
60: SELECT 1
61: FROM wsh_deliveries

Line 98: CURSOR C2 IS SELECT wsh_trips_s.nextval FROM sys.dual;

94:
95: PROCEDURE Get_Departure(X_Departure_Id IN OUT NOCOPY NUMBER,
96: X_name IN OUT NOCOPY VARCHAR2
97: ) IS
98: CURSOR C2 IS SELECT wsh_trips_s.nextval FROM sys.dual;
99:
100: CURSOR C3 (l_departure_id NUMBER) IS
101: SELECT 1
102: FROM wsh_departures