APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_BUDGET_VERSIONS

Line 5429: FROM pa_budget_versions

5425:
5426: IF l_wp_vers_id IS NOT NULL THEN
5427: SELECT budget_version_id
5428: INTO l_budget_version_id
5429: FROM pa_budget_versions
5430: WHERE project_structure_version_id = l_wp_vers_id
5431: AND wp_version_flag = 'Y';
5432: END IF;
5433:

Line 5438: FROM pa_budget_versions bv

5434: ELSE
5435: -- Bug 4779037 - added in Financial plan case.
5436: SELECT MAX(bv.budget_version_id)
5437: INTO l_budget_version_id
5438: FROM pa_budget_versions bv
5439: WHERE bv.fin_plan_type_id = p_fin_plan_type_id
5440: AND bv.project_id = p_project_id
5441: AND NVL(wp_version_flag,'N') = 'N'
5442: AND NVL(bv.budget_status_code,'W') IN ('W','S');