490: UPDATE irc_all_recruiting_sites
491: SET posting_cost_currency = lv_new_currency
492: WHERE posting_cost_currency = lv_old_currency;
493:
494: /* IRC_SEARCH_CRITERIA */
495:
496: UPDATE irc_search_criteria
497: SET salary_currency = lv_new_currency
498: WHERE salary_currency = lv_old_currency;
492: WHERE posting_cost_currency = lv_old_currency;
493:
494: /* IRC_SEARCH_CRITERIA */
495:
496: UPDATE irc_search_criteria
497: SET salary_currency = lv_new_currency
498: WHERE salary_currency = lv_old_currency;
499:
500: /* OTA_ACTIVITY_VERSIONS */