DBA Data[Home] [Help]

APPS.HZ_DQM_DUP_ID_PKG dependencies on HZ_ORG_CONTACTS

Line 1388: from hz_imp_dup_details a, hz_org_contacts b

1384: and b.request_id = p_request_id
1385: )
1386: or
1387: exists (select a.dup_record_id
1388: from hz_imp_dup_details a, hz_org_contacts b
1389: where a.party_id = h.party_id
1390: and a.batch_id = p_batch_id
1391: and a.record_id = b.org_contact_id
1392: and b.request_id = p_request_id

Line 1447: from hz_imp_dup_details a, hz_org_contacts b

1443:
1444:
1445: -- Contact Count
1446: select count(distinct a.dup_record_id) into c_count
1447: from hz_imp_dup_details a, hz_org_contacts b
1448: where a.batch_id = p_batch_id
1449: and a.record_id = b.org_contact_id
1450: and b.request_id = p_request_id ;
1451: