469: xn_err_flag IN OUT NOCOPY NUMBER
470: )
471: IS
472: --Cursor define here
473: CURSOR get_chart_id_cur(cn_set_books_id IN gl_sets_of_books.SET_OF_BOOKS_ID%TYPE)
474: IS
475: SELECT CHART_OF_ACCOUNTS_ID
476: FROM gl_sets_of_books
477: WHERE SET_OF_BOOKS_ID = cn_set_books_id
472: --Cursor define here
473: CURSOR get_chart_id_cur(cn_set_books_id IN gl_sets_of_books.SET_OF_BOOKS_ID%TYPE)
474: IS
475: SELECT CHART_OF_ACCOUNTS_ID
476: FROM gl_sets_of_books
477: WHERE SET_OF_BOOKS_ID = cn_set_books_id
478: AND CURRENCY_CODE = JAI_CONSTANTS.func_curr;
479:
480: --Added by zhiwei for bug#12560646 on 20110523 begin