DBA Data[Home] [Help]

APPS.HZ_BATCH_DUPLICATE dependencies on HZ_DUP_EXCLUSIONS

Line 967: -- HZ_DUP_EXCLUSIONS table

963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
964: END;
965:
966: -- Remove mathes that have been indicated as non-duplicates in the
967: -- HZ_DUP_EXCLUSIONS table
968: PROCEDURE remove_non_duplicates (
969: p_cur_party_id IN NUMBER,
970: p_dup_set_id IN NUMBER
971: ) IS

Line 979: SELECT 1 FROM HZ_DUP_EXCLUSIONS d

975: DELETE FROM HZ_DUP_SET_PARTIES p
976: WHERE p.dup_set_id = p_dup_set_id
977: AND p.dup_party_id <> p_cur_party_id
978: AND EXISTS (
979: SELECT 1 FROM HZ_DUP_EXCLUSIONS d
980: WHERE (
981: (d.PARTY_ID=p_cur_party_id AND d.DUP_PARTY_ID=p.dup_party_id)
982: OR
983: (d.PARTY_ID=p.dup_party_id AND d.DUP_PARTY_ID=p_cur_party_id)