APPS.AR_CMGT_PARTY_MERGE SQL Statements

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

Line: 24

	select merge_reason_code
    into   l_merge_reason_code
	from hz_merge_batch
	where batch_id = p_batch_id;

Line: 56

           UPDATE ar_cmgt_credit_requests
            set   party_id = p_To_FK_id
           WHERE  party_id = p_from_fk_id;

Line: 91

	select merge_reason_code
    into   l_merge_reason_code
	from hz_merge_batch
	where batch_id = p_batch_id;

Line: 121

           UPDATE ar_cmgt_credit_requests
            set   contact_party_id = p_To_FK_id
           WHERE  contact_party_id = p_from_fk_id
           AND    contact_party_id IS NOT NULL;

Line: 156

	select merge_reason_code
    into   l_merge_reason_code
	from hz_merge_batch
	where batch_id = p_batch_id;

Line: 186

		    -- First Delete the data record in case of
 	        -- merge otherwise it will create
 	        -- a duplicate record bug 7370428
 	            DELETE from ar_cmgt_cf_dtls
 	              WHERE case_folder_id IN (
 	                 SELECT case_folder_id
 	                 from   ar_cmgt_case_folders
 	                 WHERE  party_id = p_from_fk_id
 	                 AND   type = 'DATA' );

Line: 196

 	            DELETE from ar_cmgt_case_folders
 	              WHERE party_id = p_from_fk_id
 	              AND   type = 'DATA';

Line: 200

           UPDATE ar_cmgt_case_folders
            set   party_id = p_To_FK_id
           WHERE  party_id = p_from_fk_id;

Line: 229

select  merge_reason_code
from    hz_merge_batch
where   batch_id = p_batch_id;

Line: 278

    UPDATE  AR_CUSTOMER_CALLS_ALL
    SET phone_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
        phone_id = p_from_fk_id;

Line: 316

select  merge_reason_code
from    hz_merge_batch
where   batch_id = p_batch_id;

Line: 362

    UPDATE  AR_CUSTOMER_CALL_TOPICS_ALL
    SET phone_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
        phone_id = p_from_fk_id;