DBA Data[Home] [Help]

APPS.HZ_MERGE_PARTIES_PUB dependencies on HZ_MERGE_PARTY_DETAILS

Line 169: FROM hz_merge_party_details

165: CURSOR merged_relns(cp_batch_party_id NUMBER) IS
166: SELECT merge_from_entity_id, merge_to_entity_id,
167: HZ_MERGE_UTIL.get_reln_party_id(merge_from_entity_id) from_reln_party_id,
168: HZ_MERGE_UTIL.get_reln_party_id(merge_to_entity_id) to_reln_party_id
169: FROM hz_merge_party_details
170: WHERE batch_party_id = cp_batch_party_id
171: AND entity_name = 'HZ_PARTY_RELATIONSHIPS'
172: AND merge_to_entity_id IS NOT NULL
173: AND merge_from_entity_id IS NOT NULL