APPS.HZ_CUSTOMER_PROFILES_PKG dependencies on DUAL

Line 398: INTO X_CUST_ACCOUNT_PROFILE_ID FROM dual;

394: BEGIN
395: l_count := 1;
396: WHILE l_count > 0 LOOP
397: SELECT HZ_CUSTOMER_PROFILES_S.NEXTVAL
398: INTO X_CUST_ACCOUNT_PROFILE_ID FROM dual;
399: BEGIN
400: SELECT 'Y' INTO l_dummy
401: FROM HZ_CUSTOMER_PROFILES
402: WHERE CUST_ACCOUNT_PROFILE_ID = X_CUST_ACCOUNT_PROFILE_ID;