[Home] [Help]
185: FUNCTION get_budget
186: (p_budget_id NUMBER ) return VARCHAR2
187: --
188: AS
189: l_budget_name per_budgets.name%type;
190: --
191: begin
192: --
193: hr_utility.trace('Entered Get_Budget');
199: begin
200: hr_utility.set_location('hr_reports.get_budget',5);
201: SELECT name
202: INTO l_budget_name
203: FROM per_budgets
204: WHERE budget_id = p_budget_id;
205: --
206: exception when NO_DATA_FOUND then null;
207: end;