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_FIN_PLAN_UTILS2 dependencies on PA_BUDGET_VERSIONS

Line 561: from pa_budget_versions bv

557: UNION
558: select bv.project_id
559: ,2 default_level
560: ,bv.resource_list_id
561: from pa_budget_versions bv
562: ,pa_budget_types bt
563: where bv.fin_plan_type_id is Null
564: and bv.budget_type_code = bt.budget_type_code
565: and bt.budget_amount_code = 'C'

Line 1045: From pa_budget_versions bv

1041: Cursor projDetails IS
1042: Select bv.project_id
1043: ,bv.etc_start_date
1044: ,bv.version_type
1045: From pa_budget_versions bv
1046: Where bv.budget_version_id = p_bdgt_version_id;
1047:
1048: l_stage varchar2(1000);
1049: l_call_calculate_api Varchar2(1) := 'N';

Line 1930: from pa_budget_versions bv

1926: ) IS
1927:
1928: cursor cur_etc IS
1929: select bv.etc_start_date
1930: from pa_budget_versions bv
1931: where bv.budget_version_id = p_budget_version_id
1932: and Exists ( select null
1933: from pa_budget_lines bl
1934: where bl.resource_assignment_id = p_resource_assignment_id

Line 2036: FROM pa_budget_versions bv

2032: ,bv.ci_id
2033: ,bv.version_type
2034: ,bv.version_name
2035: ,bv.approved_rev_plan_type_flag -- Bug 5845142
2036: FROM pa_budget_versions bv
2037: WHERE bv.budget_version_id = p_budget_version_id;
2038:
2039: CURSOR cur_agr(p_agr_id Number) IS
2040: SELECT agr.agreement_currency_code

Line 2049: l_version_name pa_budget_versions.version_name%type;

2045: l_agreement_id Number;
2046: l_ci_id Number;
2047: l_agr_curr_code Varchar2(100);
2048: l_agr_con_reqd_flag varchar2(1) := 'N';
2049: l_version_name pa_budget_versions.version_name%type;
2050: l_version_type pa_budget_versions.version_type%type;
2051: l_error_msg_code Varchar2(100);
2052: INVALID_EXCEPTION EXCEPTION;
2053: l_debug_flag varchar2(100);

Line 2050: l_version_type pa_budget_versions.version_type%type;

2046: l_ci_id Number;
2047: l_agr_curr_code Varchar2(100);
2048: l_agr_con_reqd_flag varchar2(1) := 'N';
2049: l_version_name pa_budget_versions.version_name%type;
2050: l_version_type pa_budget_versions.version_type%type;
2051: l_error_msg_code Varchar2(100);
2052: INVALID_EXCEPTION EXCEPTION;
2053: l_debug_flag varchar2(100);
2054: l_proc_name varchar2(100) := 'Get_Agreement_Details';

Line 2059: l_approved_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

2055: G_AGR_CONV_REQD_FLAG varchar2(1) := 'N';
2056: G_AGR_CURRENCY_CODE varchar2(100);
2057:
2058: --Bug 5845142
2059: l_approved_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
2060:
2061: BEGIN
2062: IF p_pa_debug_mode = 'Y' THEN
2063: pa_debug.init_err_stack('PA_FIN_PLAN_UTILS2.Get_Agreement_Details');

Line 2764: ,pa_budget_versions bv

2760: ,bv.project_structure_version_id
2761: ,bv.project_id
2762: ,pp.segment1 project_name
2763: FROM pa_proj_fp_options pfo
2764: ,pa_budget_versions bv
2765: ,pa_projects_all pp
2766: WHERE pfo.fin_plan_version_id = bv.budget_version_id
2767: AND bv.budget_version_id = p_budget_version_id
2768: AND pp.project_id = bv.project_id