APPS.HZ_PARTY_CONTACT_V2PUB dependencies on HZ_CONTACT_NUMBERS_S
Line 228: SELECT to_char(hz_contact_numbers_s.nextval)
224: IF l_contact_number = FND_API.G_MISS_CHAR OR l_contact_number IS NULL THEN
225: l_count := 1;
226:
227: WHILE l_count > 0 LOOP 228: SELECT to_char(hz_contact_numbers_s.nextval) 229: INTO l_contact_number FROM dual;
230:
231: BEGIN
232: SELECT count(*) --1