DBA Data[Home] [Help]

APPS.PA_FP_GEN_BILLING_AMOUNTS dependencies on PA_FP_TXN_CURRENCIES

Line 231: pa_fp_txn_currencies tc

227: l_projfunc_rev_rate_type_tab(1),
228: l_projfunc_rev_rate_date_tab(1),
229: l_projfunc_rev_rate_tab(1)
230: FROM pa_proj_fp_options opt,
231: pa_fp_txn_currencies tc
232: WHERE opt.fin_plan_version_id = P_BUDGET_VERSION_ID
233: --AND opt.fin_plan_version_id = tc.fin_plan_version_id(+)
234: AND opt.proj_fp_options_id = tc.proj_fp_options_id(+) /* Added for Bug 5112436 */
235: AND tc.txn_currency_code(+) = p_currency_code;