APPS.WSH_DELIVERIES_PKG dependencies on DUAL

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

81: X_Last_Updated_By NUMBER,
82: X_Last_Update_Login NUMBER
83: ) IS
84: dname wsh_deliveries.name%TYPE;
85: CURSOR C2 IS SELECT wsh_deliveries_s.nextval FROM sys.dual;
86: CURSOR C3 (del_name VARCHAR2) IS
87: SELECT COUNT(*) FROM wsh_deliveries
88: WHERE name = del_name;
89: temp NUMBER;

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

558: X_Last_Updated_By NUMBER,
559: X_Last_Update_Login NUMBER
560: ) IS
561: dname wsh_deliveries.name%TYPE;
562: CURSOR C2 IS SELECT wsh_deliveries_s.nextval FROM sys.dual;
563: CURSOR C3 (del_name VARCHAR2) IS
564: SELECT COUNT(*) FROM wsh_deliveries
565: WHERE name = del_name;
566: temp NUMBER;