APPS.AML_LEAD_DEDUPE_PVT dependencies on HZ_PARTIES

Line 206: FROM hz_parties hzpc,

202: IS
203:
204: CURSOR c_contact_cp IS
205: SELECT hzpc.party_id
206: FROM hz_parties hzpc,
207: hz_parties hzpr,
208: hz_relationships hzr
209: WHERE hzpc.party_id = p_dup_rec.contact_id
210: AND hzpc.party_id = hzr.subject_id

Line 207: hz_parties hzpr,

203:
204: CURSOR c_contact_cp IS
205: SELECT hzpc.party_id
206: FROM hz_parties hzpc,
207: hz_parties hzpr,
208: hz_relationships hzr
209: WHERE hzpc.party_id = p_dup_rec.contact_id
210: AND hzpc.party_id = hzr.subject_id
211: AND hzr.party_id = hzpr.party_id

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 555: l_contact_id hz_parties.party_id%TYPE;

551: x_msg_data OUT NOCOPY VARCHAR2
552: )
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:

Line 556: l_party_id hz_parties.party_id%TYPE;

552: )
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