APPS.PA_PROJ_STRUCTURE_PUB dependencies on PA_PROJ_STRUC_MAPPING_UTILS

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

1469: ,0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
1470: , (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))
1471: ,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
1472: -- Bug Fix 5150944. NAMBURI
1473: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
1474: ,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
1475: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
1476: ,pt.gen_etc_source_code
1477: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)

Line 1474: ,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

1470: , (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))
1471: ,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
1472: -- Bug Fix 5150944. NAMBURI
1473: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
1474: ,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
1475: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
1476: ,pt.gen_etc_source_code
1477: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
1478: ,ppe.wf_item_type

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

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

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

2046: ,0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
2047: , (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))
2048: ,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
2049: -- Bug Fix 5150944. NAMBURI
2050: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
2051: ,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
2052: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
2053: ,pt.gen_etc_source_code
2054: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)

Line 2051: ,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

2047: , (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))
2048: ,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
2049: -- Bug Fix 5150944. NAMBURI
2050: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
2051: ,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
2052: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
2053: ,pt.gen_etc_source_code
2054: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
2055: ,ppe.wf_item_type

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

2055: ,ppe.wf_item_type
2056: ,ppe.wf_process
2057: ,ppe.wf_start_lead_days
2058: ,ppe.enable_wf_flag
2059: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
2060: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
2061: , ppru.ppl_etc_cost_pc
2062: , ppru.eqpmt_etc_cost_pc
2063: , ppru.oth_etc_cost_pc

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

2868: ,0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
2869: , (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))
2870: ,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
2871: -- Bug Fix 5150944. NAMBURI
2872: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
2873: ,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
2874: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
2875: ,pt.gen_etc_source_code
2876: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)

Line 2873: ,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

2869: , (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))
2870: ,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
2871: -- Bug Fix 5150944. NAMBURI
2872: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
2873: ,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
2874: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
2875: ,pt.gen_etc_source_code
2876: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
2877: ,ppe.wf_item_type

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

2877: ,ppe.wf_item_type
2878: ,ppe.wf_process
2879: ,ppe.wf_start_lead_days
2880: ,ppe.enable_wf_flag
2881: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
2882: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
2883: , ppru.ppl_etc_cost_pc
2884: , ppru.eqpmt_etc_cost_pc
2885: , ppru.oth_etc_cost_pc

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

3448: ,0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
3449: , (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))
3450: ,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
3451: -- Bug Fix 5150944. NAMBURI
3452: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
3453: ,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
3454: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
3455: ,pt.gen_etc_source_code
3456: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)

Line 3453: ,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

3449: , (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))
3450: ,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
3451: -- Bug Fix 5150944. NAMBURI
3452: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
3453: ,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
3454: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
3455: ,pt.gen_etc_source_code
3456: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
3457: ,ppe.wf_item_type

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

3457: ,ppe.wf_item_type
3458: ,ppe.wf_process
3459: ,ppe.wf_start_lead_days
3460: ,ppe.enable_wf_flag
3461: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
3462: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
3463: , ppru.ppl_etc_cost_pc
3464: , ppru.eqpmt_etc_cost_pc
3465: , ppru.oth_etc_cost_pc

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

4318: ,0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
4319: , (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))
4320: ,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
4321: -- Bug Fix 5150944. NAMBURI
4322: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
4323: ,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
4324: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
4325: ,pt.gen_etc_source_code
4326: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)

Line 4323: ,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

4319: , (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))
4320: ,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
4321: -- Bug Fix 5150944. NAMBURI
4322: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
4323: ,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
4324: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
4325: ,pt.gen_etc_source_code
4326: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
4327: ,ppe.wf_item_type

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

4327: ,ppe.wf_item_type
4328: ,ppe.wf_process
4329: ,ppe.wf_start_lead_days
4330: ,ppe.enable_wf_flag
4331: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
4332: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
4333: , ppru.ppl_etc_cost_pc
4334: , ppru.eqpmt_etc_cost_pc
4335: , ppru.oth_etc_cost_pc

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

4893: ,0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
4894: , (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))
4895: ,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
4896: -- Bug Fix 5150944. NAMBURI
4897: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
4898: ,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
4899: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
4900: ,pt.gen_etc_source_code
4901: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)

Line 4898: ,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

4894: , (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))
4895: ,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
4896: -- Bug Fix 5150944. NAMBURI
4897: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
4898: ,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
4899: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
4900: ,pt.gen_etc_source_code
4901: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
4902: ,ppe.wf_item_type

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

4902: ,ppe.wf_item_type
4903: ,ppe.wf_process
4904: ,ppe.wf_start_lead_days
4905: ,ppe.enable_wf_flag
4906: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
4907: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
4908: , ppru.ppl_etc_cost_pc
4909: , ppru.eqpmt_etc_cost_pc
4910: , ppru.oth_etc_cost_pc

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

5924: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
5925: , (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)),
5926: 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
5927: -- Bug Fix 5150944. NAMBURI
5928: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
5929: ,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
5930: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
5931: ,pt.gen_etc_source_code
5932: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)

Line 5929: ,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

5925: , (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)),
5926: 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
5927: -- Bug Fix 5150944. NAMBURI
5928: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
5929: ,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
5930: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
5931: ,pt.gen_etc_source_code
5932: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
5933: ,ppe.wf_item_type

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

5933: ,ppe.wf_item_type
5934: ,ppe.wf_process
5935: ,ppe.wf_start_lead_days
5936: ,ppe.enable_wf_flag
5937: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
5938: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
5939: , ppru.ppl_etc_cost_pc
5940: , ppru.eqpmt_etc_cost_pc
5941: , ppru.oth_etc_cost_pc

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

6750: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
6751: , (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)),
6752: 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
6753: -- Bug Fix 5150944. NAMBURI
6754: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
6755: ,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
6756: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
6757: ,pt.gen_etc_source_code
6758: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)

Line 6755: ,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

6751: , (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)),
6752: 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
6753: -- Bug Fix 5150944. NAMBURI
6754: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
6755: ,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
6756: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
6757: ,pt.gen_etc_source_code
6758: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
6759: ,ppe.wf_item_type

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

6759: ,ppe.wf_item_type
6760: ,ppe.wf_process
6761: ,ppe.wf_start_lead_days
6762: ,ppe.enable_wf_flag
6763: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
6764: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
6765: , ppru.ppl_etc_cost_pc
6766: , ppru.eqpmt_etc_cost_pc
6767: , ppru.oth_etc_cost_pc

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

7577: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
7578: , (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)),
7579: 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
7580: -- Bug Fix 5150944. NAMBURI
7581: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
7582: ,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
7583: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
7584: ,pt.gen_etc_source_code
7585: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)

Line 7582: ,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

7578: , (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)),
7579: 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
7580: -- Bug Fix 5150944. NAMBURI
7581: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
7582: ,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
7583: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
7584: ,pt.gen_etc_source_code
7585: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
7586: ,ppe.wf_item_type

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

7586: ,ppe.wf_item_type
7587: ,ppe.wf_process
7588: ,ppe.wf_start_lead_days
7589: ,ppe.enable_wf_flag
7590: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
7591: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
7592: , ppru.ppl_etc_cost_pc
7593: , ppru.eqpmt_etc_cost_pc
7594: , ppru.oth_etc_cost_pc

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

8523: ,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)),
8524: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
8525: , (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)),
8526: 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
8527: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv1.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
8528: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
8529: ,to_char ( null )
8530: ,to_char ( null )
8531: ,ppe.wf_item_type

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

8531: ,ppe.wf_item_type
8532: ,ppe.wf_process
8533: ,ppe.wf_start_lead_days
8534: ,ppe.enable_wf_flag
8535: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv1.element_version_id,ppa.structure_sharing_code)
8536: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
8537: , ppru.ppl_etc_cost_pc
8538: , ppru.eqpmt_etc_cost_pc
8539: , ppru.oth_etc_cost_pc

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

9014: ,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)),
9015: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
9016: , (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)),
9017: 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
9018: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv1.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
9019: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
9020: ,to_char ( null )
9021: ,to_char ( null )
9022: ,ppe.wf_item_type

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

9022: ,ppe.wf_item_type
9023: ,ppe.wf_process
9024: ,ppe.wf_start_lead_days
9025: ,ppe.enable_wf_flag
9026: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv1.element_version_id,ppa.structure_sharing_code)
9027: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
9028: , ppru.ppl_etc_cost_pc
9029: , ppru.eqpmt_etc_cost_pc
9030: , ppru.oth_etc_cost_pc

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

9522: ,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)),
9523: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
9524: , (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)),
9525: 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
9526: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv1.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
9527: ,PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
9528: ,to_char ( null )
9529: ,to_char ( null )
9530: ,ppe.wf_item_type

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

9530: ,ppe.wf_item_type
9531: ,ppe.wf_process
9532: ,ppe.wf_start_lead_days
9533: ,ppe.enable_wf_flag
9534: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv1.element_version_id,ppa.structure_sharing_code)
9535: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
9536: , ppru.ppl_etc_cost_pc
9537: , ppru.eqpmt_etc_cost_pc
9538: , ppru.oth_etc_cost_pc

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

10357: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
10358: , (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)),
10359: 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
10360: -- Bug Fix 5150944. NAMBURI
10361: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
10362: ,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
10363: ,null --PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
10364: ,pt.gen_etc_source_code
10365: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)

Line 10362: ,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

10358: , (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)),
10359: 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
10360: -- Bug Fix 5150944. NAMBURI
10361: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
10362: ,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
10363: ,null --PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
10364: ,pt.gen_etc_source_code
10365: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
10366: ,ppe.wf_item_type

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

10366: ,ppe.wf_item_type
10367: ,ppe.wf_process
10368: ,ppe.wf_start_lead_days
10369: ,ppe.enable_wf_flag
10370: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
10371: ,null --pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
10372: -- ,ppru.ppl_etc_cost_pc
10373: -- ,ppru.eqpmt_etc_cost_pc
10374: -- ,ppru.oth_etc_cost_pc

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

11117: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
11118: , (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)),
11119: 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
11120: -- Bug Fix 5150944. NAMBURI
11121: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
11122: ,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
11123: ,to_char(null)--PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
11124: ,pt.gen_etc_source_code
11125: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)

Line 11122: ,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

11118: , (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)),
11119: 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
11120: -- Bug Fix 5150944. NAMBURI
11121: -- ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID(ppv.element_version_id,ppa.structure_sharing_code) Mapped_Financial_Task
11122: ,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
11123: ,to_char(null)--PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
11124: ,pt.gen_etc_source_code
11125: ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
11126: ,ppe.wf_item_type

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

11126: ,ppe.wf_item_type
11127: ,ppe.wf_process
11128: ,ppe.wf_start_lead_days
11129: ,ppe.enable_wf_flag
11130: ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
11131: ,null --pa_progress_utils.sum_etc_values(pfxat.prj_brdn_cost
11132: -- ,ppru.ppl_etc_cost_pc
11133: -- ,ppru.eqpmt_etc_cost_pc
11134: -- ,ppru.oth_etc_cost_pc

Line 12062: ,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

12058: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
12059: , (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)),
12060: 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
12061: ---------------------------------------------------------------------
12062: ,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
12063: ,null -- not used in VO PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
12064: ,null -- not used in VO pt.gen_etc_source_code
12065: ,null -- not used in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
12066: ,ppe.wf_item_type

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

12066: ,ppe.wf_item_type
12067: ,ppe.wf_process
12068: ,ppe.wf_start_lead_days
12069: ,ppe.enable_wf_flag
12070: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
12071: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
12072: , ppru.ppl_etc_cost_pc
12073: , ppru.eqpmt_etc_cost_pc
12074: , ppru.oth_etc_cost_pc

Line 12890: ,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

12886: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
12887: , (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)),
12888: 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
12889: ---------------------------------------------------------------------
12890: ,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
12891: ,null -- not used in VO PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
12892: ,null -- not used in VO pt.gen_etc_source_code
12893: ,null -- not used in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
12894: ,ppe.wf_item_type

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

12894: ,ppe.wf_item_type
12895: ,ppe.wf_process
12896: ,ppe.wf_start_lead_days
12897: ,ppe.enable_wf_flag
12898: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
12899: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
12900: , ppru.ppl_etc_cost_pc
12901: , ppru.eqpmt_etc_cost_pc
12902: , ppru.oth_etc_cost_pc

Line 13719: ,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

13715: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
13716: , (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)),
13717: 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
13718: ---------------------------------------------------------------------
13719: ,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
13720: ,null -- not used in VO PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
13721: ,null -- not used in VO pt.gen_etc_source_code
13722: ,null -- not used in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
13723: ,ppe.wf_item_type

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

13723: ,ppe.wf_item_type
13724: ,ppe.wf_process
13725: ,ppe.wf_start_lead_days
13726: ,ppe.enable_wf_flag
13727: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
13728: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
13729: , ppru.ppl_etc_cost_pc
13730: , ppru.eqpmt_etc_cost_pc
13731: , ppru.oth_etc_cost_pc

Line 14644: ,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

14640: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
14641: , (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)),
14642: 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
14643: ---------------------------------------------------------------------
14644: ,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
14645: ,null -- not used in VO PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
14646: ,null -- not used in VO pt.gen_etc_source_code
14647: ,null -- not used in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
14648: ,ppe.wf_item_type

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

14648: ,ppe.wf_item_type
14649: ,ppe.wf_process
14650: ,ppe.wf_start_lead_days
14651: ,ppe.enable_wf_flag
14652: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
14653: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
14654: , ppru.ppl_etc_cost_pc
14655: , ppru.eqpmt_etc_cost_pc
14656: , ppru.oth_etc_cost_pc

Line 15441: ,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

15437: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
15438: , (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)),
15439: 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
15440: ---------------------------------------------------------------------
15441: ,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
15442: ,null -- not used in VO PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
15443: ,null -- not used in VO pt.gen_etc_source_code
15444: ,null -- not used in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
15445: ,ppe.wf_item_type

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

15445: ,ppe.wf_item_type
15446: ,ppe.wf_process
15447: ,ppe.wf_start_lead_days
15448: ,ppe.enable_wf_flag
15449: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
15450: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
15451: , ppru.ppl_etc_cost_pc
15452: , ppru.eqpmt_etc_cost_pc
15453: , ppru.oth_etc_cost_pc

Line 16239: ,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

16235: 0,1,(nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0))))
16236: , (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)),
16237: 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
16238: ---------------------------------------------------------------------
16239: ,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
16240: ,null -- not used in VO PA_DELIVERABLE_UTILS.GET_ASSOCIATED_DELIVERABLES (ppe.proj_element_id)
16241: ,null -- not used in VO pt.gen_etc_source_code
16242: ,null -- not used in VO PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('PA_TASK_LVL_ETC_SRC', pt.gen_etc_source_code)
16243: ,ppe.wf_item_type

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

16243: ,ppe.wf_item_type
16244: ,ppe.wf_process
16245: ,ppe.wf_start_lead_days
16246: ,ppe.enable_wf_flag
16247: ,null -- not used in VO PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME(ppv.element_version_id,ppa.structure_sharing_code)
16248: ,pa_progress_utils.calc_etc(pfxat.prj_brdn_cost
16249: , ppru.ppl_etc_cost_pc
16250: , ppru.eqpmt_etc_cost_pc
16251: , ppru.oth_etc_cost_pc