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_ELEM_VER_STRUCTURE

Line 352: FROM pa_proj_elem_ver_structure str, pa_project_statuses status

348: ( c_structure_version_id number
349: , c_project_id number
350: )IS
351: SELECT decode(status.project_system_status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N')
352: FROM pa_proj_elem_ver_structure str, pa_project_statuses status
353: where str.element_version_id = c_structure_version_id
354: AND str.project_id = c_project_id
355: AND str.status_code = status.project_status_code;
356:

Line 4484: from pa_proj_elem_ver_structure str,

4480:
4481: --cursor to get structure version id of all non-published version
4482: CURSOR cur_get_wk_ver_struct_id IS
4483: select str.element_version_id
4484: from pa_proj_elem_ver_structure str,
4485: pa_proj_elements pe,
4486: pa_proj_structure_types pst
4487: where pe.project_id = p_project_id
4488: and pe.project_id = str.project_id

Line 4501: from pa_proj_elem_ver_structure str,

4497:
4498: --cursor to get only structure version id (when version disabled)
4499: CURSOR cur_get_only_ver_struct_id IS
4500: select str.element_version_id
4501: from pa_proj_elem_ver_structure str,
4502: pa_proj_elements pe,
4503: pa_proj_structure_types pst
4504: where pe.project_id = p_project_id
4505: and pe.project_id = str.project_id

Line 8362: UPDATE pa_proj_elem_ver_structure

8358: -- Call of rollup future is not needed here as there will be only one record per object in working version
8359:
8360: --- END IF; -- If workplan versioning is enabled
8361:
8362: UPDATE pa_proj_elem_ver_structure
8363: set date_prog_applied_on_wver = sysdate
8364: ,schedule_dirty_flag = decode( PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(p_project_id), --bug 3844689
8365: 'Y', 'Y', schedule_dirty_flag ) --set this flag to indicate re-scheduling is required.
8366: WHERE project_id = p_project_id

Line 8569: FROM PA_Proj_Elem_Ver_Structure ppevs,

8565: l_str_ver_id NUMBER;
8566: Cursor cur_Summerized_Actuals
8567: IS
8568: Select ppevs.element_version_id
8569: FROM PA_Proj_Elem_Ver_Structure ppevs,
8570: PA_Proj_Elements ppe,
8571: PA_Proj_Structure_Types ppst,
8572: PA_Structure_types pst
8573: WHERE ppevs.Project_ID = P_Project_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 11318: FROM pa_proj_elem_ver_structure a

11314: and ppr.current_flag = 'Y';
11315:
11316: CURSOR get_prev_published_ver IS
11317: SELECT a.element_version_id
11318: FROM pa_proj_elem_ver_structure a
11319: WHERE a.project_id = p_project_id
11320: AND a.LATEST_EFF_PUBLISHED_FLAG <> 'Y'
11321: AND a.STATUS_CODE = 'STRUCTURE_PUBLISHED'
11322: ORDER BY published_date desc;

Line 13894: from pa_proj_elem_ver_structure

13890: -- Bug 6321238
13891: cursor check_pup_pue(c_project_id number,
13892: c_latest_published_version_id number) is
13893: select 'Y'
13894: from pa_proj_elem_ver_structure
13895: where project_id = c_project_id
13896: and element_version_id = c_latest_published_version_id
13897: and process_code = 'PUE';
13898:

Line 18528: FROM pa_proj_elem_ver_structure str, pa_project_statuses status

18524:
18525: CURSOR cur_check_published_version(c_structure_version_id number, c_project_id number)
18526: IS
18527: SELECT decode(status.project_system_status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N')
18528: FROM pa_proj_elem_ver_structure str, pa_project_statuses status
18529: where str.element_version_id = c_structure_version_id
18530: AND str.project_id = c_project_id
18531: AND str.status_code = status.project_status_code;
18532:

Line 19459: FROM pa_proj_elem_ver_structure str

19455:
19456: CURSOR cur_check_published_version(c_structure_version_id number, c_project_id number)
19457: IS
19458: SELECT decode(status.project_system_status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N')
19459: FROM pa_proj_elem_ver_structure str
19460: , pa_project_statuses status
19461: where str.element_version_id = c_structure_version_id
19462: AND str.project_id = c_project_id
19463: AND str.status_code = status.project_status_code;

Line 19657: , pa_proj_elem_ver_structure str

19653:
19654: CURSOR c_get_distinct_str_ver_id IS
19655: SELECT distinct asgn.project_id project_id, asgn.structure_version_id structure_version_id
19656: FROM pa_task_asgmts_v asgn
19657: , pa_proj_elem_ver_structure str
19658: , pa_proj_progress_attr prog
19659: , pa_proj_structure_types pstype
19660: WHERE asgn.person_id = p_person_id
19661: AND asgn.structure_version_id = str.element_version_id

Line 19672: , pa_proj_elem_ver_structure str

19668: AND prog.allow_collab_prog_entry = 'Y'
19669: UNION
19670: SELECT distinct elem.project_id project_id, str.element_version_id structure_version_id
19671: FROM pa_proj_elements elem
19672: , pa_proj_elem_ver_structure str
19673: , pa_proj_progress_attr prog
19674: , pa_proj_structure_types pstype
19675: WHERE elem.manager_person_id = p_person_id
19676: AND elem.object_type = 'PA_TASKS'

Line 20085: FROM PA_Proj_Elem_Ver_Structure ppevs,

20081: ;*/
20082: --end bug 3968791
20083: Cursor cur_Summerized_Actuals IS
20084: Select count(1)
20085: FROM PA_Proj_Elem_Ver_Structure ppevs,
20086: PA_Proj_Elements ppe,
20087: PA_Proj_Structure_Types ppst,
20088: PA_Structure_types pst
20089: WHERE ppevs.Project_ID = P_Project_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