APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_MERGE_BATCH

Line 1521: FROM hz_merge_batch mb,

1517: AND mp1.merge_type = mp.merge_type
1518: ) AS HZ_PARTY_ORIG_SYS_REF_OBJ_TBL),
1519: HZ_PARTY_MERGE_DETAIL_OBJ_TBL() --5093366
1520: )
1521: FROM hz_merge_batch mb,
1522: (SELECT DISTINCT merge_type from hz_merge_parties where batch_id = p_batch_id and to_party_id = l_merge_to_party_id) mp,
1523: hz_dup_batch db,
1524: hz_dup_sets dset,
1525: hz_parties tp

Line 1770: FROM hz_merge_batch

1766: END IF;
1767:
1768: BEGIN
1769: SELECT batch_id, batch_status INTO l_batch_id, l_merge_status
1770: FROM hz_merge_batch
1771: WHERE batch_id = p_batch_id;
1772: EXCEPTION
1773: WHEN NO_DATA_FOUND THEN
1774: FND_MESSAGE.SET_NAME('AR','HZ_INVALID_DUP_BATCH');