DBA Data[Home] [Help]

APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_PARTY_MERGE_DETAIL_OBJ

Line 348: HZ_PARTY_MERGE_DETAIL_OBJ_TBL() --5093366

344: WHERE mp1.batch_id = p_batch_id
345: AND mp1.to_party_id = p_merge_to_party_id
346: AND fp.party_id = mp1.from_party_id
347: ) AS HZ_PARTY_ORIG_SYS_REF_OBJ_TBL),
348: HZ_PARTY_MERGE_DETAIL_OBJ_TBL() --5093366
349: )
350: FROM hz_merge_batch mb,
351: (SELECT DISTINCT merge_type from hz_merge_parties where batch_id = p_batch_id and to_party_id = p_merge_to_party_id) mp,
352: hz_dup_batch db,

Line 362: SELECT HZ_PARTY_MERGE_DETAIL_OBJ(

358: AND db.dup_batch_id (+)= dset.dup_batch_id
359: ORDER BY mp.merge_type;
360: --5093366
361: CURSOR party_merge_details1 IS
362: SELECT HZ_PARTY_MERGE_DETAIL_OBJ(
363: get_object_type(md.entity_name, mph.from_entity_id),
364: mph.operation_type,
365: mph.from_entity_id,
366: CAST(MULTISET(