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 1502: FROM pa_proj_elem_ver_structure ppvs

1498: ,ppru.PROGRESS_ROLLUP_ID
1499: ,ppru.BASE_PERCENT_COMPLETE --Bug 4416432 Issue 2
1500: ,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
1501: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) Planned_Baseline_Finish -- Added for bug 5090355
1502: FROM pa_proj_elem_ver_structure ppvs
1503: --,ra_addresses_all addr
1504: ,HZ_CUST_ACCT_SITES_ALL S
1505: ,HZ_PARTY_SITES PS
1506: ,HZ_LOCATIONS addr

Line 2079: FROM pa_proj_elem_ver_structure ppvs

2075: ,ppru.PROGRESS_ROLLUP_ID
2076: ,ppru.BASE_PERCENT_COMPLETE --Bug 4416432 Issue 2
2077: ,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
2078: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) Planned_Baseline_Finish -- Added for bug 5090355
2079: FROM pa_proj_elem_ver_structure ppvs
2080: --,ra_addresses_all addr
2081: ,HZ_CUST_ACCT_SITES_ALL S
2082: ,HZ_PARTY_SITES PS
2083: ,HZ_LOCATIONS addr

Line 2901: FROM pa_proj_elem_ver_structure ppvs

2897: ,ppru.PROGRESS_ROLLUP_ID
2898: ,ppru.BASE_PERCENT_COMPLETE --Bug 4416432 Issue 2
2899: ,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
2900: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
2901: FROM pa_proj_elem_ver_structure ppvs
2902: --,ra_addresses_all addr
2903: ,HZ_CUST_ACCT_SITES_ALL S
2904: ,HZ_PARTY_SITES PS
2905: ,HZ_LOCATIONS addr

Line 3481: FROM pa_proj_elem_ver_structure ppvs

3477: ,ppru.PROGRESS_ROLLUP_ID
3478: ,ppru.BASE_PERCENT_COMPLETE --Bug 4416432 Issue 2
3479: ,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
3480: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
3481: FROM pa_proj_elem_ver_structure ppvs
3482: --,ra_addresses_all addr
3483: ,HZ_CUST_ACCT_SITES_ALL S
3484: ,HZ_PARTY_SITES PS
3485: ,HZ_LOCATIONS addr

Line 4351: FROM pa_proj_elem_ver_structure ppvs

4347: ,ppru.PROGRESS_ROLLUP_ID
4348: ,ppru.BASE_PERCENT_COMPLETE --Bug 4416432 Issue 2
4349: ,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
4350: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
4351: FROM pa_proj_elem_ver_structure ppvs
4352: --,ra_addresses_all addr
4353: ,HZ_CUST_ACCT_SITES_ALL S
4354: ,HZ_PARTY_SITES PS
4355: ,HZ_LOCATIONS addr

Line 4926: FROM pa_proj_elem_ver_structure ppvs

4922: ,ppru.PROGRESS_ROLLUP_ID
4923: ,ppru.BASE_PERCENT_COMPLETE --Bug 4416432 Issue 2
4924: ,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
4925: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
4926: FROM pa_proj_elem_ver_structure ppvs
4927: --,ra_addresses_all addr
4928: ,HZ_CUST_ACCT_SITES_ALL S
4929: ,HZ_PARTY_SITES PS
4930: ,HZ_LOCATIONS addr

Line 5957: FROM pa_proj_elem_ver_structure ppvs

5953: ,ppru.PROGRESS_ROLLUP_ID
5954: ,ppru.BASE_PERCENT_COMPLETE -- Bug 4416432 Issue 2
5955: ,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
5956: , nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
5957: FROM pa_proj_elem_ver_structure ppvs
5958: --,ra_addresses_all addr
5959: ,HZ_CUST_ACCT_SITES_ALL S
5960: ,HZ_PARTY_SITES PS
5961: ,HZ_LOCATIONS addr

Line 6783: FROM pa_proj_elem_ver_structure ppvs

6779: ,ppru.PROGRESS_ROLLUP_ID
6780: ,ppru.BASE_PERCENT_COMPLETE -- Bug 4416432 Issue 2
6781: ,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
6782: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
6783: FROM pa_proj_elem_ver_structure ppvs
6784: --,ra_addresses_all addr
6785: ,HZ_CUST_ACCT_SITES_ALL S
6786: ,HZ_PARTY_SITES PS
6787: ,HZ_LOCATIONS addr

Line 7610: FROM pa_proj_elem_ver_structure ppvs

7606: ,ppru.PROGRESS_ROLLUP_ID
7607: ,ppru.BASE_PERCENT_COMPLETE -- Bug 4416432 Issue 2
7608: ,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
7609: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
7610: FROM pa_proj_elem_ver_structure ppvs
7611: --,ra_addresses_all addr
7612: ,HZ_CUST_ACCT_SITES_ALL S
7613: ,HZ_PARTY_SITES PS
7614: ,HZ_LOCATIONS addr

Line 8558: pa_proj_elem_ver_structure ppvs

8554: , ppru.BASE_PERCENT_COMPLETE -- Bug 4416432 Issue 2
8555: ,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
8556: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
8557: FROM
8558: pa_proj_elem_ver_structure ppvs
8559: ,pa_proj_elem_ver_schedule ppvsch
8560: ,per_all_people_f papf
8561: ,pa_projects_all ppa
8562: ,pa_page_layouts ppl

Line 9049: pa_proj_elem_ver_structure ppvs

9045: , ppru.BASE_PERCENT_COMPLETE -- Bug 4416432 Issue 2
9046: ,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
9047: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
9048: FROM
9049: pa_proj_elem_ver_structure ppvs
9050: ,pa_proj_elem_ver_schedule ppvsch
9051: ,per_all_people_f papf
9052: ,pa_projects_all ppa
9053: ,pa_page_layouts ppl

Line 9557: pa_proj_elem_ver_structure ppvs

9553: , ppru.BASE_PERCENT_COMPLETE -- Bug 4416432 Issue 2
9554: ,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
9555: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
9556: FROM
9557: pa_proj_elem_ver_structure ppvs
9558: ,pa_proj_elem_ver_schedule ppvsch
9559: ,per_all_people_f papf
9560: ,pa_projects_all ppa
9561: ,pa_page_layouts ppl

Line 10381: FROM pa_proj_elem_ver_structure ppvs

10377: -- ,(nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
10378: -- +nvl(ppru.eqpmt_act_cost_to_date_pc,0)+nvl(ppru.SUBPRJ_OTH_ACT_COST_TO_DT_PC,0)
10379: --+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
10380: ,ppru.PROGRESS_ROLLUP_ID
10381: FROM pa_proj_elem_ver_structure ppvs
10382: --,ra_addresses_all addr
10383: ,HZ_CUST_ACCT_SITES_ALL S
10384: ,HZ_PARTY_SITES PS
10385: ,HZ_LOCATIONS addr

Line 11141: FROM pa_proj_elem_ver_structure ppvs

11137: -- ,(nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)
11138: -- +nvl(ppru.eqpmt_act_cost_to_date_pc,0)+nvl(ppru.SUBPRJ_OTH_ACT_COST_TO_DT_PC,0)
11139: --+nvl(ppru.subprj_ppl_act_cost_pc,0)+nvl(ppru.subprj_eqpmt_act_cost_pc,0)), 'WORKING') ETC_Cost
11140: ,ppru.PROGRESS_ROLLUP_ID
11141: FROM pa_proj_elem_ver_structure ppvs
11142: --,ra_addresses_all addr
11143: ,HZ_CUST_ACCT_SITES_ALL S
11144: ,HZ_PARTY_SITES PS
11145: ,HZ_LOCATIONS addr

Line 12093: FROM pa_proj_elem_ver_structure ppvs

12089: ,l_check_edit_task_ok
12090: -- End of Bug Fix 5611634.
12091: ,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
12092: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
12093: FROM pa_proj_elem_ver_structure ppvs
12094: ,pa_proj_elem_ver_schedule ppvsch
12095: ,pa_proj_elements ppe5
12096: ,pa_proj_element_versions ppv5
12097: ,per_all_people_f papf

Line 12921: FROM pa_proj_elem_ver_structure ppvs

12917: ,l_check_edit_task_ok
12918: -- End of Bug Fix 5611634.
12919: ,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
12920: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
12921: FROM pa_proj_elem_ver_structure ppvs
12922: ,pa_proj_elem_ver_schedule ppvsch
12923: ,pa_proj_elements ppe5
12924: ,pa_proj_element_versions ppv5
12925: ,per_all_people_f papf

Line 13750: FROM pa_proj_elem_ver_structure ppvs

13746: ,l_check_edit_task_ok
13747: -- End of Bug Fix 5611634.
13748: ,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
13749: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
13750: FROM pa_proj_elem_ver_structure ppvs
13751: ,pa_proj_elem_ver_schedule ppvsch
13752: ,pa_proj_elements ppe5
13753: ,pa_proj_element_versions ppv5
13754: ,per_all_people_f papf

Line 14675: FROM pa_proj_elem_ver_structure ppvs

14671: ,l_check_edit_task_ok
14672: -- End of Bug Fix 5611634.
14673: ,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
14674: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
14675: FROM pa_proj_elem_ver_structure ppvs
14676: ,pa_proj_elem_ver_schedule ppvsch
14677: ,pa_proj_elements ppe5
14678: ,pa_proj_element_versions ppv5
14679: ,per_all_people_f papf

Line 15472: FROM pa_proj_elem_ver_structure ppvs

15468: ,l_check_edit_task_ok
15469: -- End of Bug Fix 5611634.
15470: ,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
15471: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
15472: FROM pa_proj_elem_ver_structure ppvs
15473: ,pa_proj_elem_ver_schedule ppvsch
15474: ,pa_proj_elements ppe5
15475: ,pa_proj_element_versions ppv5
15476: ,per_all_people_f papf

Line 16270: FROM pa_proj_elem_ver_structure ppvs

16266: ,l_check_edit_task_ok
16267: -- End of Bug Fix 5611634.
16268: ,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
16269: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
16270: FROM pa_proj_elem_ver_structure ppvs
16271: ,pa_proj_elem_ver_schedule ppvsch
16272: ,pa_proj_elements ppe5
16273: ,pa_proj_element_versions ppv5
16274: ,per_all_people_f papf