DBA Data[Home] [Help]

APPS.LNS_LOAN_PUB dependencies on HZ_CUST_ACCT_SITES_ALL

Line 581: hz_cust_acct_sites_all acct_site

577: SELECT 'Y'
578: INTO l_dummy
579: FROM hz_cust_accounts_all account,
580: hz_cust_site_uses acc_site_use,
581: hz_cust_acct_sites_all acct_site
582: WHERE account.cust_account_id = acct_site.cust_account_id
583: AND acc_site_use.cust_acct_site_id = acct_site.cust_acct_site_id
584: AND acc_site_use.site_use_code = 'BILL_TO'
585: AND acct_site.cust_acct_site_id =