APPS.HZ_CUST_PROF_CLASS_AMTS_PKG dependencies on DUAL

Line 293: INTO X_PROFILE_CLASS_AMOUNT_ID FROM dual;

289: BEGIN
290: l_count := 1;
291: WHILE l_count > 0 LOOP
292: SELECT HZ_CUST_PROF_CLASS_AMTS_S.NEXTVAL
293: INTO X_PROFILE_CLASS_AMOUNT_ID FROM dual;
294: BEGIN
295: SELECT 'Y' INTO l_dummy
296: FROM HZ_CUST_PROF_CLASS_AMTS
297: WHERE PROFILE_CLASS_AMOUNT_ID = X_PROFILE_CLASS_AMOUNT_ID;