APPS.PA_PROGRESS_UTILS dependencies on PA_BUDGET_VERSIONS

Line 3043: ,pa_budget_versions pbv

3039: ppfo.all_time_phased_code) time_phase_code
3040: FROM gl_sets_of_books gsb
3041: ,pa_implementations_all pia
3042: ,pa_projects_all ppa
3043: ,pa_budget_versions pbv
3044: ,pa_proj_fp_options ppfo
3045: WHERE ppa.project_id = pbv.project_id
3046: AND pbv.budget_version_id = ppfo.fin_plan_version_id
3047: --AND nvl(ppa.org_id,-99) = nvl(pia.org_id,-99) R12: Bug 4363092:

Line 8531: pa_budget_versions pbv,

8527: pra.rate_based_flag,
8528: pra.resource_assignment_id,
8529: rlm.alias
8530: FROM pa_resource_assignments pra, ----pa_task_assignments_v 4871809
8531: pa_budget_versions pbv,
8532: pa_resource_list_members rlm
8533: WHERE pbv.project_structure_version_id = c_structure_version_id
8534: AND pbv.budget_version_id = pra.budget_version_id
8535: AND pra.task_id = c_task_id

Line 12565: pa_budget_versions pbv,

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,
12569: ptcpv.cal_period_id cal_period_id,

Line 12618: pa_budget_versions pbv,

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,
12622: ptcpv.cal_period_id cal_period_id,

Line 12672: pa_budget_versions pbv,

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,
12676: ptcpv.cal_period_id cal_period_id,

Line 12726: pa_budget_versions pbv,

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,
12730: ptcpv.cal_period_id cal_period_id,

Line 12782: pa_budget_versions pbv,

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,
12786: ptcpv.cal_period_id cal_period_id,

Line 12837: pa_budget_versions pbv,

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,
12841: ptcpv.cal_period_id cal_period_id,

Line 12952: FROM pa_proj_fp_options ppfo, pa_budget_versions pbv

12948: END IF;
12949:
12950: --Code for getting the calendar id.
12951: SELECT ppfo.cost_time_phased_code INTO l_cal_type
12952: FROM pa_proj_fp_options ppfo, pa_budget_versions pbv
12953: WHERE pbv.project_id=p_project_id
12954: AND pbv.project_structure_version_id=p_structure_version_id
12955: AND pbv.budget_version_id=ppfo.fin_plan_version_id
12956: AND ppfo.fin_plan_option_level_code='PLAN_VERSION';