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

Line 502: from pa_proj_element_versions pev, pa_budget_versions bv

498: l_num_blocks NUMBER;
499:
500: cursor get_bvid IS
501: SELECT bv.budget_version_id, pev.parent_structure_version_id
502: from pa_proj_element_versions pev, pa_budget_versions bv
503: where pev.element_version_id = p_element_version_id
504: and pev.parent_structure_version_id = bv.project_structure_version_id;
505:
506: L_FuncProc varchar2(250) ;

Line 1456: FROM pa_resource_assignments ra, pa_budget_versions bv

1452: WHERE resource_assignment_id = p_resource_assignment_id;
1453:
1454: CURSOR C2_Task_Effort_Assignment(p_resource_assignment_id IN NUMBER) IS
1455: SELECT ra.ta_display_flag, ra.resource_list_member_id, ra.project_id, ra.task_id, bv.project_structure_version_id
1456: FROM pa_resource_assignments ra, pa_budget_versions bv
1457: WHERE ra.resource_assignment_id = p_resource_assignment_id
1458: AND ra.budget_version_id = bv.budget_version_id;
1459:
1460: CURSOR C_Get_Actuals(p_resource_assignment_id IN NUMBER) IS

Line 2908: l_target_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;

2904: l_ta_tr_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2905: l_add_projfunc_cur_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
2906: l_ta_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2907: l_target_budget_version_id pa_resource_assignments.budget_version_id%TYPE;
2908: l_target_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
2909: l_target_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2910: l_source_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2911: l_source_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2912: l_target_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

Line 2954: from pa_proj_element_versions pev, pa_budget_versions bv, pa_proj_fp_options fpo

2950: l_tar_proj_cur_code VARCHAR2(15);
2951:
2952: CURSOR get_target_project_info (p_target_element_version_id IN NUMBER) IS
2953: select pev.parent_structure_version_id structure_version_id, bv.budget_version_id, fpo.track_workplan_costs_flag
2954: from pa_proj_element_versions pev, pa_budget_versions bv, pa_proj_fp_options fpo
2955: where bv.project_structure_version_id = pev.parent_structure_version_id
2956: and bv.project_id = fpo.project_id
2957: and bv.fin_plan_type_id = fpo.fin_plan_type_id
2958: and bv.budget_version_id = fpo.fin_plan_version_id

Line 3333: FROM pa_proj_element_versions pev, pa_budget_versions bv, pa_proj_fp_options pfo

3329:
3330: -- Bug 3974569.
3331: CURSOR c_get_bv_and_rbs_id(c_evid NUMBER) IS
3332: SELECT bv.budget_version_id, pfo.rbs_version_id
3333: FROM pa_proj_element_versions pev, pa_budget_versions bv, pa_proj_fp_options pfo
3334: WHERE pev.element_version_id = c_evid
3335: AND bv.project_structure_version_id = pev.parent_structure_version_id
3336: AND pfo.fin_plan_version_id = bv.budget_version_id;
3337:

Line 5620: l_current_version_id pa_budget_versions.budget_version_id%TYPE;

5616: p_code IN VARCHAR2) RETURN DATE IS
5617:
5618:
5619:
5620: l_current_version_id pa_budget_versions.budget_version_id%TYPE;
5621:
5622: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
5623:
5624: l_new_baselined_version_id pa_budget_versions.budget_version_id%TYPE; -- 4537865

Line 5622: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;

5618:
5619:
5620: l_current_version_id pa_budget_versions.budget_version_id%TYPE;
5621:
5622: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
5623:
5624: l_new_baselined_version_id pa_budget_versions.budget_version_id%TYPE; -- 4537865
5625:
5626: l_published_version_id pa_budget_versions.budget_version_id%TYPE;

Line 5624: l_new_baselined_version_id pa_budget_versions.budget_version_id%TYPE; -- 4537865

5620: l_current_version_id pa_budget_versions.budget_version_id%TYPE;
5621:
5622: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
5623:
5624: l_new_baselined_version_id pa_budget_versions.budget_version_id%TYPE; -- 4537865
5625:
5626: l_published_version_id pa_budget_versions.budget_version_id%TYPE;
5627:
5628: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;

Line 5626: l_published_version_id pa_budget_versions.budget_version_id%TYPE;

5622: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
5623:
5624: l_new_baselined_version_id pa_budget_versions.budget_version_id%TYPE; -- 4537865
5625:
5626: l_published_version_id pa_budget_versions.budget_version_id%TYPE;
5627:
5628: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
5629:
5630: l_planning_end_date pa_resource_assignments.planning_start_date%TYPE;

Line 5803: l_current_version_id pa_budget_versions.budget_version_id%TYPE;

5799: p_code IN VARCHAR2) RETURN NUMBER IS
5800:
5801:
5802:
5803: l_current_version_id pa_budget_versions.budget_version_id%TYPE;
5804:
5805: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
5806:
5807: l_new_baselined_version_id pa_budget_versions.budget_version_id%TYPE; -- 4537865

Line 5805: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;

5801:
5802:
5803: l_current_version_id pa_budget_versions.budget_version_id%TYPE;
5804:
5805: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
5806:
5807: l_new_baselined_version_id pa_budget_versions.budget_version_id%TYPE; -- 4537865
5808:
5809: l_published_version_id pa_budget_versions.budget_version_id%TYPE;

Line 5807: l_new_baselined_version_id pa_budget_versions.budget_version_id%TYPE; -- 4537865

5803: l_current_version_id pa_budget_versions.budget_version_id%TYPE;
5804:
5805: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
5806:
5807: l_new_baselined_version_id pa_budget_versions.budget_version_id%TYPE; -- 4537865
5808:
5809: l_published_version_id pa_budget_versions.budget_version_id%TYPE;
5810:
5811: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;

Line 5809: l_published_version_id pa_budget_versions.budget_version_id%TYPE;

5805: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
5806:
5807: l_new_baselined_version_id pa_budget_versions.budget_version_id%TYPE; -- 4537865
5808:
5809: l_published_version_id pa_budget_versions.budget_version_id%TYPE;
5810:
5811: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
5812:
5813: l_planning_end_date pa_resource_assignments.planning_start_date%TYPE;

Line 6439: FROM pa_budget_versions

6435:
6436:
6437: CURSOR C_validate_Budget_Version_Id (l_budget_version_id NUMBER , l_project_id NUMBER) IS
6438: SELECT budget_version_id, project_structure_version_id
6439: FROM pa_budget_versions
6440: WHERE budget_version_id = l_budget_version_id
6441: AND project_id = l_project_id
6442: AND project_structure_version_id is not null;
6443:

Line 6463: from pa_budget_versions

6459: and ppst.structure_type_id = 1);
6460:
6461: CURSOR C_Get_Budget_Version_Id(l_structure_version_id IN NUMBER) is
6462: select budget_version_id
6463: from pa_budget_versions
6464: where project_structure_version_id = l_structure_version_id
6465: and project_id = p_project_id;
6466:
6467: l_dummy varchar2(1);