DBA Data[Home] [Help]

APPS.PA_FP_MULTI_CURRENCY_PKG dependencies on PA_FP_TXN_CURRENCIES

Line 31: FROM pa_fp_txn_currencies c

27: SELECT c.projfunc_cost_exchange_rate
28: ,c.projfunc_rev_exchange_rate
29: ,c.project_cost_exchange_rate
30: ,c.project_rev_exchange_rate
31: FROM pa_fp_txn_currencies c
32: ,pa_proj_fp_options fp
33: WHERE fp.fin_plan_version_id = p_budget_version_id
34: AND fp.fin_plan_version_id = c.fin_plan_version_id
35: AND fp.proj_fp_options_id = c.proj_fp_options_id

Line 1970: --,pa_fp_txn_currencies c

1966: ,a.project_init_burdened_cost
1967: ,a.project_init_revenue
1968: from pa_budget_lines a
1969: ,pa_budget_versions bv
1970: --,pa_fp_txn_currencies c
1971: where a.budget_version_id = p_budget_version_id
1972: and bv.budget_version_id = a.budget_version_id
1973: and EXISTS (select null
1974: from pa_resource_assignments b

Line 2089: --,pa_fp_txn_currencies c

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 (+)
2093: **/