APPS.WSH_DELIVERIES_PKG1 dependencies on DUAL

Line 87: CURSOR C2 IS SELECT wsh_deliveries_s.nextval FROM sys.dual;

83: X_Last_Update_Login NUMBER
84: ) IS
85: CURSOR C IS SELECT rowid FROM wsh_deliveries
86: WHERE delivery_id = X_Delivery_Id;
87: CURSOR C2 IS SELECT wsh_deliveries_s.nextval FROM sys.dual;
88: dname wsh_deliveries.name%TYPE;
89: CURSOR C3 (del_name VARCHAR2) IS
90: SELECT COUNT(*) FROM wsh_deliveries
91: WHERE name = del_name;

Line 380: CURSOR C2 IS SELECT wsh_deliveries_s.nextval FROM sys.dual;

376: X_Last_Update_Login NUMBER
377: ) IS
378: CURSOR C IS SELECT rowid FROM wsh_deliveries
379: WHERE delivery_id = X_Delivery_Id;
380: CURSOR C2 IS SELECT wsh_deliveries_s.nextval FROM sys.dual;
381: dname wsh_deliveries.name%TYPE;
382: CURSOR C3 (del_name VARCHAR2) IS
383: SELECT COUNT(*) FROM wsh_deliveries
384: WHERE name = del_name;