APPS.PA_PROGRESS_UTILS dependencies on PJI_FP_XBS_ACCUM_F

Line 12564: from pji_fp_xbs_accum_f pfxaf,

12560: ,time_id.as_of_date as_of_date
12561: ,sum(pfxaf.labor_hrs) labor_hours
12562: ,sum(pfxaf.equipment_hours) equipment_hours
12563: ,sum(pfxaf.brdn_cost) prj_brdn_cost
12564: from pji_fp_xbs_accum_f pfxaf,
12565: pa_budget_versions pbv,
12566: (
12567: select prog_date.proj_element_id proj_element_id,
12568: prog_date.as_of_date as_of_date,

Line 12617: from pji_fp_xbs_accum_f pfxaf,

12613: ,time_id.as_of_date as_of_date
12614: ,pfxaf.labor_hrs labor_hours
12615: ,pfxaf.equipment_hours equipment_hours
12616: ,pfxaf.brdn_cost prj_brdn_cost
12617: from pji_fp_xbs_accum_f pfxaf,
12618: pa_budget_versions pbv,
12619: (
12620: select prog_date.proj_element_id proj_element_id,
12621: prog_date.as_of_date as_of_date,

Line 12671: from pji_fp_xbs_accum_f pfxaf,

12667: ,time_id.as_of_date as_of_date
12668: ,sum(pfxaf.labor_hrs) labor_hours
12669: ,sum(pfxaf.equipment_hours) equipment_hours
12670: ,sum(pfxaf.brdn_cost) prj_brdn_cost
12671: from pji_fp_xbs_accum_f pfxaf,
12672: pa_budget_versions pbv,
12673: (
12674: select prog_date.proj_element_id proj_element_id,
12675: prog_date.as_of_date as_of_date,

Line 12725: from pji_fp_xbs_accum_f pfxaf,

12721: ,time_id.as_of_date as_of_date
12722: ,pfxaf.labor_hrs labor_hours
12723: ,pfxaf.equipment_hours equipment_hours
12724: ,pfxaf.brdn_cost prj_brdn_cost
12725: from pji_fp_xbs_accum_f pfxaf,
12726: pa_budget_versions pbv,
12727: (
12728: select prog_date.proj_element_id proj_element_id,
12729: prog_date.as_of_date as_of_date,

Line 12781: from pji_fp_xbs_accum_f pfxaf,

12777: ,time_id.as_of_date as_of_date
12778: ,sum(pfxaf.labor_hrs) labor_hours
12779: ,sum(pfxaf.equipment_hours) equipment_hours
12780: ,sum(pfxaf.brdn_cost) prj_brdn_cost
12781: from pji_fp_xbs_accum_f pfxaf,
12782: pa_budget_versions pbv,
12783: (
12784: select prog_date.proj_element_id proj_element_id,
12785: prog_date.as_of_date as_of_date,

Line 12836: from pji_fp_xbs_accum_f pfxaf,

12832: ,time_id.as_of_date as_of_date
12833: ,pfxaf.labor_hrs labor_hours
12834: ,pfxaf.equipment_hours equipment_hours
12835: ,pfxaf.brdn_cost prj_brdn_cost
12836: from pji_fp_xbs_accum_f pfxaf,
12837: pa_budget_versions pbv,
12838: (
12839: select prog_date.proj_element_id proj_element_id,
12840: prog_date.as_of_date as_of_date,