DBA Data[Home] [Help]

APPS.OE_PAYMENT_TRXN_UTIL dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2977: FROM hz_cust_acct_sites_all acctsite, hz_cust_site_uses_all site, hz_cust_accounts_all hca

2973:
2974: Begin
2975: SELECT hca.party_id,acctsite.cust_account_id
2976: INTO l_party_id, l_cust_account_id
2977: FROM hz_cust_acct_sites_all acctsite, hz_cust_site_uses_all site, hz_cust_accounts_all hca
2978: WHERE SITE.SITE_USE_CODE = 'BILL_TO'
2979: AND SITE.CUST_ACCT_SITE_ID = ACCTSITE.CUST_ACCT_SITE_ID
2980: AND ACCTSITE.cust_account_id = HCA.cust_account_id
2981: AND SITE.SITE_USE_ID = l_invoice_to_org_id;