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_PROJ_STRUCTURE_PUB dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 182: FROM pa_proj_elem_ver_structure

178:
179: CURSOR check_pub_str
180: IS
181: SELECT 'Y'
182: FROM pa_proj_elem_ver_structure
183: WHERE project_id= p_project_id
184: AND element_version_id = p_structure_version_id
185: AND status_code = 'STRUCTURE_PUBLISHED';
186:

Line 1501: FROM pa_proj_elem_ver_structure ppvs

1497: ,ppru.PROGRESS_ROLLUP_ID
1498: ,ppru.BASE_PERCENT_COMPLETE --Bug 4416432 Issue 2
1499: ,nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0) - (nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)) PLANNED_BASELINE_EFFORT_VAR -- Added for bug 5090355
1500: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) Planned_Baseline_Finish -- Added for bug 5090355
1501: FROM pa_proj_elem_ver_structure ppvs
1502: --,ra_addresses_all addr
1503: ,HZ_CUST_ACCT_SITES_ALL S
1504: ,HZ_PARTY_SITES PS
1505: ,HZ_LOCATIONS addr

Line 2316: FROM pa_proj_elem_ver_structure ppvs

2312: ,ppru.PROGRESS_ROLLUP_ID
2313: ,ppru.BASE_PERCENT_COMPLETE --Bug 4416432 Issue 2
2314: ,nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0) - (nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)) PLANNED_BASELINE_EFFORT_VAR -- Added for bug 5090355
2315: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
2316: FROM pa_proj_elem_ver_structure ppvs
2317: --,ra_addresses_all addr
2318: ,HZ_CUST_ACCT_SITES_ALL S
2319: ,HZ_PARTY_SITES PS
2320: ,HZ_LOCATIONS addr

Line 3174: FROM pa_proj_elem_ver_structure ppvs

3170: ,ppru.PROGRESS_ROLLUP_ID
3171: ,ppru.BASE_PERCENT_COMPLETE --Bug 4416432 Issue 2
3172: ,nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0) - (nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)) PLANNED_BASELINE_EFFORT_VAR -- Added for bug 5090355
3173: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
3174: FROM pa_proj_elem_ver_structure ppvs
3175: --,ra_addresses_all addr
3176: ,HZ_CUST_ACCT_SITES_ALL S
3177: ,HZ_PARTY_SITES PS
3178: ,HZ_LOCATIONS addr

Line 4145: FROM pa_proj_elem_ver_structure ppvs

4141: ,ppru.PROGRESS_ROLLUP_ID
4142: ,ppru.BASE_PERCENT_COMPLETE -- Bug 4416432 Issue 2
4143: ,nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0) - (nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)) PLANNED_BASELINE_EFFORT_VAR -- Added for bug 5090355
4144: , nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
4145: FROM pa_proj_elem_ver_structure ppvs
4146: --,ra_addresses_all addr
4147: ,HZ_CUST_ACCT_SITES_ALL S
4148: ,HZ_PARTY_SITES PS
4149: ,HZ_LOCATIONS addr

Line 4970: FROM pa_proj_elem_ver_structure ppvs

4966: ,ppru.PROGRESS_ROLLUP_ID
4967: ,ppru.BASE_PERCENT_COMPLETE -- Bug 4416432 Issue 2
4968: ,nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0) -(nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)) PLANNED_BASELINE_EFFORT_VAR -- Added for bug 5090355
4969: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
4970: FROM pa_proj_elem_ver_structure ppvs
4971: --,ra_addresses_all addr
4972: ,HZ_CUST_ACCT_SITES_ALL S
4973: ,HZ_PARTY_SITES PS
4974: ,HZ_LOCATIONS addr

Line 5796: FROM pa_proj_elem_ver_structure ppvs

5792: ,ppru.PROGRESS_ROLLUP_ID
5793: ,ppru.BASE_PERCENT_COMPLETE -- Bug 4416432 Issue 2
5794: ,nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0) - (nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)) PLANNED_BASELINE_EFFORT_VAR -- Added for bug 5090355
5795: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
5796: FROM pa_proj_elem_ver_structure ppvs
5797: --,ra_addresses_all addr
5798: ,HZ_CUST_ACCT_SITES_ALL S
5799: ,HZ_PARTY_SITES PS
5800: ,HZ_LOCATIONS addr

Line 6743: pa_proj_elem_ver_structure ppvs

6739: , ppru.BASE_PERCENT_COMPLETE -- Bug 4416432 Issue 2
6740: ,nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0) -(nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)) PLANNED_BASELINE_EFFORT_VAR -- Added for bug 5090355
6741: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
6742: FROM
6743: pa_proj_elem_ver_structure ppvs
6744: ,pa_proj_elem_ver_schedule ppvsch
6745: ,per_all_people_f papf
6746: ,pa_projects_all ppa
6747: ,pa_page_layouts ppl

Line 7233: pa_proj_elem_ver_structure ppvs

7229: , ppru.BASE_PERCENT_COMPLETE -- Bug 4416432 Issue 2
7230: ,nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0) - (nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)) PLANNED_BASELINE_EFFORT_VAR -- Added for bug 5090355
7231: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
7232: FROM
7233: pa_proj_elem_ver_structure ppvs
7234: ,pa_proj_elem_ver_schedule ppvsch
7235: ,per_all_people_f papf
7236: ,pa_projects_all ppa
7237: ,pa_page_layouts ppl

Line 8051: FROM pa_proj_elem_ver_structure ppvs

8047: -- ,(nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
8048: -- +nvl(ppru.eqpmt_act_cost_to_date_pc,0)+nvl(ppru.subprj_oth_act_cost_to_date_pc,0)
8049: --+nvl(ppru.subprj_ppl_act_cost_pc,0)+nvl(ppru.subprj_eqpmt_act_cost_pc,0)), decode(ppwa.wp_enable_version_flag,'Y','PUBLISH','WORKING')) ETC_Cost
8050: ,ppru.PROGRESS_ROLLUP_ID
8051: FROM pa_proj_elem_ver_structure ppvs
8052: --,ra_addresses_all addr
8053: ,HZ_CUST_ACCT_SITES_ALL S
8054: ,HZ_PARTY_SITES PS
8055: ,HZ_LOCATIONS addr

Line 8811: FROM pa_proj_elem_ver_structure ppvs

8807: -- ,(nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
8808: -- +nvl(ppru.eqpmt_act_cost_to_date_pc,0)+nvl(ppru.subprj_oth_act_cost_to_date_pc,0)
8809: --+nvl(ppru.subprj_ppl_act_cost_pc,0)+nvl(ppru.subprj_eqpmt_act_cost_pc,0)), 'WORKING') ETC_Cost
8810: ,ppru.PROGRESS_ROLLUP_ID
8811: FROM pa_proj_elem_ver_structure ppvs
8812: --,ra_addresses_all addr
8813: ,HZ_CUST_ACCT_SITES_ALL S
8814: ,HZ_PARTY_SITES PS
8815: ,HZ_LOCATIONS addr

Line 9762: FROM pa_proj_elem_ver_structure ppvs

9758: ,l_check_edit_task_ok
9759: -- End of Bug Fix 5611634.
9760: ,nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0) - (nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)) PLANNED_BASELINE_EFFORT_VAR -- Added for bug 5090355
9761: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
9762: FROM pa_proj_elem_ver_structure ppvs
9763: ,pa_proj_elem_ver_schedule ppvsch
9764: ,pa_proj_elements ppe5
9765: ,pa_proj_element_versions ppv5
9766: ,per_all_people_f papf

Line 10589: FROM pa_proj_elem_ver_structure ppvs

10585: ,l_check_edit_task_ok
10586: -- End of Bug Fix 5611634.
10587: ,nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0) - (nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)) PLANNED_BASELINE_EFFORT_VAR -- Added for bug 5090355
10588: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
10589: FROM pa_proj_elem_ver_structure ppvs
10590: ,pa_proj_elem_ver_schedule ppvsch
10591: ,pa_proj_elements ppe5
10592: ,pa_proj_element_versions ppv5
10593: ,per_all_people_f papf

Line 11417: FROM pa_proj_elem_ver_structure ppvs

11413: ,l_check_edit_task_ok
11414: -- End of Bug Fix 5611634.
11415: ,nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0) - (nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)) PLANNED_BASELINE_EFFORT_VAR -- Added for bug 5090355
11416: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
11417: FROM pa_proj_elem_ver_structure ppvs
11418: ,pa_proj_elem_ver_schedule ppvsch
11419: ,pa_proj_elements ppe5
11420: ,pa_proj_element_versions ppv5
11421: ,per_all_people_f papf

Line 12341: FROM pa_proj_elem_ver_structure ppvs

12337: ,l_check_edit_task_ok
12338: -- End of Bug Fix 5611634.
12339: ,nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0) - (nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)) PLANNED_BASELINE_EFFORT_VAR -- Added for bug 5090355
12340: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
12341: FROM pa_proj_elem_ver_structure ppvs
12342: ,pa_proj_elem_ver_schedule ppvsch
12343: ,pa_proj_elements ppe5
12344: ,pa_proj_element_versions ppv5
12345: ,per_all_people_f papf

Line 13137: FROM pa_proj_elem_ver_structure ppvs

13133: ,l_check_edit_task_ok
13134: -- End of Bug Fix 5611634.
13135: ,nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0) - (nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)) PLANNED_BASELINE_EFFORT_VAR -- Added for bug 5090355
13136: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
13137: FROM pa_proj_elem_ver_structure ppvs
13138: ,pa_proj_elem_ver_schedule ppvsch
13139: ,pa_proj_elements ppe5
13140: ,pa_proj_element_versions ppv5
13141: ,per_all_people_f papf

Line 13934: FROM pa_proj_elem_ver_structure ppvs

13930: ,l_check_edit_task_ok
13931: -- End of Bug Fix 5611634.
13932: ,nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0) - (nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)) PLANNED_BASELINE_EFFORT_VAR -- Added for bug 5090355
13933: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
13934: FROM pa_proj_elem_ver_structure ppvs
13935: ,pa_proj_elem_ver_schedule ppvsch
13936: ,pa_proj_elements ppe5
13937: ,pa_proj_element_versions ppv5
13938: ,per_all_people_f papf