DBA Data[Home] [Help]

APPS.IEX_DUNNING_PVT dependencies on AR_CONTACTS_V

Line 169: from ar_contacts_v where contact_party_id = P_CONTACT_ID

165: (select party_site_id
166: -- from hz_cust_acct_sites_all where cust_acct_site_id =
167: from hz_cust_acct_sites_all where cust_acct_site_id in
168: (select address_id
169: from ar_contacts_v where contact_party_id = P_CONTACT_ID
170: AND address_id is not null
171: AND status = 'A'));
172: --End for bug 8771065 gnramasa 6th-Aug-09
173: --End for bug 6500750 gnramasa 13-Nov-07