1730: WHILE l_count > 0 LOOP
1731:
1732: SELECT to_char(hz_party_site_number_s.nextval)
1733: INTO l_party_site_number 1734: FROM dual; 1735:
1736: SELECT COUNT(*) INTO l_count
1737: FROM hz_party_sites_v
1738: WHERE party_site_number = l_party_site_number;