DBA Data[Home] [Help]

APPS.PA_FP_VIEW_PLANS_UTIL dependencies on PA_BUDGET_LINES

Line 4794: from pa_budget_lines

4790: select SUM(nvl(quantity,0)),
4791: SUM(nvl(revenue,0))
4792: into l_line_quantity_total,
4793: l_line_costrev_total
4794: from pa_budget_lines
4795: where resource_assignment_id = l_ra_rec.resource_assignment_id
4796: group by resource_assignment_id;
4797: update pa_resource_assignments
4798: set total_plan_revenue = l_line_costrev_total,

Line 4812: from pa_budget_lines

4808: select SUM(nvl(quantity,0)),
4809: SUM(nvl(burdened_cost,0))
4810: into l_line_quantity_total,
4811: l_line_costrev_total
4812: from pa_budget_lines
4813: where resource_assignment_id = l_ra_rec.resource_assignment_id
4814: group by resource_assignment_id;
4815: update pa_resource_assignments
4816: set total_plan_burdened_cost = l_line_costrev_total,