DBA Data[Home] [Help]

APPS.PAY_MX_CURRENCY_CONVERSION dependencies on PER_WORK_INCIDENTS

Line 240: /* PER_WORK_INCIDENTS */

236: SET currency_code = lv_new_currency
237: WHERE business_group_id = ln_business_group_id
238: AND currency_code = lv_old_currency;
239:
240: /* PER_WORK_INCIDENTS */
241:
242: UPDATE per_work_incidents pwi
243: SET compensation_currency = lv_new_currency
244: WHERE compensation_currency = lv_old_currency

Line 242: UPDATE per_work_incidents pwi

238: AND currency_code = lv_old_currency;
239:
240: /* PER_WORK_INCIDENTS */
241:
242: UPDATE per_work_incidents pwi
243: SET compensation_currency = lv_new_currency
244: WHERE compensation_currency = lv_old_currency
245: AND EXISTS ( SELECT 1
246: FROM per_all_people_f ppf