APPS.JAI_AR_TCS_REP_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 4652: hz_cust_acct_sites_all hzcas ,

4648: SELECT
4649: hzcas.cust_acct_site_id bill_to_address_id
4650: FROM
4651: hz_cust_accounts hca ,
4652: hz_cust_acct_sites_all hzcas ,
4653: hz_cust_site_uses_all hzcsu
4654: WHERE
4655: hca.cust_account_id = hzcas.cust_account_id
4656: AND hzcas.cust_acct_site_id = hzcsu.cust_acct_site_id

Line 4675: ln_bill_to_address_id hz_cust_acct_sites_all.cust_acct_site_id%type ;

4671: lv_batch_src_cm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
4672: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
4673: lv_batch_src_name JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
4674: ln_term_id RA_CUST_TRX_TYPES_ALL.DEFAULT_TERM%TYPE ;
4675: ln_bill_to_address_id hz_cust_acct_sites_all.cust_acct_site_id%type ;
4676: lv_trx_number RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE ;
4677: ln_ccid_tax_type_tcs NUMBER ;
4678: rec_cur_get_batch_source CUR_GET_BATCH_SOURCE%ROWTYPE ;
4679: lv_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE ;