APPS.HZ_COMMON_PUB dependencies on HZ_PARTY_SITE_NUMBER_S

Line 310: SELECT to_char(hz_party_site_number_s.nextval)

306: l_party_site_number varchar2(30);
307: BEGIN
308: l_count :=1;
309: WHILE l_count > 0 LOOP
310: SELECT to_char(hz_party_site_number_s.nextval)
311: INTO l_party_site_number FROM dual;
312: SELECT COUNT(*) INTO l_count
313: FROM hz_party_sites
314: WHERE party_site_number = l_party_site_number;