APPS.ARP_EXCHANGE_MERGE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 14

   SELECT
	 ca2.orig_system_reference dup_osr
   FROM
	RA_CUSTOMER_MERGES racm,
	HZ_CUST_ACCOUNTS ca2
   WHERE
 	racm.request_id = req_id
 	and racm.set_number = set_num
 	and racm.process_flag = 'N'
	and racm.duplicate_id = ca2.cust_account_id
	and ca2.orig_system_reference like 'EXCHANGE_CUST%';

Line: 38

   * No locking is necessary, as no updates will be done locally.
   * arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');