APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_MERGE_PARTIES

Line 1513: FROM hz_parties fp, hz_merge_parties mp1

1509: fp.party_number,
1510: fp.party_name,
1511: fp.party_type,
1512: HZ_ORIG_SYS_REF_OBJ_TBL())
1513: FROM hz_parties fp, hz_merge_parties mp1
1514: WHERE mp1.batch_id = p_batch_id
1515: AND mp1.to_party_id = l_merge_to_party_id
1516: AND fp.party_id = mp1.from_party_id
1517: AND mp1.merge_type = mp.merge_type

Line 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,

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
1526: WHERE mb.batch_id = p_batch_id

Line 1733: FROM hz_merge_parties mp2,

1729:
1730: )AS HZ_ORIG_SYS_REF_OBJ_TBL)
1731:
1732: )
1733: FROM hz_merge_parties mp2,
1734: hz_merge_party_history mph,
1735: hz_merge_dictionary md
1736: WHERE mp2.batch_id = p_batch_id
1737: AND mp2.to_party_id = l_merge_to_party_id

Line 1781: FROM hz_merge_parties

1777: END;
1778: IF p_merge_to_party_id IS NOT NULL THEN
1779: BEGIN
1780: SELECT to_party_id INTO l_merge_to_party_id
1781: FROM hz_merge_parties
1782: WHERE batch_id = p_batch_id
1783: AND to_party_id = p_merge_to_party_id
1784: AND rownum = 1;
1785: EXCEPTION

Line 1793: FROM hz_merge_parties

1789: RAISE fnd_api.g_exc_error;
1790: END;
1791: ELSE
1792: SELECT to_party_id INTO l_merge_to_party_id
1793: FROM hz_merge_parties
1794: WHERE batch_id = p_batch_id
1795: AND NVL(merge_reason_code , 'DEDUPE') <> 'DUPLICATE_RELN_PARTY'
1796: AND rownum = 1;
1797: END IF;