496: UPDATE irc_search_criteria
497: SET salary_currency = lv_new_currency
498: WHERE salary_currency = lv_old_currency;
499:
500: /* OTA_ACTIVITY_VERSIONS */
501:
502: SELECT count(*)
503: INTO ln_ota_act_ver_count
504: FROM ota_activity_versions
500: /* OTA_ACTIVITY_VERSIONS */
501:
502: SELECT count(*)
503: INTO ln_ota_act_ver_count
504: FROM ota_activity_versions
505: WHERE budget_currency_code = lv_old_currency;
506: IF ln_ota_act_ver_count > 0
507: THEN
508: UPDATE ota_activity_versions
504: FROM ota_activity_versions
505: WHERE budget_currency_code = lv_old_currency;
506: IF ln_ota_act_ver_count > 0
507: THEN
508: UPDATE ota_activity_versions
509: SET budget_currency_code = lv_new_currency
510: WHERE budget_currency_code = lv_old_currency;
511: END IF;
512: