APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_CUST_ACCT_RELATE_ALL

Line 895: get_object_type('HZ_CUST_ACCT_RELATE_ALL',crelf.cust_acct_relate_id),

891: AND cust_account_id = cm.duplicate_id));
892:
893: CURSOR get_acct_rels(duplicate_id number, customer_id number) IS
894: SELECT HZ_ACCOUNT_MERGE_DETAIL_OBJ(
895: get_object_type('HZ_CUST_ACCT_RELATE_ALL',crelf.cust_acct_relate_id),
896: decode(crelt.created_by_module,'HZ_TCA_CUSTOMER_MERGE','Transfer','Merge'),
897: crelt.org_id,
898: get_operating_unit(crelt.org_id),
899: crelf.cust_acct_relate_id,

Line 996: FROM hz_cust_acct_relate_all_m crelf, hz_cust_acct_relate_all crelt

992: WHERE OWNER_TABLE_ID = customer_id
993: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
994: )AS HZ_ORIG_SYS_REF_OBJ_TBL)
995: )
996: FROM hz_cust_acct_relate_all_m crelf, hz_cust_acct_relate_all crelt
997: WHERE ((crelf.cust_account_id = duplicate_id
998: AND crelt.cust_account_id = customer_id
999: AND crelt.related_cust_account_id = crelf.related_cust_account_id)
1000: OR