APPS.OZF_PARTY_MERGE_PVT SQL Statements

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

Line: 14

select trade_profile_id
from   ozf_cust_trd_prfls_all
where  party_id = p_party_id
and    cust_account_id is null;

Line: 63

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 85

               UPDATE OZF_CUST_TRD_PRFLS_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,
                program_application_id = hz_utility_pub.program_application_id,
                program_id = hz_utility_pub.program_id,
                program_update_date = sysdate
               where party_id = p_from_fk_id;

Line: 96

               DELETE FROM OZF_CUST_TRD_PRFLS_ALL
               WHERE party_id = p_from_fk_id
               AND   cust_account_id is null;

Line: 142

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 160

            UPDATE OZF_CLAIMS_ALL
            SET broker_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 broker_id = p_from_fk_id;

Line: 211

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 229

            UPDATE OZF_CLAIMS_ALL
            SET 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: 281

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 299

            UPDATE OZF_CLAIMS_HISTORY_ALL
            SET broker_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 broker_id = p_from_fk_id;

Line: 351

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 369

            UPDATE OZF_CLAIMS_HISTORY_ALL
            SET 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: 420

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 438

            UPDATE OZF_ACT_BUDGETS
            SET budget_source_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 budget_source_id = p_from_fk_id
            and   budget_source_type = 'PTNR' ;

Line: 490

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 508

            UPDATE OZF_ACT_BUDGETS
            SET vendor_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 vendor_id = p_from_fk_id;

Line: 552

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 570

            UPDATE OZF_OFFERS
            SET BUYING_GROUP_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
            where BUYING_GROUP_CONTACT_ID = p_from_fk_id;

Line: 616

  SELECT object_id
  FROM   ozf_activity_customers
  WHERE  party_id = p_from_fk_id;

Line: 621

  SELECT 'Y'
  FROM   OZF_offer_parties
  WHERE  qp_list_header_id = l_list_header_id
  AND    party_id = l_party_id;

Line: 634

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 697

            DELETE FROM OZF_offer_parties
            WHERE qp_list_header_id = l_list_header_id.qp_list_header_id
            AND   party_id = p_from_fk_id;

Line: 701

            UPDATE ozf_activity_customers
            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  party_id = p_from_fk_id;

Line: 752

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 770

            UPDATE OZF_CLAIM_LINES_ALL
            SET buy_group_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where buy_group_party_id = p_from_fk_id;

Line: 821

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 839

            UPDATE OZF_CLAIM_LINES_HIST_ALL
            SET buy_group_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where buy_group_party_id = p_from_fk_id;

Line: 890

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 907

            UPDATE ozf_code_conversions_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 party_id = p_from_fk_id;

Line: 956

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 973

            UPDATE ozf_resale_batches_all
            SET partner_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where partner_party_id = p_from_fk_id;

Line: 1025

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 1042

            UPDATE ozf_resale_batches_all
            SET partner_contact_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where partner_contact_party_id = p_from_fk_id;

Line: 1094

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 1111

            UPDATE ozf_resale_lines_int_all
            SET ship_from_contact_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where ship_from_contact_party_id = p_from_fk_id;

Line: 1163

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 1180

            UPDATE ozf_resale_lines_int_all
            SET sold_from_contact_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where sold_from_contact_party_id = p_from_fk_id;

Line: 1233

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 1250

            UPDATE ozf_resale_lines_int_all
            SET bill_to_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where bill_to_party_id = p_from_fk_id;

Line: 1303

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 1320

            UPDATE ozf_resale_lines_int_all
            SET bill_to_contact_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where bill_to_contact_party_id = p_from_fk_id;

Line: 1372

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 1389

            UPDATE ozf_resale_lines_int_all
            SET ship_to_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where ship_to_party_id = p_from_fk_id;

Line: 1442

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 1459

            UPDATE ozf_resale_lines_int_all
            SET ship_to_contact_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where ship_to_contact_party_id = p_from_fk_id;

Line: 1511

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 1528

            UPDATE ozf_resale_lines_int_all
            SET end_cust_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where end_cust_party_id = p_from_fk_id;

Line: 1580

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 1597

            UPDATE ozf_resale_lines_int_all
            SET end_cust_contact_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where end_cust_contact_party_id = p_from_fk_id;

Line: 1649

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 1666

            UPDATE ozf_resale_headers_all
            SET bill_to_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where bill_to_party_id = p_from_fk_id;

Line: 1718

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 1735

            UPDATE ozf_resale_headers_all
            SET bill_to_contact_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where bill_to_contact_party_id = p_from_fk_id;

Line: 1787

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 1804

            UPDATE ozf_resale_headers_all
            SET ship_to_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where ship_to_party_id = p_from_fk_id;

Line: 1856

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 1873

            UPDATE ozf_resale_headers_all
            SET ship_to_contact_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where ship_to_contact_party_id = p_from_fk_id;

Line: 1925

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 1942

            UPDATE ozf_resale_lines_all
            SET ship_from_contact_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where ship_from_contact_party_id = p_from_fk_id;

Line: 1994

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 2011

            UPDATE ozf_resale_lines_all
            SET sold_from_contact_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where sold_from_contact_party_id = p_from_fk_id;

Line: 2063

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 2080

            UPDATE ozf_resale_lines_all
            SET bill_to_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where bill_to_party_id = p_from_fk_id;

Line: 2133

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 2150

            UPDATE ozf_resale_lines_all
            SET bill_to_contact_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where bill_to_contact_party_id = p_from_fk_id;

Line: 2203

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 2220

            UPDATE ozf_resale_lines_all
            SET ship_to_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where ship_to_party_id = p_from_fk_id;

Line: 2273

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 2290

            UPDATE ozf_resale_lines_all
            SET ship_to_contact_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where ship_to_contact_party_id  = p_from_fk_id;

Line: 2342

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 2359

            UPDATE ozf_resale_lines_all
            SET end_cust_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where end_cust_party_id = p_from_fk_id;

Line: 2410

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 2427

            UPDATE ozf_resale_lines_all
            SET end_cust_contact_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where end_cust_contact_party_id = p_from_fk_id;

Line: 2479

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 2496

            UPDATE ozf_request_headers_all_b
            SET end_cust_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where end_cust_party_id  = p_from_fk_id;

Line: 2548

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 2565

            UPDATE ozf_request_headers_all_b
            SET reseller_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,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where reseller_party_id  = p_from_fk_id;

Line: 2617

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 2634

            UPDATE ozf_account_allocations
            SET parent_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 parent_party_id  = p_from_fk_id;

Line: 2683

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 2700

            UPDATE ozf_account_allocations
            SET rollup_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 rollup_party_id  = p_from_fk_id;

Line: 2750

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 2768

            UPDATE OZF_OFFERS
            SET autopay_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 autopay_party_id = p_from_fk_id;

Line: 2817

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 2834

            UPDATE ozf_request_headers_all_b
            SET partner_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 partner_id  = p_from_fk_id;