342: RETURN VARCHAR2 IS
343:
344: l_prefix VARCHAR2(30);
345: l_code VARCHAR2(30);
346: -- change the cursor to ponit to ams_categories_vl table 03/05/2001
347: CURSOR c_suffix IS
348: SELECT budget_code_suffix
349: FROM ams_categories_vl
350: WHERE category_id = p_category_id;
345: l_code VARCHAR2(30);
346: -- change the cursor to ponit to ams_categories_vl table 03/05/2001
347: CURSOR c_suffix IS
348: SELECT budget_code_suffix
349: FROM ams_categories_vl
350: WHERE category_id = p_category_id;
351:
352: BEGIN
353: