DBA Data[Home] [Help]

APPS.PA_FP_MULTI_CURRENCY_PKG dependencies on PA_PROJ_FP_OPTIONS

Line 32: ,pa_proj_fp_options fp

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
36: AND c.txn_currency_code = p_txn_currency_code ;

Line 1836: from pa_proj_fp_options o

1832: ,o.project_cost_rate_date
1833: ,o.project_rev_rate_type
1834: ,o.project_rev_rate_date_type
1835: ,o.project_rev_rate_date
1836: from pa_proj_fp_options o
1837: ,pa_budget_versions v
1838: where v.budget_version_id = p_budget_version_id
1839: and o.project_id = v.project_id
1840: and nvl(o.fin_plan_type_id,0) = nvl(v.fin_plan_type_id,0)