DBA Data[Home] [Help]

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') ;