eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_RCV_ACCOUNTING_PKG dependencies on GL_PERIOD_STATUSES

Line 404: select closing_status from gl_period_statuses where

400: and gd.adjustment_period_flag = 'N';
401:
402: /*Added by nprashar for FP bug # 9304844*/
403: cursor c_get_gl_period_status(cp_set_of_books_id number,cp_accounting_date date) IS /* added for bug 7007523 */
404: select closing_status from gl_period_statuses where
405: set_of_books_id=cp_set_of_books_id
406: and application_id=101 /*seeded application id for GL*/
407: and trunc(cp_accounting_date) between start_date and end_date; /*Added the Trunc clause for bug # 9288398*/
408:

Line 411: select start_date from gl_period_statuses

407: and trunc(cp_accounting_date) between start_date and end_date; /*Added the Trunc clause for bug # 9288398*/
408:
409: /*Added by nprashar for FP bug # 9304844*/
410: cursor c_new_accounting_date(cp_set_of_books_id number) IS /* added for bug 7007523 */
411: select start_date from gl_period_statuses
412: where set_of_books_id=cp_set_of_books_id
413: and application_id=101 /*seeded application id for GL*/
414: and closing_status IN ('O','F')
415: and start_date > p_accounting_date

Line 419: lv_show_status gl_period_statuses.closing_status%TYPE; /* added for bug 7007523 */

415: and start_date > p_accounting_date
416: order by period_year asc,period_num asc,closing_status desc;
417:
418: /*Added by nprashar for FP bug # 9304844*/
419: lv_show_status gl_period_statuses.closing_status%TYPE; /* added for bug 7007523 */
420: lv_new_accounting_date date; /* added for bug 7007523 */
421: lv_accounting_date date; /* added for bug 7007523 */
422:
423: