DBA Data[Home] [Help]

APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_PARTY_ORIG_SYS_REF_OBJ_TBL

Line 347: ) AS HZ_PARTY_ORIG_SYS_REF_OBJ_TBL),

343: FROM hz_parties fp, hz_merge_parties mp1
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,