APPS.HZP_CPROF_PKG dependencies on HZ_CUST_SITE_USES
Line 100: hz_cust_site_uses su
96: statement and dunning profile */
97: select count(1)
98: into l_profile_count
99: from hz_customer_profiles cp, 100: hz_cust_site_uses su 101: where cp.cust_account_id = p_customer_id
102: and cp.site_use_id = p_site_use_id
103: and su.site_use_id = cp.site_use_id
104: and su.site_use_code in ('BILL_TO','DUN','STMTS') ;