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 2035: FROM pa_budget_versions bv

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

Line 2048: l_version_name pa_budget_versions.version_name%type;

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

Line 2049: l_version_type pa_budget_versions.version_type%type;

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

Line 2757: ,pa_budget_versions bv

2753: ,bv.project_structure_version_id
2754: ,bv.project_id
2755: ,pp.segment1 project_name
2756: FROM pa_proj_fp_options pfo
2757: ,pa_budget_versions bv
2758: ,pa_projects_all pp
2759: WHERE pfo.fin_plan_version_id = bv.budget_version_id
2760: AND bv.budget_version_id = p_budget_version_id
2761: AND pp.project_id = bv.project_id