APPS.IEX_DUNNING_PVT dependencies on AR_CONTACTS_V

Line 166: from ar_contacts_v where contact_party_id = P_CONTACT_ID));

162: from ast_locations_v where party_site_id =
163: (select party_site_id
164: from hz_cust_acct_sites_all where cust_acct_site_id =
165: (select address_id
166: from ar_contacts_v where contact_party_id = P_CONTACT_ID));
167: --End for bug 6500750 gnramasa 13-Nov-07
168:
169: -- get organization location_id
170: cursor get_old_loc_crs1(P_ORG_PARTY_ID number) is