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 1937: --,pa_fp_txn_currencies c

1933: ,a.project_init_burdened_cost
1934: ,a.project_init_revenue
1935: from pa_budget_lines a
1936: ,pa_budget_versions bv
1937: --,pa_fp_txn_currencies c
1938: where a.budget_version_id = p_budget_version_id
1939: and bv.budget_version_id = a.budget_version_id
1940: and EXISTS (select null
1941: from pa_resource_assignments b

Line 2056: --,pa_fp_txn_currencies c

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