APPS.HZ_PARTY_SITES_PKG dependencies on DUAL

Line 171: INTO X_PARTY_SITE_ID FROM dual;

167: BEGIN
168: l_count := 1;
169: WHILE l_count > 0 LOOP
170: SELECT HZ_PARTY_SITES_S.NEXTVAL
171: INTO X_PARTY_SITE_ID FROM dual;
172: BEGIN
173: SELECT 'Y' INTO l_dummy
174: FROM HZ_PARTY_SITES
175: WHERE PARTY_SITE_ID = X_PARTY_SITE_ID;

Line 214: INTO X_PARTY_SITE_NUMBER FROM dual;

210: ELSE
211: l_count := 1;
212: WHILE l_count > 0 LOOP
213: SELECT TO_CHAR( HZ_PARTY_SITE_NUMBER_S.NEXTVAL )
214: INTO X_PARTY_SITE_NUMBER FROM dual;
215: BEGIN
216: SELECT 'Y' INTO l_dummy
217: FROM HZ_PARTY_SITES
218: WHERE PARTY_SITE_NUMBER = X_PARTY_SITE_NUMBER;