APPS.HZ_AIA_CUSTOM_PKG dependencies on HZ_CUST_ACCOUNTS

Line 177: from RA_CUSTOMER_MERGE_HEADERS mh, HZ_CUST_ACCOUNTS ca, HZ_CUST_ACCOUNTS ca2

173: and rel.relationship_id = oc.party_relationship_id(+)
174: group by carm.cust_account_role_id, car.cust_account_role_id,
175: ocm.org_contact_id, oc.org_contact_id
176: ) AS CRMINTEG_HZ_MRGDTIL_OBJ_TBL ))
177: from RA_CUSTOMER_MERGE_HEADERS mh, HZ_CUST_ACCOUNTS ca, HZ_CUST_ACCOUNTS ca2
178: where mh.customer_merge_header_id = l_customer_merge_header_id
179: and mh.process_flag = 'Y'
180: and mh.duplicate_id = ca.cust_account_id(+)
181: and mh.customer_id = ca2.cust_account_id;

Line 193: FROM HZ_CUST_ACCOUNTS

189: AND rownum = 1;
190:
191: CURSOR is_acct_exist(l_cust_acct_id NUMBER) IS
192: SELECT decode(status, 'A', 'Y', 'N')
193: FROM HZ_CUST_ACCOUNTS
194: WHERE cust_account_id = l_cust_acct_id;
195:
196: CURSOR get_deleted_acct_pid(l_cmhdr_id NUMBER, l_cust_acct_id NUMBER) IS
197: SELECT party_id

Line 198: FROM HZ_CUST_ACCOUNTS_M

194: WHERE cust_account_id = l_cust_acct_id;
195:
196: CURSOR get_deleted_acct_pid(l_cmhdr_id NUMBER, l_cust_acct_id NUMBER) IS
197: SELECT party_id
198: FROM HZ_CUST_ACCOUNTS_M
199: WHERE cust_account_id = l_cust_acct_id
200: AND customer_merge_header_id = l_cmhdr_id
201: AND rownum = 1;
202:

Line 400: and md.entity_name = 'HZ_CUST_ACCOUNTS';

396: and mb.batch_id = mp.batch_id
397: and mp.batch_party_id = mph.batch_party_id
398: and mph.merge_dict_id = md.merge_dict_id
399: and p.party_id = mph.to_parent_entity_id
400: and md.entity_name = 'HZ_CUST_ACCOUNTS';
401:
402: CURSOR get_merge_detail(l_batch_id NUMBER, l_party_type VARCHAR2, l_fpid NUMBER, l_fcaid NUMBER, l_tpid NUMBER) IS
403: SELECT CRMINTEG_HZ_MERGE_OBJ(
404: l_party_type, -- party_type