DBA Data[Home] [Help]

APPS.PA_FP_MULTI_CURRENCY_PKG dependencies on PA_FP_ROLLUP_TMP

Line 2088: from pa_fp_rollup_tmp r

2084: ,r.init_revenue
2085: ,r.project_init_raw_cost
2086: ,r.project_init_burdened_cost
2087: ,r.project_init_revenue
2088: from pa_fp_rollup_tmp r
2089: --,pa_fp_txn_currencies c
2090: where nvl(r.delete_flag,'N') = 'N'
2091: /** Perf Bug: 3683132 and p_budget_version_id = c.fin_plan_version_id (+)
2092: and r.txn_currency_code = c.txn_currency_code (+)

Line 2562: --hr_utility.trace('Updating pa_fp_rollup_tmp...');

2558:
2559: L_ROWCOUNT := l_projfunc_currency_code_tab.count;
2560:
2561: IF l_rowcount > 0 THEN
2562: --hr_utility.trace('Updating pa_fp_rollup_tmp...');
2563: l_stage := 1500;
2564: FORALL i in 1..l_rowcount
2565: UPDATE pa_fp_rollup_tmp
2566: SET projfunc_currency_code = l_projfunc_currency_code_tab(i)

Line 2565: UPDATE pa_fp_rollup_tmp

2561: IF l_rowcount > 0 THEN
2562: --hr_utility.trace('Updating pa_fp_rollup_tmp...');
2563: l_stage := 1500;
2564: FORALL i in 1..l_rowcount
2565: UPDATE pa_fp_rollup_tmp
2566: SET projfunc_currency_code = l_projfunc_currency_code_tab(i)
2567: ,projfunc_cost_rate_type = l_projfunc_cost_rate_type_tab(i)
2568: ,projfunc_cost_exchange_rate = l_projfunc_cost_rate_tab(i)
2569: ,projfunc_cost_rate_date_type = l_projfunc_cost_rt_dt_typ_tab(i)