APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_ACCT_ORIG_SYS_REF_OBJ_TBL

Line 110: ) AS HZ_ACCT_ORIG_SYS_REF_OBJ_TBL)

106: fa.account_number,
107: HZ_ORIG_SYS_REF_OBJ_TBL())
108: FROM hz_cust_accounts fa
109: WHERE fa.cust_account_id = mh.duplicate_id
110: ) AS HZ_ACCT_ORIG_SYS_REF_OBJ_TBL)
111: )
112: FROM ra_customer_merge_headers mh, hz_cust_accounts ta, hz_parties tp, hz_cust_accounts fa, hz_parties fp
113: WHERE mh.customer_merge_header_id = p_customer_merge_header_id
114: AND ta.cust_account_id = mh.customer_id