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 1953: hz_party_sites party_site,

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

Line 1994: hz_party_sites party_site,

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

Line 2604: hz_party_sites party_site,

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