APPS.AR_DEPOSIT_LIB_PVT dependencies on HZ_CUST_ACCT_SITES

Line 103: hz_cust_acct_sites acct_site,

99: hz_parties party,
100: hz_relationships rel,
101: hz_org_contacts org_cont,
102: hz_parties rel_party,
103: hz_cust_acct_sites acct_site,
104: hz_cust_site_uses site_uses
105: where acct_role.party_id = rel.party_id
106: and acct_role.role_type = 'CONTACT'
107: and org_cont.party_relationship_id = rel.relationship_id

Line 273: from hz_cust_acct_sites acct_site,

269:
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

Line 323: HZ_CUST_ACCT_SITES A,

319: SU.STATUS SU_STATUS ,
320: SU.SITE_USE_ID SITE_USE_ID ,
321: SU.PRIMARY_SALESREP_ID
322: FROM
323: HZ_CUST_ACCT_SITES A,
324: HZ_CUST_SITE_USES SU
325: WHERE
326: A.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
327: AND SU.SITE_USE_CODE = 'SHIP_TO'

Line 972: p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,

968: | FUNCTION Get_Site_Use_Id will get Site_Use_Id of customer location
969: +=======================================================================*/
970:
971: FUNCTION Get_Site_Use_Id(
972: p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,
973: p_location IN hz_cust_site_uses.location%TYPE,
974: p_site_use_code1 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
975: p_site_use_code2 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
976: p_return_status OUT NOCOPY VARCHAR2)

Line 993: hz_cust_acct_sites acct_site

989:
990: SELECT site_use.site_use_id
991: INTO l_selected_id
992: FROM hz_cust_site_uses site_use,
993: hz_cust_acct_sites acct_site
994: WHERE acct_site.cust_account_id = p_customer_id
995: AND acct_site.status = 'A'
996: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
997: AND (site_use.site_use_code = nvl(p_site_use_code1,

Line 1022: hz_cust_acct_sites acct_site

1018:
1019: SELECT site_use.site_use_id
1020: INTO l_selected_id
1021: FROM hz_cust_site_uses site_use,
1022: hz_cust_acct_sites acct_site
1023: WHERE acct_site.cust_account_id = p_customer_id
1024: AND acct_site.status = 'A'
1025: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
1026: AND (site_use.site_use_code = nvl(p_site_use_code1,

Line 1952: from hz_cust_acct_sites acct_site,

1948:
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

Line 1993: from hz_cust_acct_sites acct_site,

1989:
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

Line 2603: from hz_cust_acct_sites acct_site,

2599: --get default location of paying customer
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