APPS.HZ_CUST_ACCOUNT_ROLES_PKG dependencies on DUAL

Line 174: INTO X_CUST_ACCOUNT_ROLE_ID FROM dual;

170: BEGIN
171: l_count := 1;
172: WHILE l_count > 0 LOOP
173: SELECT HZ_CUST_ACCOUNT_ROLES_S.NEXTVAL
174: INTO X_CUST_ACCOUNT_ROLE_ID FROM dual;
175: BEGIN
176: SELECT 'Y' INTO l_dummy
177: FROM HZ_CUST_ACCOUNT_ROLES
178: WHERE CUST_ACCOUNT_ROLE_ID = X_CUST_ACCOUNT_ROLE_ID;