APPS.AR_AME_CM_ATTRIBUTES_API dependencies on HZ_CUSTOMER_PROFILES

Line 131: hz_customer_profiles cp

127: -- the first value returned
128: CURSOR coll_id (p_customer_id NUMBER, p_bill_to_use_id NUMBER) IS
129: SELECT 'person_id:' || col.employee_id, cp.site_use_id
130: FROM ar_collectors col,
131: hz_customer_profiles cp
132: WHERE cp.collector_id = col.collector_id
133: AND cp.cust_account_id = p_customer_id
134: AND (cp.site_use_id = p_bill_to_use_id
135: OR cp.site_use_id is NULL)