DBA Data[Home] [Help]

APPS.AR_CMGT_HZ_COVER_API dependencies on HZ_CUSTOMER_PROFILES

Line 310: hz_customer_profiles cp

306: CURSOR find_profile_class(p_party_id IN NUMBER)
307: IS
308: select cp.profile_class_id
309: from hz_cust_accounts ca,
310: hz_customer_profiles cp
311: where ca.party_id = p_party_id
312: and ca.cust_account_id = cp.cust_account_id
313: and ca.status = 'A'
314: and cp.status = 'A'