APPS.HZ_CUST_PROFILE_AMTS_PKG dependencies on DUAL

Line 308: INTO X_CUST_ACCT_PROFILE_AMT_ID FROM dual;

304: BEGIN
305: l_count := 1;
306: WHILE l_count > 0 LOOP
307: SELECT HZ_CUST_PROFILE_AMTS_S.NEXTVAL
308: INTO X_CUST_ACCT_PROFILE_AMT_ID FROM dual;
309: BEGIN
310: SELECT 'Y' INTO l_dummy
311: FROM HZ_CUST_PROFILE_AMTS
312: WHERE CUST_ACCT_PROFILE_AMT_ID = X_CUST_ACCT_PROFILE_AMT_ID;