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 437: from pa_proj_element_versions pev, pa_budget_versions bv

433: l_num_blocks NUMBER;
434:
435: cursor get_bvid IS
436: SELECT bv.budget_version_id, pev.parent_structure_version_id
437: from pa_proj_element_versions pev, pa_budget_versions bv
438: where pev.element_version_id = p_element_version_id
439: and pev.parent_structure_version_id = bv.project_structure_version_id;
440:
441: L_FuncProc varchar2(250) ;

Line 1348: FROM pa_resource_assignments ra, pa_budget_versions bv

1344: WHERE resource_assignment_id = p_resource_assignment_id;
1345:
1346: CURSOR C2_Task_Effort_Assignment(p_resource_assignment_id IN NUMBER) IS
1347: SELECT ra.ta_display_flag, ra.resource_list_member_id, ra.project_id, ra.task_id, bv.project_structure_version_id
1348: FROM pa_resource_assignments ra, pa_budget_versions bv
1349: WHERE ra.resource_assignment_id = p_resource_assignment_id
1350: AND ra.budget_version_id = bv.budget_version_id;
1351:
1352: CURSOR C_Get_Actuals(p_resource_assignment_id IN NUMBER) IS

Line 2793: l_target_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;

2789: l_ta_tr_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2790: l_add_projfunc_cur_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
2791: l_ta_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2792: l_target_budget_version_id pa_resource_assignments.budget_version_id%TYPE;
2793: l_target_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
2794: l_target_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2795: l_source_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2796: l_source_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2797: l_target_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

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

2835: l_tar_proj_cur_code VARCHAR2(15);
2836:
2837: CURSOR get_target_project_info (p_target_element_version_id IN NUMBER) IS
2838: select pev.parent_structure_version_id structure_version_id, bv.budget_version_id, fpo.track_workplan_costs_flag
2839: from pa_proj_element_versions pev, pa_budget_versions bv, pa_proj_fp_options fpo
2840: where bv.project_structure_version_id = pev.parent_structure_version_id
2841: and bv.project_id = fpo.project_id
2842: and bv.fin_plan_type_id = fpo.fin_plan_type_id
2843: and bv.budget_version_id = fpo.fin_plan_version_id

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

3214:
3215: -- Bug 3974569.
3216: CURSOR c_get_bv_and_rbs_id(c_evid NUMBER) IS
3217: SELECT bv.budget_version_id, pfo.rbs_version_id
3218: FROM pa_proj_element_versions pev, pa_budget_versions bv, pa_proj_fp_options pfo
3219: WHERE pev.element_version_id = c_evid
3220: AND bv.project_structure_version_id = pev.parent_structure_version_id
3221: AND pfo.fin_plan_version_id = bv.budget_version_id;
3222:

Line 5504: l_current_version_id pa_budget_versions.budget_version_id%TYPE;

5500: p_code IN VARCHAR2) RETURN DATE IS
5501:
5502:
5503:
5504: l_current_version_id pa_budget_versions.budget_version_id%TYPE;
5505:
5506: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
5507:
5508: l_new_baselined_version_id pa_budget_versions.budget_version_id%TYPE; -- 4537865

Line 5506: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;

5502:
5503:
5504: l_current_version_id pa_budget_versions.budget_version_id%TYPE;
5505:
5506: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
5507:
5508: l_new_baselined_version_id pa_budget_versions.budget_version_id%TYPE; -- 4537865
5509:
5510: l_published_version_id pa_budget_versions.budget_version_id%TYPE;

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

5504: l_current_version_id pa_budget_versions.budget_version_id%TYPE;
5505:
5506: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
5507:
5508: l_new_baselined_version_id pa_budget_versions.budget_version_id%TYPE; -- 4537865
5509:
5510: l_published_version_id pa_budget_versions.budget_version_id%TYPE;
5511:
5512: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;

Line 5510: l_published_version_id pa_budget_versions.budget_version_id%TYPE;

5506: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
5507:
5508: l_new_baselined_version_id pa_budget_versions.budget_version_id%TYPE; -- 4537865
5509:
5510: l_published_version_id pa_budget_versions.budget_version_id%TYPE;
5511:
5512: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
5513:
5514: l_planning_end_date pa_resource_assignments.planning_start_date%TYPE;

Line 5687: l_current_version_id pa_budget_versions.budget_version_id%TYPE;

5683: p_code IN VARCHAR2) RETURN NUMBER IS
5684:
5685:
5686:
5687: l_current_version_id pa_budget_versions.budget_version_id%TYPE;
5688:
5689: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
5690:
5691: l_new_baselined_version_id pa_budget_versions.budget_version_id%TYPE; -- 4537865

Line 5689: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;

5685:
5686:
5687: l_current_version_id pa_budget_versions.budget_version_id%TYPE;
5688:
5689: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
5690:
5691: l_new_baselined_version_id pa_budget_versions.budget_version_id%TYPE; -- 4537865
5692:
5693: l_published_version_id pa_budget_versions.budget_version_id%TYPE;

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

5687: l_current_version_id pa_budget_versions.budget_version_id%TYPE;
5688:
5689: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
5690:
5691: l_new_baselined_version_id pa_budget_versions.budget_version_id%TYPE; -- 4537865
5692:
5693: l_published_version_id pa_budget_versions.budget_version_id%TYPE;
5694:
5695: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;

Line 5693: l_published_version_id pa_budget_versions.budget_version_id%TYPE;

5689: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
5690:
5691: l_new_baselined_version_id pa_budget_versions.budget_version_id%TYPE; -- 4537865
5692:
5693: l_published_version_id pa_budget_versions.budget_version_id%TYPE;
5694:
5695: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
5696:
5697: l_planning_end_date pa_resource_assignments.planning_start_date%TYPE;

Line 6314: FROM pa_budget_versions

6310:
6311:
6312: CURSOR C_validate_Budget_Version_Id (l_budget_version_id NUMBER , l_project_id NUMBER) IS
6313: SELECT budget_version_id, project_structure_version_id
6314: FROM pa_budget_versions
6315: WHERE budget_version_id = l_budget_version_id
6316: AND project_id = l_project_id
6317: AND project_structure_version_id is not null;
6318:

Line 6338: from pa_budget_versions

6334: and ppst.structure_type_id = 1);
6335:
6336: CURSOR C_Get_Budget_Version_Id(l_structure_version_id IN NUMBER) is
6337: select budget_version_id
6338: from pa_budget_versions
6339: where project_structure_version_id = l_structure_version_id
6340: and project_id = p_project_id;
6341:
6342: l_dummy varchar2(1);