APPS.HZ_COMMON_PUB dependencies on HZ_ACCOUNT_NUM_S

Line 268: SELECT to_char(hz_account_num_s.nextval)

264: l_account_number varchar2(30);
265: BEGIN
266: l_count :=1;
267: WHILE l_count > 0 LOOP
268: SELECT to_char(hz_account_num_s.nextval)
269: INTO l_account_number FROM dual;
270: SELECT COUNT(*) INTO l_count
271: FROM hz_cust_accounts
272: WHERE account_number = l_account_number;