DBA Data[Home] [Help]

APPS.PA_PROGRESS_UTILS dependencies on PA_BUDGET_VERSIONS

Line 3068: ,pa_budget_versions pbv

3064: ppfo.all_time_phased_code) time_phase_code
3065: FROM gl_sets_of_books gsb
3066: ,pa_implementations_all pia
3067: ,pa_projects_all ppa
3068: ,pa_budget_versions pbv
3069: ,pa_proj_fp_options ppfo
3070: WHERE ppa.project_id = pbv.project_id
3071: AND pbv.budget_version_id = ppfo.fin_plan_version_id
3072: --AND nvl(ppa.org_id,-99) = nvl(pia.org_id,-99) R12: Bug 4363092:

Line 8577: pa_budget_versions pbv,

8573: pra.rate_based_flag,
8574: pra.resource_assignment_id,
8575: rlm.alias
8576: FROM pa_resource_assignments pra, ----pa_task_assignments_v 4871809
8577: pa_budget_versions pbv,
8578: pa_resource_list_members rlm
8579: WHERE pbv.project_structure_version_id = c_structure_version_id
8580: AND pbv.budget_version_id = pra.budget_version_id
8581: AND pra.task_id = c_task_id

Line 12659: pa_budget_versions pbv,

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

Line 12712: pa_budget_versions pbv,

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

Line 12766: pa_budget_versions pbv,

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

Line 12820: pa_budget_versions pbv,

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

Line 12876: pa_budget_versions pbv,

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

Line 12931: pa_budget_versions pbv,

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

Line 13049: FROM pa_proj_fp_options ppfo, pa_budget_versions pbv

13045: END IF;
13046:
13047: --Code for getting the calendar id.
13048: SELECT ppfo.cost_time_phased_code INTO l_cal_type
13049: FROM pa_proj_fp_options ppfo, pa_budget_versions pbv
13050: WHERE pbv.project_id=p_project_id
13051: AND pbv.project_structure_version_id=p_structure_version_id
13052: AND pbv.budget_version_id=ppfo.fin_plan_version_id
13053: AND ppfo.fin_plan_option_level_code='PLAN_VERSION';