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 5753: ( c_proj_fp_options_id pa_fp_txn_currencies.proj_fp_options_id%TYPE

5749:
5750:
5751: --This cursor is used to fetch the txn currencies of the plan type
5752: CURSOR l_plan_type_txn_curr_csr
5753: ( c_proj_fp_options_id pa_fp_txn_currencies.proj_fp_options_id%TYPE
5754: ,c_project_id pa_fp_txn_currencies.project_id%TYPE)
5755: IS
5756: SELECT txn_currency_code
5757: FROM pa_fp_txn_currencies ptxn

Line 5754: ,c_project_id pa_fp_txn_currencies.project_id%TYPE)

5750:
5751: --This cursor is used to fetch the txn currencies of the plan type
5752: CURSOR l_plan_type_txn_curr_csr
5753: ( c_proj_fp_options_id pa_fp_txn_currencies.proj_fp_options_id%TYPE
5754: ,c_project_id pa_fp_txn_currencies.project_id%TYPE)
5755: IS
5756: SELECT txn_currency_code
5757: FROM pa_fp_txn_currencies ptxn
5758: ,pa_projects_all p

Line 5757: FROM pa_fp_txn_currencies ptxn

5753: ( c_proj_fp_options_id pa_fp_txn_currencies.proj_fp_options_id%TYPE
5754: ,c_project_id pa_fp_txn_currencies.project_id%TYPE)
5755: IS
5756: SELECT txn_currency_code
5757: FROM pa_fp_txn_currencies ptxn
5758: ,pa_projects_all p
5759: WHERE p.project_id=c_project_id
5760: AND ptxn.project_id = p.project_id
5761: AND ptxn.txn_currency_code NOT IN (p.project_currency_code, p.projfunc_currency_code)

Line 5767: ( c_fin_plan_type_id pa_fp_txn_currencies.fin_plan_type_id%TYPE

5763:
5764:
5765: -- this cursor is used to fetch the txn currencies of the plan version for web adi context
5766: CURSOR l_plan_ver_txn_curr_csr
5767: ( c_fin_plan_type_id pa_fp_txn_currencies.fin_plan_type_id%TYPE
5768: ,c_project_id pa_fp_txn_currencies.project_id%TYPE
5769: ,c_fin_plan_version_id pa_fp_txn_currencies.fin_plan_version_id%TYPE)
5770: IS
5771: SELECT txn_currency_code

Line 5768: ,c_project_id pa_fp_txn_currencies.project_id%TYPE

5764:
5765: -- this cursor is used to fetch the txn currencies of the plan version for web adi context
5766: CURSOR l_plan_ver_txn_curr_csr
5767: ( c_fin_plan_type_id pa_fp_txn_currencies.fin_plan_type_id%TYPE
5768: ,c_project_id pa_fp_txn_currencies.project_id%TYPE
5769: ,c_fin_plan_version_id pa_fp_txn_currencies.fin_plan_version_id%TYPE)
5770: IS
5771: SELECT txn_currency_code
5772: FROM pa_fp_txn_currencies ptxn

Line 5769: ,c_fin_plan_version_id pa_fp_txn_currencies.fin_plan_version_id%TYPE)

5765: -- this cursor is used to fetch the txn currencies of the plan version for web adi context
5766: CURSOR l_plan_ver_txn_curr_csr
5767: ( c_fin_plan_type_id pa_fp_txn_currencies.fin_plan_type_id%TYPE
5768: ,c_project_id pa_fp_txn_currencies.project_id%TYPE
5769: ,c_fin_plan_version_id pa_fp_txn_currencies.fin_plan_version_id%TYPE)
5770: IS
5771: SELECT txn_currency_code
5772: FROM pa_fp_txn_currencies ptxn
5773: ,pa_projects_all p

Line 5772: FROM pa_fp_txn_currencies ptxn

5768: ,c_project_id pa_fp_txn_currencies.project_id%TYPE
5769: ,c_fin_plan_version_id pa_fp_txn_currencies.fin_plan_version_id%TYPE)
5770: IS
5771: SELECT txn_currency_code
5772: FROM pa_fp_txn_currencies ptxn
5773: ,pa_projects_all p
5774: WHERE p.project_id = c_project_id
5775: AND ptxn.project_id = p.project_id
5776: AND ptxn.fin_plan_type_id = c_fin_plan_type_id

Line 5880: l_txn_curr_code pa_fp_txn_currencies.txn_currency_code%TYPE;

5876: l_budget_amount_code pa_budget_types.budget_amount_code%TYPE;
5877: l_txn_tbl_index NUMBER;
5878: i NUMBER;
5879: l_valid_txn_curr BOOLEAN;
5880: l_txn_curr_code pa_fp_txn_currencies.txn_currency_code%TYPE;
5881: l_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
5882: l_conv_attrs_to_be_validated VARCHAR2(10);
5883: l_module_name VARCHAR2(80);
5884: l_top_task_id pa_tasks.top_task_id%TYPE;

Line 5886: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;

5882: l_conv_attrs_to_be_validated VARCHAR2(10);
5883: l_module_name VARCHAR2(80);
5884: l_top_task_id pa_tasks.top_task_id%TYPE;
5885: l_dummy VARCHAR2(1);
5886: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;
5887: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
5888: l_project_currency_code pa_projects_all.project_currency_code%TYPE ;
5889: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE ;
5890: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE ;