Line 50: SELECT currency_code FROM gl_sets_of_books
46: g_total_text VARCHAR2(100);
47:
48: CURSOR C_curr (p_sob_id NUMBER)
49: IS 50: SELECT currency_code FROM gl_sets_of_books 51: WHERE set_of_books_id = p_sob_id;
52:
53: -- Cursor to FETCH user id FROM user name
54: CURSOR c_userid (p_username VARCHAR2) IS