DBA Data[Home] [Help]

APPS.OE_NOTIFY_USER_WF dependencies on HZ_CUST_ACCT_SITES_ALL

Line 448: hz_cust_acct_sites_all cas,

444: ELSIF l_cust_type = 'BILL_TO_ACCT_ID' THEN
445: SELECT cust.cust_account_id
446: INTO l_customer_id
447: FROM hz_cust_site_uses_all site,
448: hz_cust_acct_sites_all cas,
449: hz_cust_accounts cust,
450: hz_parties party
451: WHERE site.site_use_code = 'BILL_TO'
452: AND site.site_use_id = l_invoice_to_org_id