APPS.IBY_PARTY_MERGE SQL Statements

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

Line: 28

      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;

Line: 65

     SELECT merge_reason_code
     INTO l_merge_reason
     FROM hz_merge_batch
     WHERE batch_id = p_batch_id;

Line: 94

     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);

Line: 143

      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);

Line: 183

     SELECT merge_reason_code
     INTO l_merge_reason
     FROM hz_merge_batch
     WHERE batch_id = p_batch_id;

Line: 218

       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);

Line: 235

       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);

Line: 284

      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);

Line: 341

         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;

Line: 392

      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;

Line: 409

      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;

Line: 460

       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);

Line: 491

       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);

Line: 545

       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;

Line: 593

       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);

Line: 669

       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);

Line: 678

       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);

Line: 748

       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);

Line: 757

       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);

Line: 766

       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');