APPS.HZ_ORIG_SYSTEMS_PKG dependencies on DUAL

Line 42: CURSOR C2 IS SELECT HZ_ORIG_SYSTEMS_S.nextval FROM sys.dual;

38: X_LAST_UPDATED_BY in NUMBER,
39: X_LAST_UPDATE_LOGIN in NUMBER*/
40: ) is
41:
42: CURSOR C2 IS SELECT HZ_ORIG_SYSTEMS_S.nextval FROM sys.dual;
43: l_success VARCHAR2(1) := 'N';
44:
45: begin
46: WHILE l_success = 'N' LOOP

Line 140: INTO X_ORIG_SYSTEM_ID FROM dual;

136: BEGIN
137: l_count := 1;
138: WHILE l_count > 0 LOOP
139: SELECT HZ_ORIG_SYSTEMS_S.NEXTVAL
140: INTO X_ORIG_SYSTEM_ID FROM dual;
141: BEGIN
142: SELECT 'Y' INTO l_dummy
143: FROM HZ_ORIG_SYSTEMS_B
144: WHERE ORIG_SYSTEM_ID = X_ORIG_SYSTEM_ID;