DBA Data[Home] [Help]

APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_PARTY_MERGE_DETAIL_OBJ

Line 1519: HZ_PARTY_MERGE_DETAIL_OBJ_TBL() --5093366

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

Line 1533: SELECT HZ_PARTY_MERGE_DETAIL_OBJ(

1529: AND db.dup_batch_id (+)= dset.dup_batch_id
1530: ORDER BY mp.merge_type;
1531: --5093366
1532: CURSOR party_merge_details1 IS
1533: SELECT HZ_PARTY_MERGE_DETAIL_OBJ(
1534: get_object_type(md.entity_name, mph.from_entity_id),
1535: mph.operation_type,
1536: mph.from_entity_id,
1537: CAST(MULTISET(