[Home] [Help]
12649:
12650: --This cursor retrieves the accumulated amounts for the periods before each task before as of date period
12651: cursor cur_accum_amts_w (p_project_id NUMBER, p_structure_version_id NUMBER, p_baseline_struc_id NUMBER,
12652: p_proj_element_id NUMBER,p_cal_id NUMBER, p_cal_type varchar, p_as_of_date date) is
12653: select /*+ index(PFXAF PJI_FP_XBS_ACCUM_F_N1) */ time_id.proj_element_id proj_element_id -- Fix for Bug # 14169654.
12654: ,time_id.as_of_date as_of_date
12655: ,sum(pfxaf.labor_hrs) labor_hours
12656: ,sum(pfxaf.equipment_hours) equipment_hours
12657: ,sum(pfxaf.brdn_cost) prj_brdn_cost
12654: ,time_id.as_of_date as_of_date
12655: ,sum(pfxaf.labor_hrs) labor_hours
12656: ,sum(pfxaf.equipment_hours) equipment_hours
12657: ,sum(pfxaf.brdn_cost) prj_brdn_cost
12658: from pji_fp_xbs_accum_f pfxaf,
12659: pa_budget_versions pbv,
12660: (
12661: select prog_date.proj_element_id proj_element_id,
12662: prog_date.as_of_date as_of_date,
12700: ,time_id.as_of_date ;
12701:
12702: cursor cur_curr_prd_amts_w (p_project_id NUMBER, p_structure_version_id NUMBER, p_baseline_struc_id NUMBER,
12703: p_proj_element_id NUMBER,p_cal_id NUMBER, p_cal_type varchar, p_as_of_date date) is
12704: select /*+ index(PFXAF PJI_FP_XBS_ACCUM_F_N1) */ pfxaf.project_element_id proj_element_id -- Fix for Bug # 14169654.
12705: ,time_id.pstart_date pstart_date
12706: ,time_id.pend_date pend_date
12707: ,time_id.as_of_date as_of_date
12708: ,pfxaf.labor_hrs labor_hours
12707: ,time_id.as_of_date as_of_date
12708: ,pfxaf.labor_hrs labor_hours
12709: ,pfxaf.equipment_hours equipment_hours
12710: ,pfxaf.brdn_cost prj_brdn_cost
12711: from pji_fp_xbs_accum_f pfxaf,
12712: pa_budget_versions pbv,
12713: (
12714: select prog_date.proj_element_id proj_element_id,
12715: prog_date.as_of_date as_of_date,
12756: -- Latest Published
12757: --This cursor retrieves the accumulated amounts for lastest published the periods before each task before as of date period
12758: cursor cur_accum_amts_l (p_project_id NUMBER, p_structure_version_id NUMBER, p_baseline_struc_id NUMBER,
12759: p_proj_element_id NUMBER,p_cal_id NUMBER, p_cal_type varchar, p_as_of_date date) is
12760: select /*+ index(PFXAF PJI_FP_XBS_ACCUM_F_N1) */ time_id.proj_element_id proj_element_id -- Fix for Bug # 14169654.
12761: ,time_id.as_of_date as_of_date
12762: ,sum(pfxaf.labor_hrs) labor_hours
12763: ,sum(pfxaf.equipment_hours) equipment_hours
12764: ,sum(pfxaf.brdn_cost) prj_brdn_cost
12761: ,time_id.as_of_date as_of_date
12762: ,sum(pfxaf.labor_hrs) labor_hours
12763: ,sum(pfxaf.equipment_hours) equipment_hours
12764: ,sum(pfxaf.brdn_cost) prj_brdn_cost
12765: from pji_fp_xbs_accum_f pfxaf,
12766: pa_budget_versions pbv,
12767: (
12768: select prog_date.proj_element_id proj_element_id,
12769: prog_date.as_of_date as_of_date,
12808: ,time_id.as_of_date ;
12809:
12810: cursor cur_curr_prd_amts_l (p_project_id NUMBER, p_structure_version_id NUMBER, p_baseline_struc_id NUMBER,
12811: p_proj_element_id NUMBER,p_cal_id NUMBER, p_cal_type varchar, p_as_of_date date) is
12812: select /*+ index(PFXAF PJI_FP_XBS_ACCUM_F_N1) */ pfxaf.project_element_id proj_element_id -- Fix for Bug # 14169654.
12813: ,time_id.pstart_date pstart_date
12814: ,time_id.pend_date pend_date
12815: ,time_id.as_of_date as_of_date
12816: ,pfxaf.labor_hrs labor_hours
12815: ,time_id.as_of_date as_of_date
12816: ,pfxaf.labor_hrs labor_hours
12817: ,pfxaf.equipment_hours equipment_hours
12818: ,pfxaf.brdn_cost prj_brdn_cost
12819: from pji_fp_xbs_accum_f pfxaf,
12820: pa_budget_versions pbv,
12821: (
12822: select prog_date.proj_element_id proj_element_id,
12823: prog_date.as_of_date as_of_date,
12866: --if the passed structure id does have as of date in the progress_rollup table.
12867: --This cursor retrieves the accumulated amounts for lastest published the for periods before before as of date
12868: cursor cur_accum_amts_p (p_project_id NUMBER, p_structure_version_id NUMBER, p_baseline_struc_id NUMBER,
12869: p_proj_element_id NUMBER,p_cal_id NUMBER, p_cal_type varchar, p_as_of_date date) is
12870: select /*+ index(PFXAF PJI_FP_XBS_ACCUM_F_N1) */ time_id.proj_element_id proj_element_id -- Fix for Bug # 14169654.
12871: ,time_id.as_of_date as_of_date
12872: ,sum(pfxaf.labor_hrs) labor_hours
12873: ,sum(pfxaf.equipment_hours) equipment_hours
12874: ,sum(pfxaf.brdn_cost) prj_brdn_cost
12871: ,time_id.as_of_date as_of_date
12872: ,sum(pfxaf.labor_hrs) labor_hours
12873: ,sum(pfxaf.equipment_hours) equipment_hours
12874: ,sum(pfxaf.brdn_cost) prj_brdn_cost
12875: from pji_fp_xbs_accum_f pfxaf,
12876: pa_budget_versions pbv,
12877: (
12878: select prog_date.proj_element_id proj_element_id,
12879: prog_date.as_of_date as_of_date,
12919: ,time_id.as_of_date ;
12920:
12921: cursor cur_curr_prd_amts_p (p_project_id NUMBER, p_structure_version_id NUMBER, p_baseline_struc_id NUMBER,
12922: p_proj_element_id NUMBER,p_cal_id NUMBER, p_cal_type varchar, p_as_of_date date) is
12923: select /*+ index(PFXAF PJI_FP_XBS_ACCUM_F_N1) */ pfxaf.project_element_id proj_element_id -- Fix for Bug # 14169654.
12924: ,time_id.pstart_date pstart_date
12925: ,time_id.pend_date pend_date
12926: ,time_id.as_of_date as_of_date
12927: ,pfxaf.labor_hrs labor_hours
12926: ,time_id.as_of_date as_of_date
12927: ,pfxaf.labor_hrs labor_hours
12928: ,pfxaf.equipment_hours equipment_hours
12929: ,pfxaf.brdn_cost prj_brdn_cost
12930: from pji_fp_xbs_accum_f pfxaf,
12931: pa_budget_versions pbv,
12932: (
12933: select prog_date.proj_element_id proj_element_id,
12934: prog_date.as_of_date as_of_date,