APPS.AMS_LISTIMPORT_PVT dependencies on HZ_PARTY_SITE_NUMBER_S

Line 13577: select hz_party_site_number_s.nextval into x_party_site_number from dual;

13573: x_gen_party_site_number := fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER');
13574: x_party_site_number := null;
13575: select hz_party_sites_s.nextval into x_party_site_id from dual;
13576: if x_gen_party_site_number = 'N' then
13577: select hz_party_site_number_s.nextval into x_party_site_number from dual;
13578: end if;
13579:
13580: psite_rec.party_site_id := x_party_site_id;
13581: psite_rec.party_site_number := x_party_site_number;