DBA Data[Home] [Help]

APPS.JAI_OPEN_API_PKG dependencies on GL_SETS_OF_BOOKS

Line 473: CURSOR get_chart_id_cur(cn_set_books_id IN gl_sets_of_books.SET_OF_BOOKS_ID%TYPE)

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

Line 476: FROM gl_sets_of_books

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