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;