DBA Data[Home] [Help]

APPS.FII_AR_COLLECTORS_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 224: hz_cust_site_uses_all uses

220: FII_LOGIN_ID
221: FROM hz_customer_profiles prof,
222: hz_cust_accounts acct,
223: hz_cust_acct_sites_all sites,
224: hz_cust_site_uses_all uses
225: WHERE prof.site_use_id IS NULL
226: AND acct.cust_account_id = prof.cust_account_id
227: AND acct.cust_account_id = sites.cust_account_id
228: AND sites.cust_acct_site_id = uses.cust_acct_site_id

Line 508: hz_cust_site_uses_all uses

504:
505: FROM hz_customer_profiles prof,
506: hz_cust_accounts acct,
507: hz_cust_acct_sites_all sites,
508: hz_cust_site_uses_all uses
509:
510: WHERE prof.site_use_id IS NULL
511: AND acct.cust_account_id = prof.cust_account_id
512: AND acct.cust_account_id = sites.cust_account_id