APPS.ISC_DBI_PARTY_MERGE_PKG SQL Statements

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

Line: 22

   SELECT merge_reason_code
     INTO   l_merge_reason_code
     FROM   hz_merge_batch
    WHERE  batch_id  = p_batch_id;

Line: 40

	 update isc_book_sum2_f
	    set customer_id = p_to_fk_id
	  where	customer_id = p_from_fk_id;

Line: 44

	 update isc_book_sum2_f
	    set ship_to_party_id = p_to_fk_id
	  where	ship_to_party_id = p_from_fk_id;

Line: 73

   SELECT merge_reason_code
     INTO   l_merge_reason_code
     FROM   hz_merge_batch
    WHERE  batch_id  = p_batch_id;

Line: 91

	 update isc_book_sum2_pdue_f
	    set customer_id = p_to_fk_id
	  where	customer_id = p_from_fk_id;

Line: 120

   SELECT merge_reason_code
     INTO   l_merge_reason_code
     FROM   hz_merge_batch
    WHERE  batch_id  = p_batch_id;

Line: 138

	 update isc_book_sum2_pdue2_f
	    set customer_id = p_to_fk_id
	  where	customer_id = p_from_fk_id;

Line: 167

   SELECT merge_reason_code
     INTO   l_merge_reason_code
     FROM   hz_merge_batch
    WHERE  batch_id  = p_batch_id;

Line: 185

	 update isc_book_sum2_bkord_f
	    set customer_id = p_to_fk_id
	  where	customer_id = p_from_fk_id;