APPS.ECX_VENDORMERGE_GRP SQL Statements

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

Line: 32

    UPDATE ECX_TP_HEADERS
    set party_id = p_party_id,
        party_site_id = p_party_site_id,
        last_updated_by = hz_utility_pub.user_id,
        last_update_login = hz_utility_pub.last_update_login
    where party_id = p_dup_party_id
      and party_site_id = p_dup_party_site_id;

Line: 42

    UPDATE ECX_DOCLOGS
    set partyid = to_char(p_party_id),
        party_site_id = to_char(p_party_site_id)
    where partyid = to_char(p_dup_party_id)
      and party_site_id = to_char(p_dup_party_site_id);

Line: 50

    UPDATE ECX_OUTBOUND_LOGS
    set party_id = to_char(p_party_id),
        party_site_id = to_char(p_party_site_id)
    where party_id = to_char(p_dup_party_id)
      and party_site_id = to_char(p_dup_party_site_id);

Line: 59

    UPDATE ECX_OUTTRIG_LOGS
    set party_id = to_char(p_party_id),
        party_site_id = to_char(p_party_site_id)
    where party_id = to_char(p_dup_party_id)
      and party_site_id = to_char(p_dup_party_site_id);*/