APPS.AML_LEAD_DEDUPE_PVT dependencies on HZ_LOCATIONS

Line 238: FROM hz_locations hzl, hz_party_sites hzs, hz_parties hzp

234: IS
235: CURSOR c_customer_location_chk
236: IS
237: SELECT party_site_id, hzp.party_id
238: FROM hz_locations hzl, hz_party_sites hzs, hz_parties hzp
239: WHERE hzp.party_id = p_dup_rec.party_id
240: AND hzp.party_id = hzs.party_id
241: AND hzs.location_id = hzl.location_id
242: AND hzs.party_site_id = p_dup_rec.party_site_id