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