APPS.HZ_CUST_ACCOUNTS_PKG dependencies on DUAL

Line 342: INTO X_CUST_ACCOUNT_ID FROM dual;

338: BEGIN
339: l_count := 1;
340: WHILE l_count > 0 LOOP
341: SELECT HZ_CUST_ACCOUNTS_S.NEXTVAL
342: INTO X_CUST_ACCOUNT_ID FROM dual;
343: BEGIN
344: SELECT 'Y' INTO l_dummy
345: FROM HZ_CUST_ACCOUNTS
346: WHERE CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID;

Line 376: INTO X_ACCOUNT_NUMBER FROM dual;

372:
373: l_count := 1;
374: WHILE l_count > 0 LOOP
375: SELECT TO_CHAR( HZ_ACCOUNT_NUM_S.NEXTVAL )
376: INTO X_ACCOUNT_NUMBER FROM dual;
377: BEGIN
378: SELECT 'Y' INTO l_dummy
379: FROM HZ_CUST_ACCOUNTS
380: WHERE ACCOUNT_NUMBER = X_ACCOUNT_NUMBER;