DBA Data[Home] [Help]

APPS.AR_AUTOREC_API dependencies on HZ_CUST_ACCT_SITES

Line 4261: hz_cust_acct_sites acct_site

4257:
4258: SELECT site_use.site_use_id
4259: INTO l_rcpt_info_tab(i).paying_site_use_id
4260: FROM hz_cust_site_uses site_use,
4261: hz_cust_acct_sites acct_site
4262: WHERE acct_site.cust_account_id = l_rcpt_info_tab(i).paying_customer_id
4263: AND acct_site.status = 'A'
4264: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
4265: AND site_use.site_use_code = nvl('BILL_TO', site_use.site_use_code)