APPS.AML_LEAD_DEDUPE_PVT dependencies on HZ_PARTY_SITES

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

Line 557: l_party_site_id hz_party_sites.party_site_id%TYPE;

553: IS
554: l_duplicate_flag VARCHAR2 (1) := 'U';
555: l_contact_id hz_parties.party_id%TYPE;
556: l_party_id hz_parties.party_id%TYPE;
557: l_party_site_id hz_party_sites.party_site_id%TYPE;
558: l_sales_lead_id as_sales_leads.sales_lead_id%TYPE;
559:
560: BEGIN
561: SAVEPOINT MAIN_PVT;