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_PROJ_ELEMENT_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 803: FROM pa_proj_elem_ver_schedule pevs, pa_proj_element_versions pev,

799: CURSOR C1_Task_Info(p_elem_version_id IN NUMBER) IS
800: SELECT pevs.scheduled_start_date, pevs.scheduled_finish_date,
801: pe.name task_name, pe.element_number task_number,
802: pe.proj_element_id
803: FROM pa_proj_elem_ver_schedule pevs, pa_proj_element_versions pev,
804: pa_proj_elements pe
805: WHERE pev.element_version_id = pevs.element_version_id
806: AND pev.element_version_id = p_elem_version_id
807: AND pev.proj_element_id = pe.proj_element_id;

Line 1323: FROM pa_proj_elem_ver_schedule pevs, pa_proj_element_versions pev,

1319:
1320: CURSOR C1_Task_Dates(p_elem_version_id IN NUMBER) IS
1321: SELECT pevs.scheduled_start_date, pevs.scheduled_finish_date,
1322: pe.name task_name, pe.element_number task_number
1323: FROM pa_proj_elem_ver_schedule pevs, pa_proj_element_versions pev,
1324: pa_proj_elements pe
1325: WHERE pev.element_version_id = pevs.element_version_id
1326: AND pev.element_version_id = p_elem_version_id
1327: AND pev.proj_element_id = pe.proj_element_id;

Line 1331: FROM pa_proj_elem_ver_structure pevs, pa_proj_element_versions pev

1327: AND pev.proj_element_id = pe.proj_element_id;
1328:
1329: CURSOR C2_Published_Flag(p_elem_version_id IN NUMBER) IS
1330: SELECT latest_eff_published_flag
1331: FROM pa_proj_elem_ver_structure pevs, pa_proj_element_versions pev
1332: WHERE pev.element_version_id = p_elem_version_id
1333: AND pev.parent_structure_version_id = pevs.element_version_id
1334: AND pev.project_id = pevs.project_id;
1335:

Line 1557: from pa_proj_element_versions

1553: l_project_id := -99;
1554:
1555: SELECT parent_structure_version_id, project_id, proj_element_id
1556: INTO l_struct_ver_id, l_project_id, l_proj_element_id
1557: from pa_proj_element_versions
1558: where element_version_id = l_wbs_element_version_id;
1559:
1560: EXCEPTION
1561: WHEN NO_DATA_FOUND THEN

Line 2311: FROM pa_proj_element_versions pev, pa_proj_elements pe

2307: L_FuncProc varchar2(250) ;
2308:
2309: CURSOR C_Element_Info(p_wbs_element_version_id IN NUMBER) IS
2310: SELECT pev.project_id, pev.parent_structure_version_id, pev.proj_element_id, pe.name, pe.element_number
2311: FROM pa_proj_element_versions pev, pa_proj_elements pe
2312: WHERE pev.element_version_id = p_wbs_element_version_id AND pe.proj_element_id = pev.proj_element_id;
2313:
2314: CURSOR C_Element_Info2(p_resource_assignment_id IN NUMBER) IS
2315: 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 2316: FROM pa_resource_assignments ra, pa_proj_element_versions pev

2312: WHERE pev.element_version_id = p_wbs_element_version_id AND pe.proj_element_id = pev.proj_element_id;
2313:
2314: CURSOR C_Element_Info2(p_resource_assignment_id IN NUMBER) IS
2315: 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
2316: FROM pa_resource_assignments ra, pa_proj_element_versions pev
2317: WHERE resource_assignment_id = p_resource_assignment_id
2318: and pev.element_version_id = ra.wbs_element_version_id;
2319:
2320: CURSOR C_Task_Asgmts(p_element_version_id IN NUMBER) IS

Line 2341: FROM pa_proj_element_versions

2337: AND total_plan_quantity > 0;
2338:
2339: CURSOR C_Task_Get_Project_Id(p_elem_version_id IN NUMBER) IS
2340: SELECT project_id
2341: FROM pa_proj_element_versions
2342: WHERE element_version_id = p_elem_version_id;
2343:
2344: CURSOR C_Asgmt_Get_Project_Id(p_resource_assignment_id IN NUMBER) IS
2345: SELECT project_id

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

2906: ra.non_labor_resource,
2907: ra.inventory_item_id
2908: FROM
2909: pa_copy_asgmts_temp temp,
2910: pa_proj_element_versions pev,
2911: pa_resource_assignments ra,
2912: pa_project_assignments asgn,
2913: pa_budget_lines bl,
2914: pa_resource_list_members rlm,

Line 3003: pa_proj_element_versions pev,

2999: ra.non_labor_resource,
3000: ra.inventory_item_id
3001: FROM
3002: pa_copy_asgmts_temp temp,
3003: pa_proj_element_versions pev,
3004: pa_resource_assignments ra,
3005: pa_project_assignments asgn,
3006: pa_resource_list_members rlm,
3007: pa_res_formats_b rf

Line 3066: pa_proj_element_versions pev,

3062: ra.non_labor_resource,
3063: ra.inventory_item_id
3064: FROM
3065: pa_copy_asgmts_temp temp,
3066: pa_proj_element_versions pev,
3067: pa_resource_assignments ra,
3068: pa_project_assignments asgn,
3069: pa_budget_lines bl,
3070: pa_resource_list_members source_rlm,

Line 3166: pa_proj_element_versions pev,

3162: ra.non_labor_resource,
3163: ra.inventory_item_id
3164: FROM
3165: pa_copy_asgmts_temp temp,
3166: pa_proj_element_versions pev,
3167: pa_resource_assignments ra,
3168: pa_project_assignments asgn,
3169: pa_resource_list_members source_rlm,
3170: pa_resource_list_members target_rlm,

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

3192: l_num_blocks NUMBER;
3193:
3194: CURSOR c_get_src_sched_dates IS
3195: SELECT pev.element_version_id, pevs.scheduled_start_date, pevs.scheduled_finish_date
3196: FROM pa_copy_asgmts_temp temp, pa_proj_element_versions pev, pa_proj_elem_ver_schedule pevs
3197: WHERE pev.element_version_id = pevs.element_version_id
3198: AND pev.element_version_id = temp.src_elem_ver_id;
3199:
3200: CURSOR c_get_targ_sched_dates IS

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

3198: AND pev.element_version_id = temp.src_elem_ver_id;
3199:
3200: CURSOR c_get_targ_sched_dates IS
3201: SELECT pev.element_version_id, pevs.scheduled_start_date, pevs.scheduled_finish_date
3202: FROM pa_copy_asgmts_temp temp, pa_proj_element_versions pev, pa_proj_elem_ver_schedule pevs
3203: WHERE pev.element_version_id = pevs.element_version_id
3204: AND pev.element_version_id = temp.targ_elem_ver_id;
3205:
3206: CURSOR get_rl_proj_specific_flag(c_resource_list_id NUMBER) IS

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

4985: WHERE resource_assignment_id = p_resource_assignment_id;
4986:
4987: CURSOR C_structure_Version_Id(p_element_version_id IN NUMBER) IS
4988: SELECT parent_structure_version_id, project_id
4989: from pa_proj_element_versions
4990: where element_version_id = p_element_version_id;
4991:
4992: -- Begin fix for Bug # 4373055.
4993: l_str_ver_id NUMBER:= null;

Line 5490: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,

5486: FUNCTION get_baselined_asgmt_dates(
5487:
5488: p_project_id IN pa_projects_all.project_id%TYPE,
5489:
5490: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
5491:
5492: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
5493:
5494: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,

Line 5673: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,

5669: FUNCTION get_baselined_asgmt_amounts(
5670:
5671: p_project_id IN pa_projects_all.project_id%TYPE,
5672:
5673: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
5674:
5675: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
5676:
5677: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,

Line 6028: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE

6024: FUNCTION get_task_level_record(
6025:
6026: p_project_id IN pa_projects_all.project_id%TYPE,
6027:
6028: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE
6029:
6030: ) RETURN NUMBER IS
6031:
6032:

Line 6324: FROM pa_proj_element_versions ppev,

6320: SELECT 'Y'
6321: FROM dual
6322: WHERE EXISTS
6323: (SELECT ppev.element_version_id
6324: FROM pa_proj_element_versions ppev,
6325: pa_proj_elem_ver_structure ppevs,
6326: pa_proj_structure_types ppst
6327: WHERE
6328: ppev.element_version_id = l_str_ver_id