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.

[Home] [Help]

APPS.PA_TASK_ASSIGNMENT_UTILS dependencies on PA_PROJ_ELEMENT_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 869: FROM pa_proj_elem_ver_schedule pevs, pa_proj_element_versions pev,

865: CURSOR C1_Task_Info(p_elem_version_id IN NUMBER) IS
866: SELECT pevs.scheduled_start_date, pevs.scheduled_finish_date,
867: pe.name task_name, pe.element_number task_number,
868: pe.proj_element_id
869: FROM pa_proj_elem_ver_schedule pevs, pa_proj_element_versions pev,
870: pa_proj_elements pe
871: WHERE pev.element_version_id = pevs.element_version_id
872: AND pev.element_version_id = p_elem_version_id
873: AND pev.proj_element_id = pe.proj_element_id;

Line 1431: FROM pa_proj_elem_ver_schedule pevs, pa_proj_element_versions pev,

1427:
1428: CURSOR C1_Task_Dates(p_elem_version_id IN NUMBER) IS
1429: SELECT pevs.scheduled_start_date, pevs.scheduled_finish_date,
1430: pe.name task_name, pe.element_number task_number
1431: FROM pa_proj_elem_ver_schedule pevs, pa_proj_element_versions pev,
1432: pa_proj_elements pe
1433: WHERE pev.element_version_id = pevs.element_version_id
1434: AND pev.element_version_id = p_elem_version_id
1435: AND pev.proj_element_id = pe.proj_element_id;

Line 1439: FROM pa_proj_elem_ver_structure pevs, pa_proj_element_versions pev

1435: AND pev.proj_element_id = pe.proj_element_id;
1436:
1437: CURSOR C2_Published_Flag(p_elem_version_id IN NUMBER) IS
1438: SELECT latest_eff_published_flag
1439: FROM pa_proj_elem_ver_structure pevs, pa_proj_element_versions pev
1440: WHERE pev.element_version_id = p_elem_version_id
1441: AND pev.parent_structure_version_id = pevs.element_version_id
1442: AND pev.project_id = pevs.project_id;
1443:

Line 1665: from pa_proj_element_versions

1661: l_project_id := -99;
1662:
1663: SELECT parent_structure_version_id, project_id, proj_element_id
1664: INTO l_struct_ver_id, l_project_id, l_proj_element_id
1665: from pa_proj_element_versions
1666: where element_version_id = l_wbs_element_version_id;
1667:
1668: EXCEPTION
1669: WHEN NO_DATA_FOUND THEN

Line 2411: FROM pa_proj_element_versions pev, pa_proj_elements pe

2407: L_FuncProc varchar2(250) ;
2408:
2409: CURSOR C_Element_Info(p_wbs_element_version_id IN NUMBER) IS
2410: SELECT pev.project_id, pev.parent_structure_version_id, pev.proj_element_id, pe.name, pe.element_number
2411: FROM pa_proj_element_versions pev, pa_proj_elements pe
2412: WHERE pev.element_version_id = p_wbs_element_version_id AND pe.proj_element_id = pev.proj_element_id;
2413:
2414: CURSOR C_Element_Info2(p_resource_assignment_id IN NUMBER) IS
2415: SELECT ra.wbs_element_version_id, ra.project_id, pev.proj_element_id, ra.resource_list_member_id, ra.ta_display_flag, ra.task_id, ra.unplanned_flag, ra.total_plan_quantity

Line 2416: FROM pa_resource_assignments ra, pa_proj_element_versions pev

2412: WHERE pev.element_version_id = p_wbs_element_version_id AND pe.proj_element_id = pev.proj_element_id;
2413:
2414: CURSOR C_Element_Info2(p_resource_assignment_id IN NUMBER) IS
2415: SELECT ra.wbs_element_version_id, ra.project_id, pev.proj_element_id, ra.resource_list_member_id, ra.ta_display_flag, ra.task_id, ra.unplanned_flag, ra.total_plan_quantity
2416: FROM pa_resource_assignments ra, pa_proj_element_versions pev
2417: WHERE resource_assignment_id = p_resource_assignment_id
2418: and pev.element_version_id = ra.wbs_element_version_id;
2419:
2420: CURSOR C_Task_Asgmts(p_element_version_id IN NUMBER) IS

Line 2441: FROM pa_proj_element_versions

2437: AND total_plan_quantity > 0;
2438:
2439: CURSOR C_Task_Get_Project_Id(p_elem_version_id IN NUMBER) IS
2440: SELECT project_id
2441: FROM pa_proj_element_versions
2442: WHERE element_version_id = p_elem_version_id;
2443:
2444: CURSOR C_Asgmt_Get_Project_Id(p_resource_assignment_id IN NUMBER) IS
2445: SELECT project_id

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 3025: pa_proj_element_versions pev,

3021: ra.non_labor_resource,
3022: ra.inventory_item_id
3023: FROM
3024: pa_copy_asgmts_temp temp,
3025: pa_proj_element_versions pev,
3026: pa_resource_assignments ra,
3027: pa_project_assignments asgn,
3028: pa_budget_lines bl,
3029: pa_resource_list_members rlm,

Line 3118: pa_proj_element_versions pev,

3114: ra.non_labor_resource,
3115: ra.inventory_item_id
3116: FROM
3117: pa_copy_asgmts_temp temp,
3118: pa_proj_element_versions pev,
3119: pa_resource_assignments ra,
3120: pa_project_assignments asgn,
3121: pa_resource_list_members rlm,
3122: pa_res_formats_b rf

Line 3181: pa_proj_element_versions pev,

3177: ra.non_labor_resource,
3178: ra.inventory_item_id
3179: FROM
3180: pa_copy_asgmts_temp temp,
3181: pa_proj_element_versions pev,
3182: pa_resource_assignments ra,
3183: pa_project_assignments asgn,
3184: pa_budget_lines bl,
3185: pa_resource_list_members source_rlm,

Line 3281: pa_proj_element_versions pev,

3277: ra.non_labor_resource,
3278: ra.inventory_item_id
3279: FROM
3280: pa_copy_asgmts_temp temp,
3281: pa_proj_element_versions pev,
3282: pa_resource_assignments ra,
3283: pa_project_assignments asgn,
3284: pa_resource_list_members source_rlm,
3285: pa_resource_list_members target_rlm,

Line 3311: FROM pa_copy_asgmts_temp temp, pa_proj_element_versions pev, pa_proj_elem_ver_schedule pevs

3307: l_num_blocks NUMBER;
3308:
3309: CURSOR c_get_src_sched_dates IS
3310: SELECT pev.element_version_id, pevs.scheduled_start_date, pevs.scheduled_finish_date
3311: FROM pa_copy_asgmts_temp temp, pa_proj_element_versions pev, pa_proj_elem_ver_schedule pevs
3312: WHERE pev.element_version_id = pevs.element_version_id
3313: AND pev.element_version_id = temp.src_elem_ver_id;
3314:
3315: CURSOR c_get_targ_sched_dates IS

Line 3317: FROM pa_copy_asgmts_temp temp, pa_proj_element_versions pev, pa_proj_elem_ver_schedule pevs

3313: AND pev.element_version_id = temp.src_elem_ver_id;
3314:
3315: CURSOR c_get_targ_sched_dates IS
3316: SELECT pev.element_version_id, pevs.scheduled_start_date, pevs.scheduled_finish_date
3317: FROM pa_copy_asgmts_temp temp, pa_proj_element_versions pev, pa_proj_elem_ver_schedule pevs
3318: WHERE pev.element_version_id = pevs.element_version_id
3319: AND pev.element_version_id = temp.targ_elem_ver_id;
3320:
3321: CURSOR get_rl_proj_specific_flag(c_resource_list_id NUMBER) IS

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 5105: from pa_proj_element_versions

5101: WHERE resource_assignment_id = p_resource_assignment_id;
5102:
5103: CURSOR C_structure_Version_Id(p_element_version_id IN NUMBER) IS
5104: SELECT parent_structure_version_id, project_id
5105: from pa_proj_element_versions
5106: where element_version_id = p_element_version_id;
5107:
5108: -- Begin fix for Bug # 4373055.
5109: l_str_ver_id NUMBER:= null;

Line 5606: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,

5602: FUNCTION get_baselined_asgmt_dates(
5603:
5604: p_project_id IN pa_projects_all.project_id%TYPE,
5605:
5606: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
5607:
5608: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
5609:
5610: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,

Line 5789: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,

5785: FUNCTION get_baselined_asgmt_amounts(
5786:
5787: p_project_id IN pa_projects_all.project_id%TYPE,
5788:
5789: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
5790:
5791: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
5792:
5793: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,

Line 6153: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE

6149: FUNCTION get_task_level_record(
6150:
6151: p_project_id IN pa_projects_all.project_id%TYPE,
6152:
6153: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE
6154:
6155: ) RETURN NUMBER IS
6156:
6157:

Line 6449: FROM pa_proj_element_versions ppev,

6445: SELECT 'Y'
6446: FROM dual
6447: WHERE EXISTS
6448: (SELECT ppev.element_version_id
6449: FROM pa_proj_element_versions ppev,
6450: pa_proj_elem_ver_structure ppevs,
6451: pa_proj_structure_types ppst
6452: WHERE
6453: ppev.element_version_id = l_str_ver_id