DBA Data[Home] [Help]

APPS.PA_FP_MULTI_CURRENCY_PKG dependencies on PA_FP_ROLLUP_TMP

Line 2055: from pa_fp_rollup_tmp r

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 (+)

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

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)

Line 2532: UPDATE pa_fp_rollup_tmp

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)