463: UPDATE irc_search_criteria
464: SET salary_currency = lv_new_currency
465: WHERE salary_currency = lv_old_currency;
466:
467: /* OTA_ACTIVITY_VERSIONS */
468:
469: SELECT count(*)
470: INTO ln_ota_act_ver_count
471: FROM ota_activity_versions
467: /* OTA_ACTIVITY_VERSIONS */
468:
469: SELECT count(*)
470: INTO ln_ota_act_ver_count
471: FROM ota_activity_versions
472: WHERE budget_currency_code = lv_old_currency;
473: IF ln_ota_act_ver_count > 0
474: THEN
475: UPDATE ota_activity_versions
471: FROM ota_activity_versions
472: WHERE budget_currency_code = lv_old_currency;
473: IF ln_ota_act_ver_count > 0
474: THEN
475: UPDATE ota_activity_versions
476: SET budget_currency_code = lv_new_currency
477: WHERE budget_currency_code = lv_old_currency;
478: END IF;
479: