DBA Data[Home] [Help]

APPS.PA_MULTI_CURRENCY_TXN dependencies on PA_EXPENDITURES

Line 1434: PA_Expenditures EXP,

1430: ** ITEM.Cost_Job_Id,
1431: ** PA_Cross_Business_Grp.GetProjectGroupId(TASK.Project_Id, 'C') job_group_id
1432: **/
1433: FROM PA_Expenditure_Items ITEM,
1434: PA_Expenditures EXP,
1435: PA_Transaction_Sources TXN /* Bug 1824407 */
1436: /** To be uncommented after decing upon rates-model.
1437: ** CBGA Join pa_tasks with pa_expenditure_items_all.
1438: ** PA_Tasks TASK

Line 1879: UPDATE pa_expenditures exp

1875: END IF;
1876: IF ( l_er_exp_count > 0 )
1877: THEN
1878: FORALL i IN 1..l_er_exp_count
1879: UPDATE pa_expenditures exp
1880: SET exp.Acct_Exchange_rate = l_exp_acct_exch_rate_tab(i)
1881: WHERE exp.expenditure_id = l_er_expenditure_id_tab(i)
1882: ;
1883: END IF; -- l_er_exp_count