DBA Data[Home] [Help]

APPS.AR_RECEIPT_VAL_PVT dependencies on HZ_PARTIES

Line 227: hz_parties party

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