APPS.HZ_CODE_ASSIGNMENTS_PKG dependencies on DUAL

Line 111: INTO X_CODE_ASSIGNMENT_ID FROM dual;

107: BEGIN
108: l_count := 1;
109: WHILE l_count > 0 LOOP
110: SELECT HZ_CODE_ASSIGNMENTS_S.NEXTVAL
111: INTO X_CODE_ASSIGNMENT_ID FROM dual;
112: BEGIN
113: SELECT 'Y' INTO l_dummy
114: FROM HZ_CODE_ASSIGNMENTS
115: WHERE CODE_ASSIGNMENT_ID = X_CODE_ASSIGNMENT_ID;