DBA Data[Home] [Help]

APPS.IBY_FNDCPT_COMMON_PUB dependencies on HZ_CUST_ACCT_SITES_ALL

Line 44: FROM hz_cust_site_uses_all u, hz_cust_acct_sites_all s,

40: ci_cust_site_id IN hz_cust_site_uses_all.site_use_id%TYPE
41: )
42: IS
43: SELECT COUNT(site_use_id)
44: FROM hz_cust_site_uses_all u, hz_cust_acct_sites_all s,
45: hz_cust_accounts a
46: WHERE (u.site_use_id = ci_cust_site_id)
47: AND (a.cust_account_id = ci_cust_acct_id)
48: AND (u.cust_acct_site_id = s.cust_acct_site_id)