APPS.AR_RECEIPT_VAL_PVT dependencies on HZ_CUSTOMER_PROFILES
Line 225: hz_customer_profiles cp,
221: BEGIN
222: SELECT cust.cust_account_id
223: INTO l_dummy_cust.customer_id
224: FROM hz_cust_accounts cust, 225: hz_customer_profiles cp, 226: hz_parties party
227: WHERE cust.cust_account_id = cp.cust_account_id (+) and
228: cp.site_use_id is null and
229: cust.cust_account_id = p_customer_id and