APPS.JMF_GTA_ARTRX_PROC dependencies on HZ_CUST_ACCT_SITES

Line 2059: l_cust_acct_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;

2055: l_amount ra_customer_trx_lines_all.taxable_amount%TYPE;
2056:
2057: -- for get bank info by customer id
2058: l_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;
2059: l_cust_acct_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2060:
2061: l_cm_export_iv VARCHAR2(500);
2062: l_cm_export_nr VARCHAR2(500);
2063: l_index NUMBER; -- index of the nested table

Line 2451: Hz_Cust_Acct_Sites_All RAA_BILL,

2447: RAA_BILL_LOC.POSTAL_CODE,
2448: FT_BILL.TERRITORY_SHORT_NAME))
2449: INTO l_raa_bill_to_concat_address
2450: FROM HZ_CUST_SITE_USES_ALL SU_BILL,
2451: Hz_Cust_Acct_Sites_All RAA_BILL,
2452: HZ_PARTY_SITES RAA_BILL_PS,
2453: Hz_Locations RAA_BILL_LOC,
2454: FND_TERRITORIES_VL FT_BILL,
2455: ra_customer_trx_all h