DBA Data[Home] [Help]

APPS.PA_PROJ_STRUCTURE_PUB dependencies on PA_PROJ_STRUC_MAPPING_UTILS

Line 1472: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task

1468: ,0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
1469: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))
1470: ,0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
1471: -- Bug Fix 5150944. NAMBURI
1472: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
1473: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
1474: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
1475: ,pt.gen_etc_source_code
1476: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)

Line 1473: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task

1469: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))
1470: ,0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
1471: -- Bug Fix 5150944. NAMBURI
1472: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
1473: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
1474: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
1475: ,pt.gen_etc_source_code
1476: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
1477: ,ppe.wf_item_type

Line 1481: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)

1477: ,ppe.wf_item_type
1478: ,ppe.wf_process
1479: ,ppe.wf_start_lead_days
1480: ,ppe.enable_wf_flag
1481: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
1482: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
1483: , ppru.ppl_etc_cost_pc
1484: , ppru.eqpmt_etc_cost_pc
1485: , ppru.oth_etc_cost_pc

Line 2287: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task

2283: ,0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
2284: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))
2285: ,0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
2286: -- Bug Fix 5150944. NAMBURI
2287: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
2288: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
2289: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
2290: ,pt.gen_etc_source_code
2291: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)

Line 2288: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task

2284: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))
2285: ,0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
2286: -- Bug Fix 5150944. NAMBURI
2287: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
2288: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
2289: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
2290: ,pt.gen_etc_source_code
2291: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
2292: ,ppe.wf_item_type

Line 2296: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)

2292: ,ppe.wf_item_type
2293: ,ppe.wf_process
2294: ,ppe.wf_start_lead_days
2295: ,ppe.enable_wf_flag
2296: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
2297: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
2298: , ppru.ppl_etc_cost_pc
2299: , ppru.eqpmt_etc_cost_pc
2300: , ppru.oth_etc_cost_pc

Line 3145: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task

3141: ,0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
3142: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))
3143: ,0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
3144: -- Bug Fix 5150944. NAMBURI
3145: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
3146: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
3147: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
3148: ,pt.gen_etc_source_code
3149: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)

Line 3146: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task

3142: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))
3143: ,0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
3144: -- Bug Fix 5150944. NAMBURI
3145: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
3146: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
3147: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
3148: ,pt.gen_etc_source_code
3149: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
3150: ,ppe.wf_item_type

Line 3154: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)

3150: ,ppe.wf_item_type
3151: ,ppe.wf_process
3152: ,ppe.wf_start_lead_days
3153: ,ppe.enable_wf_flag
3154: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
3155: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
3156: , ppru.ppl_etc_cost_pc
3157: , ppru.eqpmt_etc_cost_pc
3158: , ppru.oth_etc_cost_pc

Line 4116: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task

4112: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
4113: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
4114: 0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
4115: -- Bug Fix 5150944. NAMBURI
4116: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
4117: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
4118: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
4119: ,pt.gen_etc_source_code
4120: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)

Line 4117: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task

4113: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
4114: 0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
4115: -- Bug Fix 5150944. NAMBURI
4116: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
4117: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
4118: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
4119: ,pt.gen_etc_source_code
4120: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
4121: ,ppe.wf_item_type

Line 4125: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)

4121: ,ppe.wf_item_type
4122: ,ppe.wf_process
4123: ,ppe.wf_start_lead_days
4124: ,ppe.enable_wf_flag
4125: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
4126: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
4127: , ppru.ppl_etc_cost_pc
4128: , ppru.eqpmt_etc_cost_pc
4129: , ppru.oth_etc_cost_pc

Line 4941: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task

4937: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
4938: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
4939: 0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
4940: -- Bug Fix 5150944. NAMBURI
4941: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
4942: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
4943: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
4944: ,pt.gen_etc_source_code
4945: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)

Line 4942: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task

4938: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
4939: 0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
4940: -- Bug Fix 5150944. NAMBURI
4941: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
4942: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
4943: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
4944: ,pt.gen_etc_source_code
4945: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
4946: ,ppe.wf_item_type

Line 4950: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)

4946: ,ppe.wf_item_type
4947: ,ppe.wf_process
4948: ,ppe.wf_start_lead_days
4949: ,ppe.enable_wf_flag
4950: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
4951: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
4952: , ppru.ppl_etc_cost_pc
4953: , ppru.eqpmt_etc_cost_pc
4954: , ppru.oth_etc_cost_pc

Line 5767: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task

5763: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
5764: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
5765: 0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
5766: -- Bug Fix 5150944. NAMBURI
5767: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
5768: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
5769: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
5770: ,pt.gen_etc_source_code
5771: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)

Line 5768: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task

5764: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
5765: 0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
5766: -- Bug Fix 5150944. NAMBURI
5767: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
5768: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
5769: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
5770: ,pt.gen_etc_source_code
5771: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
5772: ,ppe.wf_item_type

Line 5776: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)

5772: ,ppe.wf_item_type
5773: ,ppe.wf_process
5774: ,ppe.wf_start_lead_days
5775: ,ppe.enable_wf_flag
5776: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
5777: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
5778: , ppru.ppl_etc_cost_pc
5779: , ppru.eqpmt_etc_cost_pc
5780: , ppru.oth_etc_cost_pc

Line 6712: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv1.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task

6708: ,round(decode(ppru.task_wt_basis_code,'EFFORT',(nvl(ppru.earned_value,0)/decode((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
6709: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
6710: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
6711: 0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
6712: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv1.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
6713: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
6714: ,to_char ( null )
6715: ,to_char ( null )
6716: ,ppe.wf_item_type

Line 6720: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv1.element_version_id,ppa.structure_sharing_code)

6716: ,ppe.wf_item_type
6717: ,ppe.wf_process
6718: ,ppe.wf_start_lead_days
6719: ,ppe.enable_wf_flag
6720: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv1.element_version_id,ppa.structure_sharing_code)
6721: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
6722: , ppru.ppl_etc_cost_pc
6723: , ppru.eqpmt_etc_cost_pc
6724: , ppru.oth_etc_cost_pc

Line 7202: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv1.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task

7198: ,round(decode(ppru.task_wt_basis_code,'EFFORT',(nvl(ppru.earned_value,0)/decode((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
7199: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
7200: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
7201: 0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
7202: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv1.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
7203: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
7204: ,to_char ( null )
7205: ,to_char ( null )
7206: ,ppe.wf_item_type

Line 7210: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv1.element_version_id,ppa.structure_sharing_code)

7206: ,ppe.wf_item_type
7207: ,ppe.wf_process
7208: ,ppe.wf_start_lead_days
7209: ,ppe.enable_wf_flag
7210: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv1.element_version_id,ppa.structure_sharing_code)
7211: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
7212: , ppru.ppl_etc_cost_pc
7213: , ppru.eqpmt_etc_cost_pc
7214: , ppru.oth_etc_cost_pc

Line 8031: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task

8027: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
8028: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
8029: 0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
8030: -- Bug Fix 5150944. NAMBURI
8031: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
8032: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
8033: ,null --PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
8034: ,pt.gen_etc_source_code
8035: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)

Line 8032: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task

8028: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
8029: 0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
8030: -- Bug Fix 5150944. NAMBURI
8031: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
8032: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
8033: ,null --PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
8034: ,pt.gen_etc_source_code
8035: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
8036: ,ppe.wf_item_type

Line 8040: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)

8036: ,ppe.wf_item_type
8037: ,ppe.wf_process
8038: ,ppe.wf_start_lead_days
8039: ,ppe.enable_wf_flag
8040: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
8041: ,null --pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
8042: -- ,ppru.ppl_etc_cost_pc
8043: -- ,ppru.eqpmt_etc_cost_pc
8044: -- ,ppru.oth_etc_cost_pc

Line 8791: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task

8787: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
8788: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
8789: 0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
8790: -- Bug Fix 5150944. NAMBURI
8791: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
8792: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
8793: ,to_char(null)--PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
8794: ,pt.gen_etc_source_code
8795: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)

Line 8792: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task

8788: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
8789: 0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
8790: -- Bug Fix 5150944. NAMBURI
8791: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
8792: ,DECODE(ppa.structure_sharing_code,'SPLIT_MAPPING',PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code)) Mapped_Financial_Task
8793: ,to_char(null)--PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
8794: ,pt.gen_etc_source_code
8795: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
8796: ,ppe.wf_item_type

Line 8800: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)

8796: ,ppe.wf_item_type
8797: ,ppe.wf_process
8798: ,ppe.wf_start_lead_days
8799: ,ppe.enable_wf_flag
8800: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
8801: ,null --pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
8802: -- ,ppru.ppl_etc_cost_pc
8803: -- ,ppru.eqpmt_etc_cost_pc
8804: -- ,ppru.oth_etc_cost_pc

Line 9731: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task

9727: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
9728: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
9729: 0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
9730: ---------------------------------------------------------------------
9731: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
9732: ,null -- not used in VO PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
9733: ,null -- not used in VO pt.gen_etc_source_code
9734: ,null -- not used in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
9735: ,ppe.wf_item_type

Line 9739: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)

9735: ,ppe.wf_item_type
9736: ,ppe.wf_process
9737: ,ppe.wf_start_lead_days
9738: ,ppe.enable_wf_flag
9739: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
9740: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
9741: , ppru.ppl_etc_cost_pc
9742: , ppru.eqpmt_etc_cost_pc
9743: , ppru.oth_etc_cost_pc

Line 10558: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task

10554: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
10555: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
10556: 0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
10557: ---------------------------------------------------------------------
10558: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
10559: ,null -- not used in VO PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
10560: ,null -- not used in VO pt.gen_etc_source_code
10561: ,null -- not used in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
10562: ,ppe.wf_item_type

Line 10566: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)

10562: ,ppe.wf_item_type
10563: ,ppe.wf_process
10564: ,ppe.wf_start_lead_days
10565: ,ppe.enable_wf_flag
10566: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
10567: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
10568: , ppru.ppl_etc_cost_pc
10569: , ppru.eqpmt_etc_cost_pc
10570: , ppru.oth_etc_cost_pc

Line 11386: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task

11382: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
11383: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
11384: 0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
11385: ---------------------------------------------------------------------
11386: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
11387: ,null -- not used in VO PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
11388: ,null -- not used in VO pt.gen_etc_source_code
11389: ,null -- not used in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
11390: ,ppe.wf_item_type

Line 11394: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)

11390: ,ppe.wf_item_type
11391: ,ppe.wf_process
11392: ,ppe.wf_start_lead_days
11393: ,ppe.enable_wf_flag
11394: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
11395: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
11396: , ppru.ppl_etc_cost_pc
11397: , ppru.eqpmt_etc_cost_pc
11398: , ppru.oth_etc_cost_pc

Line 12310: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task

12306: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
12307: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
12308: 0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
12309: ---------------------------------------------------------------------
12310: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
12311: ,null -- not used in VO PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
12312: ,null -- not used in VO pt.gen_etc_source_code
12313: ,null -- not used in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
12314: ,ppe.wf_item_type

Line 12318: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)

12314: ,ppe.wf_item_type
12315: ,ppe.wf_process
12316: ,ppe.wf_start_lead_days
12317: ,ppe.enable_wf_flag
12318: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
12319: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
12320: , ppru.ppl_etc_cost_pc
12321: , ppru.eqpmt_etc_cost_pc
12322: , ppru.oth_etc_cost_pc

Line 13106: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task

13102: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
13103: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
13104: 0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
13105: ---------------------------------------------------------------------
13106: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
13107: ,null -- not used in VO PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
13108: ,null -- not used in VO pt.gen_etc_source_code
13109: ,null -- not used in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
13110: ,ppe.wf_item_type

Line 13114: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)

13110: ,ppe.wf_item_type
13111: ,ppe.wf_process
13112: ,ppe.wf_start_lead_days
13113: ,ppe.enable_wf_flag
13114: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
13115: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
13116: , ppru.ppl_etc_cost_pc
13117: , ppru.eqpmt_etc_cost_pc
13118: , ppru.oth_etc_cost_pc

Line 13903: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task

13899: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
13900: , (nvl(ppru.earned_value,0)/decode((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0)),
13901: 0,1, (nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)+nvl(ppru.eqpmt_act_cost_to_date_pc,0))))),2) cost_performance_index
13902: ---------------------------------------------------------------------
13903: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
13904: ,null -- not used in VO PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
13905: ,null -- not used in VO pt.gen_etc_source_code
13906: ,null -- not used in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
13907: ,ppe.wf_item_type

Line 13911: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)

13907: ,ppe.wf_item_type
13908: ,ppe.wf_process
13909: ,ppe.wf_start_lead_days
13910: ,ppe.enable_wf_flag
13911: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
13912: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
13913: , ppru.ppl_etc_cost_pc
13914: , ppru.eqpmt_etc_cost_pc
13915: , ppru.oth_etc_cost_pc