APPS.PA_MULTI_CURRENCY_TXN dependencies on PA_EXPENDITURES

Line 1427: PA_Expenditures EXP,

1423: ** ITEM.Cost_Job_Id,
1424: ** PA_Cross_Business_Grp.GetProjectGroupId(TASK.Project_Id, 'C') job_group_id
1425: **/
1426: FROM PA_Expenditure_Items ITEM,
1427: PA_Expenditures EXP,
1428: PA_Transaction_Sources TXN /* Bug 1824407 */
1429: /** To be uncommented after decing upon rates-model.
1430: ** CBGA Join pa_tasks with pa_expenditure_items_all.
1431: ** PA_Tasks TASK

Line 1872: UPDATE pa_expenditures exp

1868: END IF;
1869: IF ( l_er_exp_count > 0 )
1870: THEN
1871: FORALL i IN 1..l_er_exp_count
1872: UPDATE pa_expenditures exp
1873: SET exp.Acct_Exchange_rate = l_exp_acct_exch_rate_tab(i)
1874: WHERE exp.expenditure_id = l_er_expenditure_id_tab(i)
1875: ;
1876: END IF; -- l_er_exp_count