Line 44: SELECT currency_code FROM gl_sets_of_books
40: g_total_text VARCHAR2(100);
41:
42: CURSOR C_curr (p_sob_id NUMBER)
43: IS 44: SELECT currency_code FROM gl_sets_of_books 45: WHERE set_of_books_id = p_sob_id;
46:
47: -- Cursor to FETCH user id FROM user name
48: CURSOR c_userid (p_username VARCHAR2) IS