DBA Data[Home] [Help]

APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_BUDGET_VERSIONS

Line 5344: FROM pa_budget_versions

5340:
5341: IF l_wp_vers_id IS NOT NULL THEN
5342: SELECT budget_version_id
5343: INTO l_budget_version_id
5344: FROM pa_budget_versions
5345: WHERE project_structure_version_id = l_wp_vers_id
5346: AND wp_version_flag = 'Y';
5347: END IF;
5348:

Line 5353: FROM pa_budget_versions bv

5349: ELSE
5350: -- Bug 4779037 - added in Financial plan case.
5351: SELECT MAX(bv.budget_version_id)
5352: INTO l_budget_version_id
5353: FROM pa_budget_versions bv
5354: WHERE bv.fin_plan_type_id = p_fin_plan_type_id
5355: AND bv.project_id = p_project_id
5356: AND NVL(wp_version_flag,'N') = 'N'
5357: AND NVL(bv.budget_status_code,'W') IN ('W','S');