APPS.PA_BILLING_CORE dependencies on PA_BUDGET_VERSIONS

Line 114: pa_budget_versions v

110: SELECT t.top_task_id , sum(l.revenue) revenue
111: FROM pa_budget_lines l,
112: pa_resource_assignments a,
113: pa_tasks t,
114: pa_budget_versions v
115: WHERE v.project_id = x_project_id
116: AND (v.budget_type_code = 'AR'
117: OR v.approved_rev_plan_type_flag ='Y')
118: AND v.budget_status_code IN ('S','W') /* Fix for Bug # 1206240*/

Line 288: from pa_budget_versions

284: BEGIN
285: select fin_plan_type_id,
286: version_type
287: into l_fin_plan_type_id,l_version_type
288: from pa_budget_versions
289: where budget_version_id = x_draft_version_id;
290:
291: EXCEPTION
292: WHEN NO_DATA_FOUND THEN

Line 461: from pa_budget_versions

457: select fin_plan_type_id,
458: version_type
459: into l_fin_plan_type_id,
460: l_version_type
461: from pa_budget_versions
462: where budget_version_id = x_draft_version_id;
463:
464: EXCEPTION
465: WHEN NO_DATA_FOUND THEN