APPS.AR_GTA_TXT_OPERATOR_PROC dependencies on HZ_CUST_SITE_USES

Line 3570: l_customer_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;

3566: l_address_phonenumber AR_ADDRESSES_V.concatenated_address%TYPE;
3567:
3568: l_party_site_id hz_party_sites.party_site_id%TYPE;
3569: l_customer_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
3570: l_customer_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;
3571:
3572: -- modified by allen yang 17/Jun/2009 for bug 8605196 to display bank info in Chinese
3573: -------------------------------------------------------------------------------------
3574: --l_bank_account VARCHAR2(110);

Line 3907: hz_cust_site_uses_all hcsua

3903: l_address
3904: , l_customer_site_id
3905: , l_party_site_id
3906: FROM
3907: hz_cust_site_uses_all hcsua
3908: , hz_cust_acct_sites_all addr
3909: , hz_party_sites party_site
3910: , hz_locations loc
3911: , fnd_territories_tl terr

Line 3965: hz_cust_site_uses site

3961: SITE.SITE_USE_ID
3962: INTO
3963: l_customer_site_use_id
3964: FROM
3965: hz_cust_site_uses site
3966: WHERE SITE.CUST_ACCT_SITE_ID = l_customer_site_id
3967: AND SITE.SITE_USE_CODE = 'BILL_TO'
3968: AND SITE.STATUS = 'A';
3969: EXCEPTION