APPS.HZ_ORG_CONTACTS_PKG dependencies on DUAL

Line 179: INTO X_ORG_CONTACT_ID FROM dual;

175: BEGIN
176: l_count := 1;
177: WHILE l_count > 0 LOOP
178: SELECT HZ_ORG_CONTACTS_S.NEXTVAL
179: INTO X_ORG_CONTACT_ID FROM dual;
180: BEGIN
181: SELECT 'Y' INTO l_dummy
182: FROM HZ_ORG_CONTACTS
183: WHERE ORG_CONTACT_ID = X_ORG_CONTACT_ID;