APPS.IRC_VENDORMERGE_GRP SQL Statements

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

Line: 35

  update irc_agency_vacancies
  set agency_id=p_vendor_id
  where agency_id=p_dup_vendor_id;

Line: 39

  update irc_notification_preferences
  set agency_id=p_vendor_id
  where agency_id=p_dup_vendor_id;

Line: 43

  update fnd_profile_option_values
  set profile_option_value=to_char(p_vendor_id)
  where profile_option_value=to_char(p_dup_vendor_id)
  and profile_option_id=(select profile_option_id
  from fnd_profile_options
  where profile_option_name='IRC_AGENCY_NAME');