eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_BUDGET_PVT dependencies on PA_FP_TXN_CURRENCIES

Line 5770: ( c_proj_fp_options_id pa_fp_txn_currencies.proj_fp_options_id%TYPE

5766:
5767:
5768: --This cursor is used to fetch the txn currencies of the plan type
5769: CURSOR l_plan_type_txn_curr_csr
5770: ( c_proj_fp_options_id pa_fp_txn_currencies.proj_fp_options_id%TYPE
5771: ,c_project_id pa_fp_txn_currencies.project_id%TYPE)
5772: IS
5773: SELECT txn_currency_code
5774: FROM pa_fp_txn_currencies ptxn

Line 5771: ,c_project_id pa_fp_txn_currencies.project_id%TYPE)

5767:
5768: --This cursor is used to fetch the txn currencies of the plan type
5769: CURSOR l_plan_type_txn_curr_csr
5770: ( c_proj_fp_options_id pa_fp_txn_currencies.proj_fp_options_id%TYPE
5771: ,c_project_id pa_fp_txn_currencies.project_id%TYPE)
5772: IS
5773: SELECT txn_currency_code
5774: FROM pa_fp_txn_currencies ptxn
5775: ,pa_projects_all p

Line 5774: FROM pa_fp_txn_currencies ptxn

5770: ( c_proj_fp_options_id pa_fp_txn_currencies.proj_fp_options_id%TYPE
5771: ,c_project_id pa_fp_txn_currencies.project_id%TYPE)
5772: IS
5773: SELECT txn_currency_code
5774: FROM pa_fp_txn_currencies ptxn
5775: ,pa_projects_all p
5776: WHERE p.project_id=c_project_id
5777: AND ptxn.project_id = p.project_id
5778: AND ptxn.txn_currency_code NOT IN (p.project_currency_code, p.projfunc_currency_code)

Line 5784: ( c_fin_plan_type_id pa_fp_txn_currencies.fin_plan_type_id%TYPE

5780:
5781:
5782: -- this cursor is used to fetch the txn currencies of the plan version for web adi context
5783: CURSOR l_plan_ver_txn_curr_csr
5784: ( c_fin_plan_type_id pa_fp_txn_currencies.fin_plan_type_id%TYPE
5785: ,c_project_id pa_fp_txn_currencies.project_id%TYPE
5786: ,c_fin_plan_version_id pa_fp_txn_currencies.fin_plan_version_id%TYPE)
5787: IS
5788: SELECT txn_currency_code

Line 5785: ,c_project_id pa_fp_txn_currencies.project_id%TYPE

5781:
5782: -- this cursor is used to fetch the txn currencies of the plan version for web adi context
5783: CURSOR l_plan_ver_txn_curr_csr
5784: ( c_fin_plan_type_id pa_fp_txn_currencies.fin_plan_type_id%TYPE
5785: ,c_project_id pa_fp_txn_currencies.project_id%TYPE
5786: ,c_fin_plan_version_id pa_fp_txn_currencies.fin_plan_version_id%TYPE)
5787: IS
5788: SELECT txn_currency_code
5789: FROM pa_fp_txn_currencies ptxn

Line 5786: ,c_fin_plan_version_id pa_fp_txn_currencies.fin_plan_version_id%TYPE)

5782: -- this cursor is used to fetch the txn currencies of the plan version for web adi context
5783: CURSOR l_plan_ver_txn_curr_csr
5784: ( c_fin_plan_type_id pa_fp_txn_currencies.fin_plan_type_id%TYPE
5785: ,c_project_id pa_fp_txn_currencies.project_id%TYPE
5786: ,c_fin_plan_version_id pa_fp_txn_currencies.fin_plan_version_id%TYPE)
5787: IS
5788: SELECT txn_currency_code
5789: FROM pa_fp_txn_currencies ptxn
5790: ,pa_projects_all p

Line 5789: FROM pa_fp_txn_currencies ptxn

5785: ,c_project_id pa_fp_txn_currencies.project_id%TYPE
5786: ,c_fin_plan_version_id pa_fp_txn_currencies.fin_plan_version_id%TYPE)
5787: IS
5788: SELECT txn_currency_code
5789: FROM pa_fp_txn_currencies ptxn
5790: ,pa_projects_all p
5791: WHERE p.project_id = c_project_id
5792: AND ptxn.project_id = p.project_id
5793: AND ptxn.fin_plan_type_id = c_fin_plan_type_id

Line 5897: l_txn_curr_code pa_fp_txn_currencies.txn_currency_code%TYPE;

5893: l_budget_amount_code pa_budget_types.budget_amount_code%TYPE;
5894: l_txn_tbl_index NUMBER;
5895: i NUMBER;
5896: l_valid_txn_curr BOOLEAN;
5897: l_txn_curr_code pa_fp_txn_currencies.txn_currency_code%TYPE;
5898: l_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
5899: l_conv_attrs_to_be_validated VARCHAR2(10);
5900: l_module_name VARCHAR2(80);
5901: l_top_task_id pa_tasks.top_task_id%TYPE;

Line 5903: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;

5899: l_conv_attrs_to_be_validated VARCHAR2(10);
5900: l_module_name VARCHAR2(80);
5901: l_top_task_id pa_tasks.top_task_id%TYPE;
5902: l_dummy VARCHAR2(1);
5903: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;
5904: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
5905: l_project_currency_code pa_projects_all.project_currency_code%TYPE ;
5906: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE ;
5907: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE ;