APPS.AR_CMGT_HZ_COVER_API dependencies on HZ_CUSTOMER_PROFILES

Line 297: hz_customer_profiles cp

293: CURSOR find_profile_class(p_party_id IN NUMBER)
294: IS
295: SELECT profile_class_id
296: FROM hz_cust_accounts ca,
297: hz_customer_profiles cp
298: WHERE ca.party_id = p_party_id
299: and ca.cust_account_id = cp.cust_account_id;
300:
301: l_profile_class_id NUMBER;