DBA Data[Home] [Help]

APPS.HZ_DQM_DUP_ID_PKG dependencies on HZ_CONTACT_POINTS

Line 1380: from hz_imp_dup_details a, hz_contact_points b

1376: and b.request_id = p_request_id
1377: )
1378: or
1379: exists (select a.dup_record_id
1380: from hz_imp_dup_details a, hz_contact_points b
1381: where a.party_id = h.party_id
1382: and a.batch_id = p_batch_id
1383: and a.record_id = b.contact_point_id
1384: and b.request_id = p_request_id

Line 1435: from hz_imp_dup_details a, hz_contact_points b

1431:
1432:
1433: -- Contact Point Count
1434: select count(distinct a.dup_record_id) into cp_count
1435: from hz_imp_dup_details a, hz_contact_points b
1436: where a.batch_id = p_batch_id
1437: and a.record_id = b.contact_point_id
1438: and b.request_id = p_request_id ;
1439: update hz_imp_batch_summary h