APPS.WSH_DEPARTURES_PKG dependencies on DUAL

Line 58: CURSOR C2 IS SELECT wsh_departures_s.nextval FROM sys.dual;

54: X_Last_Update_Login NUMBER
55: ) IS
56: CURSOR C IS SELECT rowid FROM wsh_departures
57: WHERE departure_id = X_Departure_Id;
58: CURSOR C2 IS SELECT wsh_departures_s.nextval FROM sys.dual;
59: dname wsh_departures.name%TYPE;
60: CURSOR C3 (dep_name VARCHAR2) IS
61: SELECT COUNT(*) FROM wsh_departures
62: WHERE name = dep_name;

Line 432: CURSOR C2 IS SELECT wsh_departures_s.nextval FROM sys.dual;

428: X_Last_Updated_By NUMBER,
429: X_Last_Update_Login NUMBER
430: ) IS
431: dname wsh_departures.name%TYPE;
432: CURSOR C2 IS SELECT wsh_departures_s.nextval FROM sys.dual;
433: CURSOR C3 (dep_name VARCHAR2) IS
434: SELECT COUNT(*) FROM wsh_departures
435: WHERE name = dep_name;
436: temp NUMBER;