DBA Data[Home] [Help]

APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_DUP_SETS

Line 1524: hz_dup_sets dset,

1520: )
1521: FROM hz_merge_batch mb,
1522: (SELECT DISTINCT merge_type from hz_merge_parties where batch_id = p_batch_id and to_party_id = l_merge_to_party_id) mp,
1523: hz_dup_batch db,
1524: hz_dup_sets dset,
1525: hz_parties tp
1526: WHERE mb.batch_id = p_batch_id
1527: AND tp.party_id = l_merge_to_party_id
1528: AND mb.batch_id = dset.dup_set_id (+)