DBA Data[Home] [Help]

APPS.AR_RECEIPT_VAL_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 226: hz_customer_profiles cp,

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