DBA Data[Home] [Help]

APPS.AR_RECEIPT_VAL_PVT dependencies on HZ_PARTIES

Line 226: hz_parties party

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
230: cust.party_id = party.party_id;