DBA Data[Home] [Help]

APPS.AR_DEPOSIT_LIB_PVT dependencies on HZ_PARTY_SITES

Line 274: hz_party_sites party_site,

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

Line 1947: hz_party_sites party_site,

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

Line 1981: hz_party_sites party_site,

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

Line 2578: hz_party_sites party_site,

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