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_RELATIONSHIP_UTILS

Line 1282: ,DECODE(l_d_lines_exist_flag,'Y',PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id),NULL) Predecessors

1278: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
1279: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
1280: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
1281: -- Bug 6156686
1282: ,DECODE(l_d_lines_exist_flag,'Y',PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id),NULL) Predecessors
1283: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
1284: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
1285: ) percent_Spent_Effort
1286: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 1859: ,DECODE(l_d_lines_exist_flag,'Y',PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id),NULL) Predecessors

1855: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
1856: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
1857: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
1858: -- Bug 6156686
1859: ,DECODE(l_d_lines_exist_flag,'Y',PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id),NULL) Predecessors
1860: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
1861: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
1862: ) percent_Spent_Effort
1863: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 2672: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

2668: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
2669: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
2670: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
2671: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
2672: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
2673: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
2674: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
2675: ) percent_Spent_Effort
2676: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 3252: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

3248: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
3249: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
3250: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
3251: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
3252: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
3253: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
3254: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
3255: ) percent_Spent_Effort
3256: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 4127: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

4123: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
4124: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
4125: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
4126: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
4127: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
4128: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
4129: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
4130: ) percent_Spent_Effort
4131: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 4702: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

4698: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
4699: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
4700: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
4701: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
4702: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
4703: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
4704: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
4705: ) percent_Spent_Effort
4706: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 5694: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

5690: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
5691: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
5692: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
5693: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
5694: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
5695: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
5696: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
5697: ) percent_Spent_Effort
5698: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 6520: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

6516: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
6517: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
6518: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
6519: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
6520: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
6521: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
6522: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
6523: ) percent_Spent_Effort
6524: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 7347: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

7343: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
7344: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
7345: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
7346: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
7347: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
7348: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
7349: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
7350: ) percent_Spent_Effort
7351: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 8333: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv1.element_version_id) Predecessors

8329: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
8330: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
8331: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
8332: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
8333: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv1.element_version_id) Predecessors
8334: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
8335: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
8336: ) percent_Spent_Effort
8337: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 8818: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv1.element_version_id) Predecessors

8814: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
8815: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
8816: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
8817: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
8818: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv1.element_version_id) Predecessors
8819: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
8820: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
8821: ) percent_Spent_Effort
8822: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 9326: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv1.element_version_id) Predecessors

9322: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
9323: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
9324: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
9325: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
9326: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv1.element_version_id) Predecessors
9327: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
9328: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
9329: ) percent_Spent_Effort
9330: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 10237: ,null --PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

10233: ,null --pfxat.prj_brdn_cost
10234: ,null --NVL(pfxat.prj_brdn_cost,0)
10235: ,nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0) Actual_Effort
10236: ,NVL(ppru.eqpmt_act_effort_to_date,0)
10237: ,null --PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
10238: ,null --PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
10239: -- (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
10240: -- ) percent_Spent_Effort
10241: ,null --PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 10996: ,null --PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

10992: ,null --pfxat.prj_brdn_cost
10993: ,null --NVL(pfxat.prj_brdn_cost,0)
10994: ,nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0) Actual_Effort
10995: ,NVL(ppru.eqpmt_act_effort_to_date,0)
10996: ,null --PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
10997: ,null --PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
10998: -- (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
10999: -- ) percent_Spent_Effort
11000: ,null --PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 11812: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

11808: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
11809: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
11810: Actual_Effort -- Fix for Bug # 4319171.
11811: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
11812: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
11813: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
11814: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
11815: ) percent_Spent_Effort
11816: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 12640: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

12636: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
12637: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
12638: Actual_Effort -- Fix for Bug # 4319171.
12639: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
12640: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
12641: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
12642: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
12643: ) percent_Spent_Effort
12644: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 13469: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

13465: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
13466: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
13467: Actual_Effort -- Fix for Bug # 4319171.
13468: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
13469: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
13470: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
13471: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
13472: ) percent_Spent_Effort
13473: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 14433: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

14429: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
14430: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
14431: Actual_Effort -- Fix for Bug # 4319171.
14432: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
14433: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
14434: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
14435: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
14436: ) percent_Spent_Effort
14437: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 15230: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

15226: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
15227: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
15228: Actual_Effort -- Fix for Bug # 4319171.
15229: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
15230: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
15231: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
15232: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
15233: ) percent_Spent_Effort
15234: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 16028: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

16024: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
16025: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
16026: Actual_Effort -- Fix for Bug # 4319171.
16027: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
16028: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
16029: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
16030: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
16031: ) percent_Spent_Effort
16032: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)