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

Line 3762: from pa_proj_element_versions ppev1, pa_proj_element_versions ppev2

3758:
3759: BEGIN
3760: Select ppev1.proj_element_id
3761: into l_structure_id
3762: from pa_proj_element_versions ppev1, pa_proj_element_versions ppev2
3763: where ppev2.element_version_id = p_object_version_id
3764: and ppev2.project_id = ppev1.project_id
3765: and ppev2.parent_structure_version_id = ppev1.element_version_id;
3766: EXCEPTION WHEN OTHERS THEN

Line 4521: from pa_proj_element_versions ppev

4517:
4518: -- Bug # 4576303.
4519: cursor cur_tasks_exist (c_str_ver_id NUMBER) is
4520: select 'Y'
4521: from pa_proj_element_versions ppev
4522: where ppev.parent_structure_version_id = c_str_ver_id
4523: and ppev.object_type = 'PA_TASKS';
4524:
4525: l_tasks_exist VARCHAR2(1) := null;

Line 5023: FROM pa_proj_element_versions

5019:
5020: CURSOR cur_ppevs( c_element_version_id NUMBER )
5021: IS
5022: SELECT project_id, proj_element_id
5023: FROM pa_proj_element_versions
5024: WHERE element_version_id = c_element_version_id
5025: ;
5026:
5027: l_rollup_row_id VARCHAR2(18);

Line 5164: pa_proj_element_versions ppev1,

5160: UNION -- Bug 3878024 : Added Union
5161: SELECT to_number(null) object_id_from1, p_object_version_id object_id_to1
5162: FROM DUAL
5163: ) pobj,
5164: pa_proj_element_versions ppev1,
5165: pa_proj_elem_ver_schedule sch
5166: WHERE pobj.object_id_to1 = ppev1.element_version_id
5167: AND ppev1.element_version_id = sch.element_version_id;
5168:

Line 5358: FROM pa_proj_element_versions

5354:
5355: -- Bug 3878024 : Begin
5356: BEGIN
5357: SELECT parent_structure_version_id INTO l_structure_version_id
5358: FROM pa_proj_element_versions
5359: WHERE element_version_id = p_object_version_id;
5360: EXCEPTION
5361: WHEN OTHERS THEN
5362: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

Line 6855: from pa_progress_rollup ppr, pa_proj_element_versions ppev --4871809

6851:
6852: CURSOR C1(p_project_id NUMBER, p_working_str_version_id NUMBER) is
6853: -- Bug # 4581937.
6854: select ppr.*
6855: from pa_progress_rollup ppr, pa_proj_element_versions ppev --4871809
6856: where ppr.project_id = p_project_id
6857: and ppr.structure_version_id is null
6858: and ppr.object_type in ('PA_STRUCTURES','PA_ASSIGNMENTS','PA_TASKS')
6859: --and pa_proj_elements_utils.is_lowest_task(ppr.object_version_id) = 'Y' --bug 4050532

Line 6879: from pa_proj_element_versions

6875:
6876: -- FPM Dev CR 4 : Added the cusrosr c_get_work_obj_ver_id
6877: CURSOR c_get_work_obj_ver_id(c_proj_element_id NUMBER, c_structure_version_id NUMBER) IS
6878: select element_version_id
6879: from pa_proj_element_versions
6880: where project_id = p_project_id
6881: and proj_element_id = c_proj_element_id
6882: and parent_structure_version_id = c_structure_version_id;
6883:

Line 8596: pa_proj_element_versions ppev

8592: CURSOR c_check_prog_exists_prg IS
8593: SELECT 'Y' from dual
8594: where exists ( select DISTINCT ppev.PROJECT_ID
8595: FROM pa_progress_rollup ppr,
8596: pa_proj_element_versions ppev
8597: where ppr.project_id=ppev.project_id
8598: and ppev.OBJECT_TYPE = 'PA_STRUCTURES'
8599: and ppr.structure_type = 'WORKPLAN'
8600: and ppr.structure_version_id is null

Line 8602: from PA_PROJ_ELEMENT_VERSIONS ppev2

8598: and ppev.OBJECT_TYPE = 'PA_STRUCTURES'
8599: and ppr.structure_type = 'WORKPLAN'
8600: and ppr.structure_version_id is null
8601: and exists (select null
8602: from PA_PROJ_ELEMENT_VERSIONS ppev2
8603: where ppev2.project_id=p_project_id
8604: and ppev.prg_group=ppev2.prg_group)
8605: );
8606:

Line 8855: FROM pa_proj_element_versions

8851:
8852: CURSOR c_get_task_version_id(c_proj_element_id NUMBER, c_project_id NUMBER, c_structure_version_id NUMBER)
8853: IS
8854: SELECT element_version_id, parent_structure_version_id
8855: FROM pa_proj_element_versions
8856: WHERE proj_element_id = c_proj_element_id
8857: AND object_type = 'PA_TASKS'
8858: AND project_id = c_project_id
8859: AND parent_structure_version_id = c_structure_version_id;

Line 8871: FROM pa_proj_element_versions elemver, pa_proj_elem_ver_structure str

8867:
8868: CURSOR c_get_latest_pub_task_ver(c_proj_element_id NUMBER, c_project_id NUMBER)
8869: IS
8870: SELECT elemver.element_version_id, elemver.parent_structure_version_id
8871: FROM pa_proj_element_versions elemver, pa_proj_elem_ver_structure str
8872: WHERE elemver.proj_element_id = c_proj_element_id
8873: AND elemver.object_type = 'PA_TASKS'
8874: AND elemver.project_id = c_project_id
8875: AND str.project_id = c_project_id

Line 9640: from pa_proj_element_versions ppev1, pa_proj_element_versions ppev2

9636:
9637: BEGIN
9638: Select ppev1.proj_element_id
9639: into l_structure_id
9640: from pa_proj_element_versions ppev1, pa_proj_element_versions ppev2
9641: where ppev2.element_version_id = l_task_version_id
9642: and ppev2.project_id = ppev1.project_id
9643: and ppev2.parent_structure_version_id = ppev1.element_version_id;
9644: EXCEPTION WHEN OTHERS THEN

Line 10709: FROM pa_proj_element_versions ppv, pa_progress_rollup ppr

10705: -- Bug 3957457 : get percent complete from pa_progress_rollup instead of pa_percent_complete
10706: -- 4392189 : Program Reporting Changes - Phase 2 : Get base % complete rather rollup % complete
10707: -- SELECT ppv.proj_element_id, ppv.element_version_id, ppv.record_version_number, nvl(ppr.completed_percentage, ppr.eff_rollup_percent_comp) completed_percentage
10708: SELECT ppv.proj_element_id, ppv.element_version_id, ppv.record_version_number, nvl(ppr.completed_percentage, ppr.base_percent_complete) completed_percentage
10709: FROM pa_proj_element_versions ppv, pa_progress_rollup ppr
10710: WHERE ppv.project_id = p_project_id
10711: AND ppv.financial_task_flag = 'Y'
10712: AND ppv.parent_structure_version_id = c_structure_version_id -- Bug 3957457
10713: -- AND PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id) = 'N' bug 4086613

Line 10722: pa_proj_element_versions ppv1

10718: AND ppr.structure_type(+) = c_structure_type
10719: AND ppr.structure_version_id(+) is null -- Bug 3957457
10720: and not exists (select 1
10721: from pa_object_relationships por,
10722: pa_proj_element_versions ppv1
10723: where por.object_id_from1 = ppv.element_version_id
10724: and relationship_type = 'S'
10725: and ppv1.element_version_id = por.object_id_to1
10726: and ppv1.financial_task_flag = 'Y')

Line 10735: FROM pa_proj_element_versions ppv, pa_progress_rollup ppr, pa_object_relationships por

10731: IS
10732: -- Bug 3952006 : get percent complete from pa_progress_rollup instead of pa_percent_complete
10733: --SELECT ppv.proj_element_id, ppv.element_version_id, ppv.record_version_number, nvl(ppr.completed_percentage, ppr.eff_rollup_percent_comp) completed_percentage
10734: SELECT ppv.proj_element_id, ppv.element_version_id, ppv.record_version_number, nvl(ppr.completed_percentage, ppr.base_percent_complete) completed_percentage
10735: FROM pa_proj_element_versions ppv, pa_progress_rollup ppr, pa_object_relationships por
10736: WHERE ppv.project_id = p_project_id
10737: AND ppv.parent_structure_version_id = c_structure_version_id -- Bug 3952006
10738: AND ppv.project_id = ppr.project_id(+)
10739: AND por.object_id_to1 = c_object_version_id

Line 11278: from pa_proj_element_versions

11274: and ppc.published_flag = 'Y';
11275:
11276: CURSOR c_get_work_obj_ver_id(c_proj_element_id NUMBER, c_structure_version_id NUMBER, c_object_type VARCHAR2) IS
11277: select element_version_id
11278: from pa_proj_element_versions
11279: where project_id = p_project_id
11280: and proj_element_id = c_proj_element_id
11281: and ((c_object_type <> 'PA_DELIVERABLES' and parent_structure_version_id = c_structure_version_id)
11282: OR c_object_type = 'PA_DELIVERABLES'); -- 4398411 : Added Deliverable condition

Line 13722: pa_proj_element_versions ppev,

13718: ptt.initial_progress_status_code,
13719: ppevs.scheduled_start_date,
13720: ppevs.scheduled_finish_date
13721: from pa_proj_elements ppe,
13722: pa_proj_element_versions ppev,
13723: pa_proj_elem_ver_schedule ppevs,
13724: pa_task_types ptt
13725: where ppev.proj_element_id = l_obj
13726: and ppev.parent_structure_version_id = l_latest_wp_struct_ver_id

Line 20945: pa_proj_element_versions ppv1 --4871809

20941: CURSOR c_get_min_max_dates(c_par_project_id NUMBER, c_par_task_id NUMBER, c_par_task_ver_id NUMBER, c_par_str_ver_id NUMBER, c_as_of_date DATE) IS
20942: select min(ppr.actual_start_date), max(ppr.actual_finish_date), min(ppr.estimated_start_date), max(ppr.estimated_finish_date)
20943: FROM
20944: --- removed join with pa_structures_links_v for performance improvement
20945: pa_proj_element_versions ppv1 --4871809
20946: ,pa_proj_element_versions ppv2
20947: ,pa_object_relationships por1
20948: ,pa_object_relationships por2
20949: ,pa_progress_rollup ppr

Line 20946: ,pa_proj_element_versions ppv2

20942: select min(ppr.actual_start_date), max(ppr.actual_finish_date), min(ppr.estimated_start_date), max(ppr.estimated_finish_date)
20943: FROM
20944: --- removed join with pa_structures_links_v for performance improvement
20945: pa_proj_element_versions ppv1 --4871809
20946: ,pa_proj_element_versions ppv2
20947: ,pa_object_relationships por1
20948: ,pa_object_relationships por2
20949: ,pa_progress_rollup ppr
20950: WHERE

Line 21170: FROM pa_proj_element_versions

21166:
21167: CURSOR c_get_task_version_id(c_proj_element_id NUMBER, c_project_id NUMBER, c_structure_version_id NUMBER)
21168: IS
21169: SELECT element_version_id, parent_structure_version_id
21170: FROM pa_proj_element_versions
21171: WHERE proj_element_id = c_proj_element_id
21172: AND object_type = 'PA_TASKS'
21173: AND project_id = c_project_id
21174: AND parent_structure_version_id = c_structure_version_id;

Line 21186: FROM pa_proj_element_versions elemver, pa_proj_elem_ver_structure str

21182:
21183: CURSOR c_get_latest_pub_task_ver(c_proj_element_id NUMBER, c_project_id NUMBER)
21184: IS
21185: SELECT elemver.element_version_id, elemver.parent_structure_version_id
21186: FROM pa_proj_element_versions elemver, pa_proj_elem_ver_structure str
21187: WHERE elemver.proj_element_id = c_proj_element_id
21188: AND elemver.object_type = 'PA_TASKS'
21189: AND elemver.project_id = c_project_id
21190: AND str.project_id = c_project_id

Line 22189: from pa_proj_element_versions ppev1, pa_proj_element_versions ppev2

22185:
22186: BEGIN
22187: Select ppev1.proj_element_id
22188: into l_structure_id
22189: from pa_proj_element_versions ppev1, pa_proj_element_versions ppev2
22190: where ppev2.element_version_id = l_task_version_id
22191: and ppev2.project_id = ppev1.project_id
22192: and ppev2.parent_structure_version_id = ppev1.element_version_id;
22193: EXCEPTION WHEN OTHERS THEN