457: UPDATE irc_all_recruiting_sites
458: SET posting_cost_currency = lv_new_currency
459: WHERE posting_cost_currency = lv_old_currency;
460:
461: /* IRC_SEARCH_CRITERIA */
462:
463: UPDATE irc_search_criteria
464: SET salary_currency = lv_new_currency
465: WHERE salary_currency = lv_old_currency;
459: WHERE posting_cost_currency = lv_old_currency;
460:
461: /* IRC_SEARCH_CRITERIA */
462:
463: UPDATE irc_search_criteria
464: SET salary_currency = lv_new_currency
465: WHERE salary_currency = lv_old_currency;
466:
467: /* OTA_ACTIVITY_VERSIONS */