APPS.HZ_CUSTOMER_PROFILES_PKG dependencies on DUAL

Line 388: INTO X_CUST_ACCOUNT_PROFILE_ID FROM dual;

384: BEGIN
385: l_count := 1;
386: WHILE l_count > 0 LOOP
387: SELECT HZ_CUSTOMER_PROFILES_S.NEXTVAL
388: INTO X_CUST_ACCOUNT_PROFILE_ID FROM dual;
389: BEGIN
390: SELECT 'Y' INTO l_dummy
391: FROM HZ_CUSTOMER_PROFILES
392: WHERE CUST_ACCOUNT_PROFILE_ID = X_CUST_ACCOUNT_PROFILE_ID;