[Home] [Help]
5695: -- Bug 3627315 : In case of Financial Structure, it should select normal(without BASE) columns from PJI table
5696: -- Anyhow it is baselined plan version
5697: -- SELECT decode(p_task_weight_method, 'EFFORT',nvl(BASE_LABOR_HOURS,0)+nvl(BASE_EQUIP_HOURS,0), PRJ_BASE_BRDN_COST)
5698: SELECT
5699: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
5700: decode(p_task_weight_method, 'EFFORT',nvl(LABOR_HOURS,0)+nvl(EQUIPMENT_HOURS,0), PRJ_BRDN_COST)
5701: INTO l_value
5702: FROM PJI_FM_XBS_ACCUM_TMP1
5703: WHERE project_id = p_project_id
5698: SELECT
5699: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
5700: decode(p_task_weight_method, 'EFFORT',nvl(LABOR_HOURS,0)+nvl(EQUIPMENT_HOURS,0), PRJ_BRDN_COST)
5701: INTO l_value
5702: FROM PJI_FM_XBS_ACCUM_TMP1
5703: WHERE project_id = p_project_id
5704: AND project_element_id = p_proj_element_id
5705: AND PLAN_VERSION_ID = l_plan_version_id
5706: AND txn_currency_code is null --bug no. 3646988
5722: nvl(BASE_EQUIP_HOURS,nvl(EQUIPMENT_HOURS,0)),
5723: NVL(PRJ_BASE_BRDN_COST,nvl(PRJ_BRDN_COST,0))) --if base is not avilable then select the published planned. bug 3781922*/
5724: -- Bug 4493105 : Added p_program_flag decode
5725: SELECT
5726: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
5727: decode(p_task_weight_method, 'EFFORT', decode(p_program_flag, 'N', nvl(P_BASE_LBR_HOURS, nvl(P_LPB_LBR_HOURS, nvl(P_LBR_HOURS,0)))+
5728: nvl(P_BASE_EQP_HOURS, nvl(P_LPB_EQP_HOURS, nvl(P_EQP_HOURS,0))),
5729: nvl(BASE_LABOR_HOURS, nvl(LPB_LABOR_HOURS, nvl(LABOR_HOURS,0)))+
5730: nvl(BASE_EQUIP_HOURS, nvl(LPB_EQUIP_HOURS, nvl(EQUIPMENT_HOURS,0)))
5733: ,NVL(PRJ_BASE_BRDN_COST, nvl(PRJ_LPB_BRDN_COST, nvl(PRJ_BRDN_COST,0)))
5734: )
5735: ) --if base is not avilable then select the published planned. bug 3781922
5736: INTO l_value
5737: FROM PJI_FM_XBS_ACCUM_TMP1
5738: WHERE project_id = p_project_id
5739: AND struct_version_id = p_structure_version_id
5740: AND project_element_id = p_proj_element_id
5741: AND txn_currency_code is null --bug no. 3646988
5743:
5744: else
5745: -- Bug 4493105 : Added p_program_flag decode
5746: SELECT
5747: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
5748: decode(p_task_weight_method, 'EFFORT',decode(p_program_flag,'N',nvl(P_LBR_HOURS,0)+nvl(P_EQP_HOURS,0)
5749: ,nvl(LABOR_HOURS,0)+nvl(EQUIPMENT_HOURS,0))
5750: , decode(p_program_flag,'N',P_BRDN_COST,PRJ_BRDN_COST))
5751: INTO l_value
5748: decode(p_task_weight_method, 'EFFORT',decode(p_program_flag,'N',nvl(P_LBR_HOURS,0)+nvl(P_EQP_HOURS,0)
5749: ,nvl(LABOR_HOURS,0)+nvl(EQUIPMENT_HOURS,0))
5750: , decode(p_program_flag,'N',P_BRDN_COST,PRJ_BRDN_COST))
5751: INTO l_value
5752: FROM PJI_FM_XBS_ACCUM_TMP1
5753: WHERE project_id = p_project_id
5754: AND struct_version_id = p_structure_version_id
5755: AND project_element_id = p_proj_element_id
5756: AND txn_currency_code is null --bug no. 3646988
6580: and pppa.structure_type = p_structure_type;
6581:
6582: cursor c2 (p_project_id NUMBER, p_proj_element_id NUMBER, p_structure_version_id NUMBER) is
6583: select
6584: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
6585: nvl(pfxat.BASE_LABOR_HOURS,pfxat.labor_hours) labor_hours
6586: ,nvl(pfxat.BASE_EQUIP_HOURS,pfxat.equipment_hours) equipment_hours
6587: ,nvl(pfxat.PRJ_BASE_BRDN_COST,pfxat.prj_brdn_cost) prj_brdn_cost
6588: from pji_fm_xbs_accum_tmp1 pfxat
6584: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
6585: nvl(pfxat.BASE_LABOR_HOURS,pfxat.labor_hours) labor_hours
6586: ,nvl(pfxat.BASE_EQUIP_HOURS,pfxat.equipment_hours) equipment_hours
6587: ,nvl(pfxat.PRJ_BASE_BRDN_COST,pfxat.prj_brdn_cost) prj_brdn_cost
6588: from pji_fm_xbs_accum_tmp1 pfxat
6589: where pfxat.struct_version_id = p_structure_version_id
6590: and pfxat.project_id = p_project_id
6591: and pfxat.project_element_id = p_proj_element_id
6592: and pfxat.plan_version_id > 0