2051: ,r.init_revenue
2052: ,r.project_init_raw_cost
2053: ,r.project_init_burdened_cost
2054: ,r.project_init_revenue
2055: from pa_fp_rollup_tmp r
2056: --,pa_fp_txn_currencies c
2057: where nvl(r.delete_flag,'N') = 'N'
2058: /** Perf Bug: 3683132 and p_budget_version_id = c.fin_plan_version_id (+)
2059: and r.txn_currency_code = c.txn_currency_code (+)
2525:
2526: L_ROWCOUNT := l_projfunc_currency_code_tab.count;
2527:
2528: IF l_rowcount > 0 THEN
2529: --hr_utility.trace('Updating pa_fp_rollup_tmp...');
2530: l_stage := 1500;
2531: FORALL i in 1..l_rowcount
2532: UPDATE pa_fp_rollup_tmp
2533: SET projfunc_currency_code = l_projfunc_currency_code_tab(i)
2528: IF l_rowcount > 0 THEN
2529: --hr_utility.trace('Updating pa_fp_rollup_tmp...');
2530: l_stage := 1500;
2531: FORALL i in 1..l_rowcount
2532: UPDATE pa_fp_rollup_tmp
2533: SET projfunc_currency_code = l_projfunc_currency_code_tab(i)
2534: ,projfunc_cost_rate_type = l_projfunc_cost_rate_type_tab(i)
2535: ,projfunc_cost_exchange_rate = l_projfunc_cost_rate_tab(i)
2536: ,projfunc_cost_rate_date_type = l_projfunc_cost_rt_dt_typ_tab(i)