359: BEGIN
360: l_count := 1;
361: WHILE l_count > 0 LOOP
362: SELECT HZ_CUST_ACCOUNTS_S.NEXTVAL
363: INTO X_CUST_ACCOUNT_ID FROM dual;
364: BEGIN
365: SELECT 'Y' INTO l_dummy
366: FROM HZ_CUST_ACCOUNTS
367: WHERE CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID;
393:
394: l_count := 1;
395: WHILE l_count > 0 LOOP
396: SELECT TO_CHAR( HZ_ACCOUNT_NUM_S.NEXTVAL )
397: INTO X_ACCOUNT_NUMBER FROM dual;
398: BEGIN
399: SELECT 'Y' INTO l_dummy
400: FROM HZ_CUST_ACCOUNTS
401: WHERE ACCOUNT_NUMBER = X_ACCOUNT_NUMBER;