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
1943: Begin
1944: select su.location
1945: into l_dft_bill_to_location
1946: from hz_cust_acct_sites acct_site,
1947: hz_party_sites party_site,
1948: hz_locations loc,
1949: hz_cust_site_uses su,
1950: fnd_territories_vl t
1951: where acct_site.cust_acct_site_id = su.cust_acct_site_id
1977: Begin
1978: select su.location
1979: into l_dft_ship_to_location
1980: from hz_cust_acct_sites acct_site,
1981: hz_party_sites party_site,
1982: hz_locations loc,
1983: hz_cust_site_uses su,
1984: fnd_territories_vl t
1985: where acct_site.cust_acct_site_id = su.cust_acct_site_id
2574: Begin
2575: select su.site_use_id
2576: into x_paying_customer_site_use_id
2577: from hz_cust_acct_sites acct_site,
2578: hz_party_sites party_site,
2579: hz_locations loc,
2580: hz_cust_site_uses su,
2581: fnd_territories_vl t
2582: where acct_site.cust_acct_site_id = su.cust_acct_site_id