The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT account_owner_id
FROM iby_account_owners mto,
( SELECT ext_bank_account_id
FROM iby_account_owners
WHERE (account_owner_id = ci_owner_id) ) mfrom
WHERE mto.account_owner_party_id = ci_party_id
AND mto.ext_bank_account_id = mfrom.ext_bank_account_id;
SELECT merge_reason_code
INTO l_merge_reason
FROM hz_merge_batch
WHERE batch_id = p_batch_id;
UPDATE iby_account_owners
SET account_owner_party_id = DECODE(l_dup_id, NULL,p_to_fk_id, account_owner_party_id),
end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
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 (account_owner_id = p_from_id);
SELECT instrid
FROM iby_creditcard mto,
(SELECT cc_number_hash1, cc_number_hash2
FROM iby_creditcard WHERE (instrid = ci_instr_id)) mfrom
WHERE
mto.card_owner_id = ci_owner_id
AND mto.cc_number_hash1 = mfrom.cc_number_hash1
AND mto.cc_number_hash2 = mfrom.cc_number_hash2
AND NVL(mto.active_flag,'Y') = 'Y'
AND (NVL(mto.inactive_date,SYSDATE+10) > SYSDATE);
SELECT merge_reason_code
INTO l_merge_reason
FROM hz_merge_batch
WHERE batch_id = p_batch_id;
UPDATE iby_creditcard
SET card_owner_id = DECODE(l_dup_id, NULL,p_to_fk_id, card_owner_id),
active_flag = DECODE(l_dup_id, NULL,active_flag, 'N'),
inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
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,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = sysdate
WHERE (instrid = p_from_id);
UPDATE iby_creditcard
SET addressid = 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,
request_id = hz_utility_pub.request_id,
program_application_id = hz_utility_pub.program_application_id,
program_id = hz_utility_pub.program_id,
program_update_date = sysdate
WHERE (instrid = p_from_id);
SELECT ext_payer_id
FROM iby_external_payers_all mto,
(SELECT payment_function,ci_party_id,cust_account_id,acct_site_use_id,
org_type,org_id
FROM iby_external_payers_all
WHERE (ext_payer_id = ci_payer_id)) mfrom
WHERE mto.ext_payer_id <> ci_payer_id
AND mto.payment_function = mfrom.payment_function
AND mto.party_id = ci_party_id
AND NVL(mto.cust_account_id,-99) = NVL(mfrom.cust_account_id,-99)
AND NVL(mto.acct_site_use_id,-99) = NVL(mfrom.acct_site_use_id,-99)
AND NVL(mto.org_type,'!') = NVL(mfrom.org_type,'!')
AND NVL(mto.org_id,-99) = NVL(mfrom.org_id,-99);
UPDATE iby_external_payers_all
SET party_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 ext_payer_id = p_from_id;
SELECT mto.instrument_payment_use_id
FROM iby_pmt_instr_uses_all mto,
(SELECT ext_pmt_party_id,payment_flow
FROM iby_pmt_instr_uses_all
WHERE instrument_payment_use_id = ci_use_id) mfrom
WHERE
mto.instrument_payment_use_id <> ci_use_id
AND mto.payment_flow = mfrom.payment_flow
AND mto.ext_pmt_party_id = mfrom.ext_pmt_party_id
AND mto.instrument_type = ci_instr_type
AND mto.instrument_id = ci_instr_id;
SELECT mto.instrument_payment_use_id
FROM iby_pmt_instr_uses_all mto,
(SELECT instrument_type,instrument_id
FROM iby_pmt_instr_uses_all
WHERE instrument_payment_use_id = ci_use_id) mfrom
WHERE
mto.instrument_payment_use_id <> ci_use_id
AND mto.payment_flow = ci_flow_type
AND mto.ext_pmt_party_id = ci_party_id
AND mto.instrument_type = mfrom.instrument_type
AND mto.instrument_id = mfrom.instrument_id;
UPDATE iby_pmt_instr_uses_all
SET instrument_id = DECODE(l_dup_id, NULL,p_to_fk_id, instrument_id),
end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
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 (instrument_payment_use_id = p_from_id);
UPDATE iby_pmt_instr_uses_all
SET ext_pmt_party_id = DECODE(l_dup_id, NULL,p_to_fk_id, ext_pmt_party_id),
end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
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 (instrument_payment_use_id = p_from_id);
SELECT ext_party_pmt_mthd_id
FROM iby_ext_party_pmt_mthds mto,
(SELECT payment_method_code
FROM iby_ext_party_pmt_mthds
WHERE (ext_party_pmt_mthd_id = ci_mth_id)) mfrom
WHERE
mto.ext_pmt_party_id = ci_party_id
AND mto.payment_flow = ci_flow_type
AND mto.payment_method_code = mfrom.payment_method_code;
UPDATE iby_ext_party_pmt_mthds
SET ext_pmt_party_id = DECODE(l_dup_id, NULL,p_to_fk_id, ext_pmt_party_id),
inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
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 (ext_party_pmt_mthd_id = p_from_id);
UPDATE iby_fndcpt_tx_extensions
SET ext_payer_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 (trxn_extension_id = p_from_id);
UPDATE iby_fndcpt_tx_extensions
SET instr_assignment_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 (trxn_extension_id = p_from_id);
UPDATE iby_trxn_summaries_all
SET payerid = 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 (trxnmid = p_from_id);
UPDATE iby_trxn_summaries_all
SET payer_instr_assignment_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 (trxnmid = p_from_id);
UPDATE iby_trxn_summaries_all
SET payerinstrid = 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 (trxnmid = p_from_id)
AND (instrtype = 'CREDITCARD');