DBA Data[Home] [Help]

APPS.PER_RU_CURRENCY_CONVERSION dependencies on OTA_ACTIVITY_VERSIONS

Line 467: /* OTA_ACTIVITY_VERSIONS */

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

Line 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

Line 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: