DBA Data[Home] [Help]

APPS.HZ_BATCH_DUPLICATE dependencies on HZ_DUP_EXCLUSIONS

Line 973: -- HZ_DUP_EXCLUSIONS table

969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
970: END;
971:
972: -- Remove mathes that have been indicated as non-duplicates in the
973: -- HZ_DUP_EXCLUSIONS table
974: PROCEDURE remove_non_duplicates (
975: p_cur_party_id IN NUMBER,
976: p_dup_set_id IN NUMBER
977: ) IS

Line 985: SELECT 1 FROM HZ_DUP_EXCLUSIONS d

981: DELETE FROM HZ_DUP_SET_PARTIES p
982: WHERE p.dup_set_id = p_dup_set_id
983: AND p.dup_party_id <> p_cur_party_id
984: AND EXISTS (
985: SELECT 1 FROM HZ_DUP_EXCLUSIONS d
986: WHERE (
987: (d.PARTY_ID=p_cur_party_id AND d.DUP_PARTY_ID=p.dup_party_id)
988: OR
989: (d.PARTY_ID=p.dup_party_id AND d.DUP_PARTY_ID=p_cur_party_id)