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_PROGRESS_UTILS dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 53: from pa_proj_element_versions ppev1,

49: x_task_version_id NUMBER;
50: BEGIN
51: select ppev1.element_version_id
52: into x_task_version_id
53: from pa_proj_element_versions ppev1,
54: pa_proj_element_versions ppev2,
55: pa_proj_elem_ver_structure ppevs,
56: pa_structure_types pst,
57: pa_proj_structure_types ppst

Line 54: pa_proj_element_versions ppev2,

50: BEGIN
51: select ppev1.element_version_id
52: into x_task_version_id
53: from pa_proj_element_versions ppev1,
54: pa_proj_element_versions ppev2,
55: pa_proj_elem_ver_structure ppevs,
56: pa_structure_types pst,
57: pa_proj_structure_types ppst
58: where ppevs.project_id = p_project_id

Line 99: pa_proj_element_versions ppev,

95: BEGIN
96: select ppevs.element_version_id
97: into x_structure_version_id
98: from pa_proj_elem_ver_structure ppevs,
99: pa_proj_element_versions ppev,
100: pa_structure_types pst,
101: pa_proj_structure_types ppst
102: where ppevs.project_id = p_project_id
103: and ppevs.latest_eff_published_flag = 'Y'

Line 920: pa_proj_element_versions ppev,

916: CURSOR cur_pa_task_prg1
917: IS
918: SELECT WQ_PLANNED_QUANTITY
919: FROM pa_proj_elements ppe,
920: pa_proj_element_versions ppev,
921: pa_proj_elem_ver_schedule ppevsh
922: WHERE ppe.project_id = ppev.project_id
923: AND ppe.proj_element_id = p_task_id
924: AND ppev.proj_element_id = ppe.proj_element_id

Line 1779: FROM pa_proj_element_versions

1775: THEN
1776: UPDATE pa_proj_elements
1777: SET progress_outdated_flag = 'N'
1778: WHERE proj_element_id in ( SELECT proj_element_id
1779: FROM pa_proj_element_versions
1780: WHERE project_id = p_project_id
1781: AND parent_structure_version_id = p_structure_version_id
1782: AND object_type in ( 'PA_STRUCTURES', 'PA_TASKS' ) )
1783: AND object_type in ( 'PA_STRUCTURES', 'PA_TASKS' )

Line 2235: pa_proj_element_versions ppev,

2231: CURSOR cur_pa_proj
2232: IS
2233: SELECT ppe.status_code
2234: FROM pa_object_relationships por,
2235: pa_proj_element_versions ppev,
2236: pa_proj_elements ppe,
2237: pa_project_statuses pps
2238: WHERE object_id_to1 = p_object_version_id
2239: AND ppev.element_version_id = por.object_id_from1

Line 2533: pa_proj_element_versions PPEV

2529: CURSOR l_get_task_manager(c_element_version_id NUMBER)
2530: IS
2531: SELECT ppe.manager_person_id
2532: FROM pa_proj_elements PPE,
2533: pa_proj_element_versions PPEV
2534: WHERE ppev.element_version_id = c_element_version_id
2535: AND ppev.proj_element_id = ppe.proj_element_id;
2536:
2537: CURSOR l_get_parent_task(c_element_version_id NUMBER)

Line 2549: FROM pa_proj_element_versions ppev

2545:
2546: CURSOR l_get_element_version_id(c_proj_element_id NUMBER, c_parent_structure_version_id NUMBER)
2547: IS
2548: SELECT ppev.element_version_id
2549: FROM pa_proj_element_versions ppev
2550: WHERE ppev.proj_element_id = c_proj_element_id
2551: AND ppev.parent_structure_version_id = c_parent_structure_version_id;
2552:
2553: CURSOR l_get_latest_pub_structure_ver

Line 6215: from pa_proj_element_versions

6211:
6212: CURSOR cur_str_ver_id
6213: is
6214: select parent_structure_version_id
6215: from pa_proj_element_versions
6216: where project_id = p_project_id
6217: and proj_element_id = p_proj_element_id
6218: and element_version_id = p_task_version_id
6219: ;

Line 6581: from pa_proj_element_versions ppev

6577: from pa_proj_elem_ver_schedule ppevs
6578: where ppevs.project_id = p_project_id
6579: and ppevs.proj_element_id = p_proj_element_id
6580: and ppevs.element_version_id = (select ppev.element_version_id
6581: from pa_proj_element_versions ppev
6582: where ppev.project_id = p_project_id
6583: and ppev.proj_element_id = p_proj_element_id
6584: and ppev.parent_structure_version_id = p_structure_version_id);
6585: l_start_date DATE;

Line 7152: from pa_proj_element_versions

7148: and proj_element_id = p_proj_element_id;
7149:
7150: cursor c2(p_element_version_id NUMBER) is
7151: select proj_element_id
7152: from pa_proj_element_versions
7153: where element_version_id = p_element_version_id;
7154:
7155: cursor c3(p_project_id NUMBER, p_element_version_id NUMBER) is
7156: select wq_planned_quantity

Line 7187: from pa_proj_element_versions ppev

7183: /* Begin code to fix Bug # 4172372. */
7184:
7185: cursor cur_task_version(c_project_id NUMBER, c_wp_task_id NUMBER, c_wp_str_ver_id NUMBER) is
7186: select ppev.element_version_id
7187: from pa_proj_element_versions ppev
7188: where ppev.project_id = c_project_id
7189: and ppev.proj_element_id = c_wp_task_id
7190: and ppev.parent_structure_version_id = c_wp_str_ver_id;
7191:

Line 7367: from pa_proj_element_versions

7363: l_structure_sharing_code VARCHAR2(30) := NULL;
7364:
7365: cursor c1(p_proj_element_id NUMBER, p_structure_version_id NUMBER) is
7366: select element_version_id
7367: from pa_proj_element_versions
7368: where project_id = p_project_id
7369: and proj_element_id = p_proj_element_id
7370: and parent_structure_version_id = p_structure_version_id;
7371:

Line 9978: from pa_proj_element_versions ppev

9974: from pa_proj_elem_ver_schedule ppevs
9975: where ppevs.project_id = p_project_id
9976: and ppevs.proj_element_id = p_proj_element_id
9977: and ppevs.element_version_id = (select ppev.element_version_id
9978: from pa_proj_element_versions ppev
9979: where ppev.project_id = p_project_id
9980: and ppev.proj_element_id = p_proj_element_id
9981: and ppev.object_type = p_object_type
9982: and ppev.parent_structure_version_id = p_str_ver_id);

Line 9990: from pa_proj_element_versions ppev

9986: from pa_proj_elem_ver_schedule ppevs
9987: where ppevs.project_id = p_project_id
9988: and ppevs.proj_element_id = p_proj_element_id
9989: and ppevs.element_version_id = (select ppev.element_version_id
9990: from pa_proj_element_versions ppev
9991: where ppev.project_id = p_project_id
9992: and ppev.proj_element_id = p_proj_element_id
9993: and ppev.object_type = p_object_type
9994: and ppev.parent_structure_version_id = p_str_ver_id);

Line 10070: pa_proj_element_versions pev,

10066: substrb(rlm.alias,1,40), -- Bug 4348814 : Added substr
10067: bl.txn_currency_code,
10068: pr.txn_currency_code
10069: FROM
10070: pa_proj_element_versions pev,
10071: pa_proj_elements pe,
10072: pa_resource_assignments ra,
10073: pa_resource_list_members rlm,
10074: pa_budget_lines bl,

Line 10215: pa_proj_element_versions pev,

10211: decode(pr.structure_version_id, NULL, 'Y', 'N')
10212: FROM
10213: pa_res_asgmts_temp rat,
10214: pa_resource_assignments ra,
10215: pa_proj_element_versions pev,
10216: pa_progress_rollup pr
10217: WHERE
10218: ra.resource_assignment_id = rat.resource_assignment_id AND
10219: pev.element_version_id = ra.wbs_element_version_id AND

Line 10475: PA_PROJ_ELEMENT_VERSIONS PPEV

10471: select pra.total_project_burdened_cost as planned_bur_cost_proj_cur
10472: , pra.resource_assignment_id -- Bug 4372462
10473: , pra.budget_version_id -- Bug 4372462
10474: FROM pa_resource_assignments pra,
10475: PA_PROJ_ELEMENT_VERSIONS PPEV
10476: where pra.resource_list_member_id = p_resource_list_mem_id
10477: and pra.task_id = p_task_id
10478: AND PPEV.PROJECT_ID = p_project_id
10479: AND PPEV.PARENT_STRUCTURE_VERSION_ID = p_structure_version_id

Line 11744: FROM pa_progress_rollup ppr, pa_proj_element_versions ppev -- Bug # 4658185.

11740: , c_published_structure VARCHAR2
11741: , c_structure_version_id NUMBER)
11742: IS
11743: SELECT max(as_of_date)
11744: FROM pa_progress_rollup ppr, pa_proj_element_versions ppev -- Bug # 4658185.
11745: WHERE ppr.project_id = c_project_id
11746: AND ppr.object_id = c_object_id
11747: AND ppr.object_type = c_object_type
11748: AND ppr.structure_type = c_structure_type

Line 12579: pa_proj_element_versions ppv

12575: (
12576: select ppv.proj_element_id proj_element_id,
12577: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12578: from pa_progress_rollup ppr,
12579: pa_proj_element_versions ppv
12580: where ppv.parent_structure_version_id=p_structure_version_id
12581: and ppv.project_id=p_project_id
12582: and ppv.proj_element_id=p_proj_element_id
12583: and ppr.object_id (+) =ppv.proj_element_id

Line 12632: pa_proj_element_versions ppv

12628: (
12629: select ppv.proj_element_id proj_element_id,
12630: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12631: from pa_progress_rollup ppr,
12632: pa_proj_element_versions ppv
12633: where ppv.parent_structure_version_id=p_structure_version_id
12634: and ppv.project_id=p_project_id
12635: and ppv.proj_element_id=p_proj_element_id
12636: and ppr.object_id (+) =ppv.proj_element_id

Line 12686: pa_proj_element_versions ppv

12682: (
12683: select ppv.proj_element_id proj_element_id,
12684: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12685: from pa_progress_rollup ppr,
12686: pa_proj_element_versions ppv
12687: where ppv.parent_structure_version_id=p_structure_version_id
12688: and ppv.project_id=p_project_id
12689: and ppv.proj_element_id=p_proj_element_id
12690: and ppr.object_id (+) =ppv.proj_element_id

Line 12740: pa_proj_element_versions ppv

12736: (
12737: select ppv.proj_element_id proj_element_id,
12738: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12739: from pa_progress_rollup ppr,
12740: pa_proj_element_versions ppv
12741: where ppv.parent_structure_version_id=p_structure_version_id
12742: and ppv.project_id=p_project_id
12743: and ppv.proj_element_id=p_proj_element_id
12744: and ppr.object_id (+) =ppv.proj_element_id

Line 12797: pa_proj_element_versions ppv

12793: select ppv.proj_element_id proj_element_id,
12794: max(ppv.parent_structure_version_id) parent_structure_id,
12795: nvl(p_as_of_date,max(ppr.as_of_date)) as_of_date
12796: from pa_progress_rollup ppr,
12797: pa_proj_element_versions ppv
12798: where ppv.parent_structure_version_id<=p_structure_version_id
12799: and ppv.project_id=p_project_id
12800: and ppv.proj_element_id=p_proj_element_id
12801: and ppr.object_id (+) =ppv.proj_element_id

Line 12852: pa_proj_element_versions ppv

12848: select ppv.proj_element_id proj_element_id,
12849: max(ppv.parent_structure_version_id) parent_structure_id,
12850: nvl(p_as_of_date,max(ppr.as_of_date)) as_of_date
12851: from pa_progress_rollup ppr,
12852: pa_proj_element_versions ppv
12853: where ppv.parent_structure_version_id<=p_structure_version_id
12854: and ppv.project_id=p_project_id
12855: and ppv.proj_element_id=p_proj_element_id
12856: and ppr.object_id (+) =ppv.proj_element_id

Line 12887: from pa_proj_element_versions ppev1,

12883: ppev2.proj_element_id parent_task_id,
12884: ppev1.wbs_level,
12885: nvl(ppe.baseline_start_date,ppevs.scheduled_start_date) sch_start_date,
12886: nvl(ppe.baseline_finish_date,ppevs.scheduled_finish_date) sch_end_date
12887: from pa_proj_element_versions ppev1,
12888: pa_proj_element_versions ppev2,
12889: pa_object_relationships por,
12890: pa_proj_elements ppe,
12891: pa_proj_elem_ver_schedule ppevs

Line 12888: pa_proj_element_versions ppev2,

12884: ppev1.wbs_level,
12885: nvl(ppe.baseline_start_date,ppevs.scheduled_start_date) sch_start_date,
12886: nvl(ppe.baseline_finish_date,ppevs.scheduled_finish_date) sch_end_date
12887: from pa_proj_element_versions ppev1,
12888: pa_proj_element_versions ppev2,
12889: pa_object_relationships por,
12890: pa_proj_elements ppe,
12891: pa_proj_elem_ver_schedule ppevs
12892: where ppev1.parent_structure_version_id = p_structure_version_id