APPS.HZ_CUST_ACCT_SITES_PKG dependencies on DUAL

Line 240: INTO X_CUST_ACCT_SITE_ID FROM dual;

236: BEGIN
237: l_count := 1;
238: WHILE l_count > 0 LOOP
239: SELECT HZ_CUST_ACCT_SITES_S.NEXTVAL
240: INTO X_CUST_ACCT_SITE_ID FROM dual;
241: BEGIN
242: SELECT 'Y' INTO l_dummy
243: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
244: WHERE CUST_ACCT_SITE_ID = X_CUST_ACCT_SITE_ID;

Line 262: INTO X_CUST_ACCT_SITE_ID FROM dual;

258: BEGIN
259: l_count := 1;
260: WHILE l_count > 0 LOOP
261: SELECT HZ_CUST_ACCT_SITES_S.NEXTVAL
262: INTO X_CUST_ACCT_SITE_ID FROM dual;
263: BEGIN
264: SELECT 'Y' INTO l_dummy
265: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
266: WHERE ORIG_SYSTEM_REFERENCE = to_char(X_CUST_ACCT_SITE_ID)