APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_CUST_ACCOUNTS

Line 108: FROM hz_cust_accounts fa

104: fa.cust_account_id,
105: fa.account_name,
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

Line 112: FROM ra_customer_merge_headers mh, hz_cust_accounts ta, hz_parties tp, hz_cust_accounts fa, hz_parties fp

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
115: AND tp.party_id = ta.party_id
116: AND fa.cust_account_id = mh.duplicate_id

Line 175: p_owner_table_name => 'HZ_CUST_ACCOUNTS',

171: -- SSM for merge to account obj
172: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
173: (p_init_msg_list => fnd_api.g_false,
174: p_owner_table_id => x_account_merge_obj.merge_to_account_obj.cust_acct_id,
175: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
176: p_action_type => NULL,
177: x_orig_sys_ref_objs => x_account_merge_obj.merge_to_account_obj.orig_sys_objs,
178: x_return_status => x_return_status,
179: x_msg_count => x_msg_count,

Line 191: p_owner_table_name => 'HZ_CUST_ACCOUNTS',

187:
188: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
189: (p_init_msg_list => fnd_api.g_false,
190: p_owner_table_id => x_account_merge_obj.merge_from_account_objs(I).cust_acct_id,
191: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
192: p_action_type => NULL,
193: x_orig_sys_ref_objs => x_account_merge_obj.merge_from_account_objs(I).orig_sys_objs,
194: x_return_status => x_return_status,
195: x_msg_count => x_msg_count,