APPS.AS_INTEREST_MERGE_PKG SQL Statements

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

Line: 34

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 89

	   	   UPDATE AS_INTERESTS_ALL
		   set object_version_number =  nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
			  last_update_date = hz_utility_pub.last_update_date,
			  last_updated_by = hz_utility_pub.user_id,
			  last_update_login = hz_utility_pub.last_update_login,
			  program_application_id = hz_utility_pub.program_application_id,
			  program_id = hz_utility_pub.program_id,
			  program_update_date = sysdate
		   where customer_id = p_from_fk_id;

Line: 99

		   UPDATE AS_INTERESTS_ALL
		   set object_version_number =  nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
			  last_update_date = hz_utility_pub.last_update_date,
			  last_updated_by = hz_utility_pub.user_id,
			  last_update_login = hz_utility_pub.last_update_login,
			  program_application_id = hz_utility_pub.program_application_id,
			  program_id = hz_utility_pub.program_id,
			  program_update_date = sysdate
		   where address_id = p_from_fk_id;

Line: 109

		   UPDATE AS_INTERESTS_ALL
		   set object_version_number =  nvl(object_version_number,0) + 1, contact_id = p_to_fk_id,
			  last_update_date = hz_utility_pub.last_update_date,
			  last_updated_by = hz_utility_pub.user_id,
			  last_update_login = hz_utility_pub.last_update_login,
			  program_application_id = hz_utility_pub.program_application_id,
			  program_id = hz_utility_pub.program_id,
			  program_update_date = sysdate
		   where contact_id = p_from_fk_id;

Line: 151

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 206

	   	   UPDATE AS_CURRENT_ENVIRONMENT
		   set customer_id = p_to_fk_id,
			  last_update_date = hz_utility_pub.last_update_date,
			  last_updated_by = hz_utility_pub.user_id,
			  last_update_login = hz_utility_pub.last_update_login
		   where customer_id = p_from_fk_id;

Line: 213

		   UPDATE AS_CURRENT_ENVIRONMENT
		   set address_id = p_to_fk_id,
			  last_update_date = hz_utility_pub.last_update_date,
			  last_updated_by = hz_utility_pub.user_id,
			  last_update_login = hz_utility_pub.last_update_login
		   where address_id = p_from_fk_id;