APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 5154: hz_cust_acct_sites_all hzcas ,

5150: SELECT
5151: hzcas.cust_acct_site_id bill_to_address_id
5152: FROM
5153: hz_cust_accounts hca ,
5154: hz_cust_acct_sites_all hzcas ,
5155: hz_cust_site_uses_all hzcsu
5156: WHERE
5157: hca.cust_account_id = hzcas.cust_account_id
5158: AND hzcas.cust_acct_site_id = hzcsu.cust_acct_site_id

Line 5190: ln_bill_to_address_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;

5186: lv_batch_src_cm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
5187: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
5188: lv_batch_src_name JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
5189: ln_term_id RA_CUST_TRX_TYPES_ALL.DEFAULT_TERM%TYPE;
5190: ln_bill_to_address_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
5191: lv_trx_number RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE;
5192: lv_trx_number_prefix RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE;
5193: ln_ccid_tax_type NUMBER;
5194: rec_cur_get_batch_source CUR_GET_BATCH_SOURCE%ROWTYPE;