APPS.JAI_AR_TRX_HEADERS_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 30: FROM hz_cust_site_uses_all hzcsu, hz_cust_acct_sites_all hzcas

26: lv_regno JAI_CMN_CUS_ADDRESSES.vat_Reg_no%type;
27:
28: CURSOR c_get_address is
29: SELECT hzcas.cust_acct_site_id
30: FROM hz_cust_site_uses_all hzcsu, hz_cust_acct_sites_all hzcas
31: WHERE hzcas.cust_acct_site_id = hzcsu.cust_acct_site_id
32: AND hzcsu.site_use_id = pn_site_use_id
33: AND hzcas.cust_account_id = pn_customer_id;
34: