APPS.AMS_REGISTRANTS_PVT dependencies on HZ_PARTY_SITE_USES_S

Line 1007: select hz_party_site_uses_s.nextval into x_party_site_use_id from dual;

1003: end if;
1004:
1005: if (p_rec.site_use_code is not null)
1006: then
1007: select hz_party_site_uses_s.nextval into x_party_site_use_id from dual;
1008:
1009: psite_use_rec.site_use_type := p_rec.site_use_code;
1010: psite_use_rec.party_site_id := x_party_site_id;
1011: psite_use_rec.party_site_use_id := x_party_site_use_id;

Line 1118: select hz_party_site_uses_s.nextval into x_party_site_use_id from dual;

1114: end if;
1115:
1116: if (p_rec.site_use_code is not null)
1117: then
1118: select hz_party_site_uses_s.nextval into x_party_site_use_id from dual;
1119:
1120: psite_use_rec.site_use_type := p_rec.site_use_code;
1121: psite_use_rec.party_site_id := x_party_site_id;
1122: psite_use_rec.party_site_use_id := x_party_site_use_id;

Line 1618: select hz_party_site_uses_s.nextval into x_party_site_use_id from dual;

1614: end if;
1615: end if;
1616: if (p_rec.site_use_code is not null)
1617: then
1618: select hz_party_site_uses_s.nextval into x_party_site_use_id from dual;
1619:
1620: psite_use_rec.site_use_type := p_rec.site_use_code;
1621: psite_use_rec.party_site_id := x_party_site_id;
1622: psite_use_rec.party_site_use_id := x_party_site_use_id;