228: BEGIN
229: IF p_mode = 'DRAFT' Then
230: select max(pbv.budget_version_id)
231: INTO l_bdgt_version_id
232: FROM pa_budget_versions pbv
233: ,pa_budget_types bdgttype
234: ,pa_budgetary_control_options pbct
235: WHERE pbv.project_id = p_project_id
236: AND pbv.current_flag = 'N'
244:
245: ELSE
246: select max(pbv.budget_version_id)
247: INTO l_bdgt_version_id
248: FROM pa_budget_versions pbv
249: ,pa_budget_types bdgttype
250: ,pa_budgetary_control_options pbct
251: WHERE pbv.project_id = p_project_id
252: AND pbv.current_flag = 'Y'