APPS.AMS_LISTIMPORT_PVT dependencies on HZ_PARTY_SITE_NUMBER_S

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

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