270: begin
271: select su.primary_salesrep_id
272: into l_default_srep_id_1
273: from hz_cust_acct_sites acct_site,
274: hz_party_sites party_site,
275: hz_locations loc,
276: hz_cust_site_uses su,
277: fnd_territories_vl t
278: where acct_site.cust_acct_site_id = su.cust_acct_site_id
1949: Begin
1950: select su.location
1951: into l_dft_bill_to_location
1952: from hz_cust_acct_sites acct_site,
1953: hz_party_sites party_site,
1954: hz_locations loc,
1955: hz_cust_site_uses su,
1956: fnd_territories_vl t
1957: where acct_site.cust_acct_site_id = su.cust_acct_site_id
1990: Begin
1991: select su.location
1992: into l_dft_ship_to_location
1993: from hz_cust_acct_sites acct_site,
1994: hz_party_sites party_site,
1995: hz_locations loc,
1996: hz_cust_site_uses su,
1997: fnd_territories_vl t
1998: where acct_site.cust_acct_site_id = su.cust_acct_site_id
2600: Begin
2601: select su.site_use_id
2602: into x_paying_customer_site_use_id
2603: from hz_cust_acct_sites acct_site,
2604: hz_party_sites party_site,
2605: hz_locations loc,
2606: hz_cust_site_uses su,
2607: fnd_territories_vl t
2608: where acct_site.cust_acct_site_id = su.cust_acct_site_id