APPS.AR_IREC_PAYMENTS dependencies on HZ_CUST_ACCT_SITES

Line 4501: hz_cust_acct_sites acct_site

4497:
4498: BEGIN
4499: SELECT site_use.site_use_id into l_site_use_id
4500: FROM hz_cust_site_uses site_use,
4501: hz_cust_acct_sites acct_site
4502: WHERE acct_site.cust_account_id = p_customer_id
4503: AND acct_site.status = 'A'
4504: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
4505: AND site_use.site_use_code = nvl('BILL_TO',site_use.site_use_code)