APPS.AMS_REGISTRANTS_PVT dependencies on HZ_PARTY_SITE_NUMBER_S

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

954: x_msg_data := null;
955: x_party_site_number := null;
956: select hz_party_sites_s.nextval into x_party_site_id from dual;
957: if x_gen_party_site_number = 'N' then
958: select hz_party_site_number_s.nextval into x_party_site_number from dual;
959: end if;
960:
961: psite_rec.party_site_id := x_party_site_id;
962: psite_rec.party_id := x_org_party_id;

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

1067: x_msg_data := null;
1068: x_party_site_number := null;
1069: select hz_party_sites_s.nextval into x_party_site_id from dual;
1070: if x_gen_party_site_number = 'N' then
1071: select hz_party_site_number_s.nextval into x_party_site_number from dual;
1072: end if;
1073:
1074: psite_rec.party_site_id := x_party_site_id;
1075: psite_rec.party_id := x_party_rel_party_id;

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

1530: x_msg_data := null;
1531: x_party_site_number := null;
1532: select hz_party_sites_s.nextval into x_party_site_id from dual;
1533: if x_gen_party_site_number = 'N' then
1534: select hz_party_site_number_s.nextval into x_party_site_number from dual;
1535: end if;
1536:
1537: psite_rec.party_site_id := x_party_site_id;
1538: psite_rec.party_id := x_per_party_id;