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_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 924: pa_proj_element_versions ppev,

920: CURSOR cur_pa_task_prg1
921: IS
922: SELECT WQ_PLANNED_QUANTITY
923: FROM pa_proj_elements ppe,
924: pa_proj_element_versions ppev,
925: pa_proj_elem_ver_schedule ppevsh
926: WHERE ppe.project_id = ppev.project_id
927: AND ppe.proj_element_id = p_task_id
928: AND ppev.proj_element_id = ppe.proj_element_id

Line 1801: FROM pa_proj_element_versions

1797: THEN
1798: UPDATE pa_proj_elements
1799: SET progress_outdated_flag = 'N'
1800: WHERE proj_element_id in ( SELECT proj_element_id
1801: FROM pa_proj_element_versions
1802: WHERE project_id = p_project_id
1803: AND parent_structure_version_id = p_structure_version_id
1804: AND object_type in ( 'PA_STRUCTURES', 'PA_TASKS' ) )
1805: AND object_type in ( 'PA_STRUCTURES', 'PA_TASKS' )

Line 2259: pa_proj_element_versions ppev,

2255: CURSOR cur_pa_proj
2256: IS
2257: SELECT ppe.status_code
2258: FROM pa_object_relationships por,
2259: pa_proj_element_versions ppev,
2260: pa_proj_elements ppe,
2261: pa_project_statuses pps
2262: WHERE object_id_to1 = p_object_version_id
2263: AND ppev.element_version_id = por.object_id_from1

Line 2558: pa_proj_element_versions PPEV

2554: CURSOR l_get_task_manager(c_element_version_id NUMBER)
2555: IS
2556: SELECT ppe.manager_person_id
2557: FROM pa_proj_elements PPE,
2558: pa_proj_element_versions PPEV
2559: WHERE ppev.element_version_id = c_element_version_id
2560: AND ppev.proj_element_id = ppe.proj_element_id;
2561:
2562: CURSOR l_get_parent_task(c_element_version_id NUMBER)

Line 2574: FROM pa_proj_element_versions ppev

2570:
2571: CURSOR l_get_element_version_id(c_proj_element_id NUMBER, c_parent_structure_version_id NUMBER)
2572: IS
2573: SELECT ppev.element_version_id
2574: FROM pa_proj_element_versions ppev
2575: WHERE ppev.proj_element_id = c_proj_element_id
2576: AND ppev.parent_structure_version_id = c_parent_structure_version_id;
2577:
2578: CURSOR l_get_latest_pub_structure_ver

Line 6250: from pa_proj_element_versions

6246:
6247: CURSOR cur_str_ver_id
6248: is
6249: select parent_structure_version_id
6250: from pa_proj_element_versions
6251: where project_id = p_project_id
6252: and proj_element_id = p_proj_element_id
6253: and element_version_id = p_task_version_id
6254: ;

Line 6621: from pa_proj_element_versions ppev

6617: from pa_proj_elem_ver_schedule ppevs
6618: where ppevs.project_id = p_project_id
6619: and ppevs.proj_element_id = p_proj_element_id
6620: and ppevs.element_version_id = (select ppev.element_version_id
6621: from pa_proj_element_versions ppev
6622: where ppev.project_id = p_project_id
6623: and ppev.proj_element_id = p_proj_element_id
6624: and ppev.parent_structure_version_id = p_structure_version_id);
6625: l_start_date DATE;

Line 7192: from pa_proj_element_versions

7188: and proj_element_id = p_proj_element_id;
7189:
7190: cursor c2(p_element_version_id NUMBER) is
7191: select proj_element_id
7192: from pa_proj_element_versions
7193: where element_version_id = p_element_version_id;
7194:
7195: cursor c3(p_project_id NUMBER, p_element_version_id NUMBER) is
7196: select wq_planned_quantity

Line 7227: from pa_proj_element_versions ppev

7223: /* Begin code to fix Bug # 4172372. */
7224:
7225: cursor cur_task_version(c_project_id NUMBER, c_wp_task_id NUMBER, c_wp_str_ver_id NUMBER) is
7226: select ppev.element_version_id
7227: from pa_proj_element_versions ppev
7228: where ppev.project_id = c_project_id
7229: and ppev.proj_element_id = c_wp_task_id
7230: and ppev.parent_structure_version_id = c_wp_str_ver_id;
7231:

Line 7407: from pa_proj_element_versions

7403: l_structure_sharing_code VARCHAR2(30) := NULL;
7404:
7405: cursor c1(p_proj_element_id NUMBER, p_structure_version_id NUMBER) is
7406: select element_version_id
7407: from pa_proj_element_versions
7408: where project_id = p_project_id
7409: and proj_element_id = p_proj_element_id
7410: and parent_structure_version_id = p_structure_version_id;
7411:

Line 10052: from pa_proj_element_versions ppev

10048: from pa_proj_elem_ver_schedule ppevs
10049: where ppevs.project_id = p_project_id
10050: and ppevs.proj_element_id = p_proj_element_id
10051: and ppevs.element_version_id = (select ppev.element_version_id
10052: from pa_proj_element_versions ppev
10053: where ppev.project_id = p_project_id
10054: and ppev.proj_element_id = p_proj_element_id
10055: and ppev.object_type = p_object_type
10056: and ppev.parent_structure_version_id = p_str_ver_id);

Line 10064: from pa_proj_element_versions ppev

10060: from pa_proj_elem_ver_schedule ppevs
10061: where ppevs.project_id = p_project_id
10062: and ppevs.proj_element_id = p_proj_element_id
10063: and ppevs.element_version_id = (select ppev.element_version_id
10064: from pa_proj_element_versions ppev
10065: where ppev.project_id = p_project_id
10066: and ppev.proj_element_id = p_proj_element_id
10067: and ppev.object_type = p_object_type
10068: and ppev.parent_structure_version_id = p_str_ver_id);

Line 10144: pa_proj_element_versions pev,

10140: substrb(rlm.alias,1,40), -- Bug 4348814 : Added substr
10141: bl.txn_currency_code,
10142: pr.txn_currency_code
10143: FROM
10144: pa_proj_element_versions pev,
10145: pa_proj_elements pe,
10146: pa_resource_assignments ra,
10147: pa_resource_list_members rlm,
10148: pa_budget_lines bl,

Line 10289: pa_proj_element_versions pev,

10285: decode(pr.structure_version_id, NULL, 'Y', 'N')
10286: FROM
10287: pa_res_asgmts_temp rat,
10288: pa_resource_assignments ra,
10289: pa_proj_element_versions pev,
10290: pa_progress_rollup pr
10291: WHERE
10292: ra.resource_assignment_id = rat.resource_assignment_id AND
10293: pev.element_version_id = ra.wbs_element_version_id AND

Line 10550: PA_PROJ_ELEMENT_VERSIONS PPEV

10546: select pra.total_project_burdened_cost as planned_bur_cost_proj_cur
10547: , pra.resource_assignment_id -- Bug 4372462
10548: , pra.budget_version_id -- Bug 4372462
10549: FROM pa_resource_assignments pra,
10550: PA_PROJ_ELEMENT_VERSIONS PPEV
10551: where pra.resource_list_member_id = p_resource_list_mem_id
10552: and pra.task_id = p_task_id
10553: AND PPEV.PROJECT_ID = p_project_id
10554: AND PPEV.PARENT_STRUCTURE_VERSION_ID = p_structure_version_id

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

11820: , c_published_structure VARCHAR2
11821: , c_structure_version_id NUMBER)
11822: IS
11823: SELECT max(as_of_date)
11824: FROM pa_progress_rollup ppr, pa_proj_element_versions ppev -- Bug # 4658185.
11825: WHERE ppr.project_id = c_project_id
11826: AND ppr.object_id = c_object_id
11827: AND ppr.object_type = c_object_type
11828: AND ppr.structure_type = c_structure_type

Line 12673: pa_proj_element_versions ppv

12669: (
12670: select ppv.proj_element_id proj_element_id,
12671: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12672: from pa_progress_rollup ppr,
12673: pa_proj_element_versions ppv
12674: where ppv.parent_structure_version_id=p_structure_version_id
12675: and ppv.project_id=p_project_id
12676: and ppv.proj_element_id=p_proj_element_id
12677: and ppr.object_id (+) =ppv.proj_element_id

Line 12726: pa_proj_element_versions ppv

12722: (
12723: select ppv.proj_element_id proj_element_id,
12724: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12725: from pa_progress_rollup ppr,
12726: pa_proj_element_versions ppv
12727: where ppv.parent_structure_version_id=p_structure_version_id
12728: and ppv.project_id=p_project_id
12729: and ppv.proj_element_id=p_proj_element_id
12730: and ppr.object_id (+) =ppv.proj_element_id

Line 12780: pa_proj_element_versions ppv

12776: (
12777: select ppv.proj_element_id proj_element_id,
12778: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12779: from pa_progress_rollup ppr,
12780: pa_proj_element_versions ppv
12781: where ppv.parent_structure_version_id=p_structure_version_id
12782: and ppv.project_id=p_project_id
12783: and ppv.proj_element_id=p_proj_element_id
12784: and ppr.object_id (+) =ppv.proj_element_id

Line 12834: pa_proj_element_versions ppv

12830: (
12831: select ppv.proj_element_id proj_element_id,
12832: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12833: from pa_progress_rollup ppr,
12834: pa_proj_element_versions ppv
12835: where ppv.parent_structure_version_id=p_structure_version_id
12836: and ppv.project_id=p_project_id
12837: and ppv.proj_element_id=p_proj_element_id
12838: and ppr.object_id (+) =ppv.proj_element_id

Line 12891: pa_proj_element_versions ppv

12887: select ppv.proj_element_id proj_element_id,
12888: max(ppv.parent_structure_version_id) parent_structure_id,
12889: nvl(p_as_of_date,max(ppr.as_of_date)) as_of_date
12890: from pa_progress_rollup ppr,
12891: pa_proj_element_versions ppv
12892: where ppv.parent_structure_version_id<=p_structure_version_id
12893: and ppv.project_id=p_project_id
12894: and ppv.proj_element_id=p_proj_element_id
12895: and ppr.object_id (+) =ppv.proj_element_id

Line 12946: pa_proj_element_versions ppv

12942: select ppv.proj_element_id proj_element_id,
12943: max(ppv.parent_structure_version_id) parent_structure_id,
12944: nvl(p_as_of_date,max(ppr.as_of_date)) as_of_date
12945: from pa_progress_rollup ppr,
12946: pa_proj_element_versions ppv
12947: where ppv.parent_structure_version_id<=p_structure_version_id
12948: and ppv.project_id=p_project_id
12949: and ppv.proj_element_id=p_proj_element_id
12950: and ppr.object_id (+) =ppv.proj_element_id

Line 12982: from pa_proj_element_versions ppev1,

12978: ppev2.proj_element_id parent_task_id,
12979: ppev1.wbs_level,
12980: nvl(ppe.baseline_start_date,ppevs.scheduled_start_date) sch_start_date,
12981: nvl(ppe.baseline_finish_date,ppevs.scheduled_finish_date) sch_end_date
12982: from pa_proj_element_versions ppev1,
12983: pa_proj_element_versions ppev2,
12984: pa_object_relationships por,
12985: pa_proj_elements ppe,
12986: pa_proj_elem_ver_schedule ppevs

Line 12983: pa_proj_element_versions ppev2,

12979: ppev1.wbs_level,
12980: nvl(ppe.baseline_start_date,ppevs.scheduled_start_date) sch_start_date,
12981: nvl(ppe.baseline_finish_date,ppevs.scheduled_finish_date) sch_end_date
12982: from pa_proj_element_versions ppev1,
12983: pa_proj_element_versions ppev2,
12984: pa_object_relationships por,
12985: pa_proj_elements ppe,
12986: pa_proj_elem_ver_schedule ppevs
12987: where ppev1.parent_structure_version_id = p_structure_version_id