APPS.JMF_GTA_TXT_OPERATOR_PROC dependencies on HZ_CUST_SITE_USES

Line 3305: l_customer_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;

3301: l_address_phonenumber AR_ADDRESSES_V.concatenated_address%TYPE;
3302:
3303: l_party_site_id hz_party_sites.party_site_id%TYPE;
3304: l_customer_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
3305: l_customer_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;
3306:
3307: l_bank_account VARCHAR2(110);
3308:
3309: l_comment VARCHAR2(2) := '//';

Line 3509: hz_cust_site_uses_all hcsua

3505: l_address
3506: , l_customer_site_id
3507: , l_party_site_id
3508: FROM
3509: hz_cust_site_uses_all hcsua
3510: , hz_cust_acct_sites_all addr
3511: , hz_party_sites party_site
3512: , hz_locations loc
3513: , fnd_territories_tl terr

Line 3567: hz_cust_site_uses site

3563: SITE.SITE_USE_ID
3564: INTO
3565: l_customer_site_use_id
3566: FROM
3567: hz_cust_site_uses site
3568: WHERE SITE.CUST_ACCT_SITE_ID = l_customer_site_id
3569: AND SITE.SITE_USE_CODE = 'BILL_TO'
3570: AND SITE.STATUS = 'A';
3571: EXCEPTION