DBA Data[Home] [Help]

APPS.LNS_LOAN_PUB dependencies on HZ_CUST_SITE_USES

Line 1036: hz_cust_site_uses acc_site_use,

1032: BEGIN
1033: SELECT 'Y'
1034: INTO l_dummy
1035: FROM hz_cust_accounts_all account,
1036: hz_cust_site_uses acc_site_use,
1037: hz_cust_acct_sites_all acct_site
1038: WHERE account.cust_account_id = acct_site.cust_account_id
1039: AND acc_site_use.cust_acct_site_id = acct_site.cust_acct_site_id
1040: AND acc_site_use.site_use_code = 'BILL_TO'

Line 1981: hz_cust_site_uses acc_site_use,

1977: BEGIN
1978: SELECT 'Y'
1979: INTO l_dummy
1980: FROM hz_cust_accounts_all account,
1981: hz_cust_site_uses acc_site_use,
1982: hz_cust_acct_sites_all acct_site
1983: WHERE account.cust_account_id = acct_site.cust_account_id
1984: AND acc_site_use.cust_acct_site_id = acct_site.cust_acct_site_id
1985: AND acc_site_use.site_use_code = 'BILL_TO'