APPS.JAI_AR_TCS_REP_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 5223: hz_cust_acct_sites_all hzcas ,

5219: SELECT
5220: hzcas.cust_acct_site_id bill_to_address_id
5221: FROM
5222: hz_cust_accounts hca ,
5223: hz_cust_acct_sites_all hzcas ,
5224: hz_cust_site_uses_all hzcsu
5225: WHERE
5226: hca.cust_account_id = hzcas.cust_account_id
5227: AND hzcas.cust_acct_site_id = hzcsu.cust_acct_site_id

Line 5255: ln_bill_to_address_id hz_cust_acct_sites_all.cust_acct_site_id%type ;

5251: lv_batch_src_cm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
5252: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
5253: lv_batch_src_name JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
5254: ln_term_id RA_CUST_TRX_TYPES_ALL.DEFAULT_TERM%TYPE ;
5255: ln_bill_to_address_id hz_cust_acct_sites_all.cust_acct_site_id%type ;
5256: lv_trx_number RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE ;
5257: ln_ccid_tax_type_tcs NUMBER ;
5258: rec_cur_get_batch_source CUR_GET_BATCH_SOURCE%ROWTYPE ;
5259: lv_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE ;