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.AP_IMPORT_VALIDATION_PKG dependencies on GL_PERIOD_STATUSES

Line 16795: FROM gl_period_statuses

16791: ELSE -- IF l_key not found in cache(l_ret_code other than 1) .. cache it
16792: BEGIN
16793: SELECT period_name
16794: INTO l_period_name
16795: FROM gl_period_statuses
16796: WHERE application_id = 200
16797: AND set_of_books_id = p_set_of_books_id
16798: AND trunc(nvl(l_accounting_date,AP_IMPORT_INVOICES_PKG.g_inv_sysdate))
16799: between start_date and END_date

Line 16871: FROM GL_PERIOD_STATUSES gps1,

16867: END IF;
16868:
16869: SELECT 'The period is NOT beyond latest encumbrance year'
16870: INTO l_DUMMY
16871: FROM GL_PERIOD_STATUSES gps1,
16872: GL_SETS_OF_BOOKS gsob
16873: WHERE gps1.period_year <= gsob.latest_encumbrance_year
16874: AND gsob.SET_OF_BOOKS_ID = p_set_of_books_id
16875: AND gps1.APPLICATION_ID = 200

Line 18422: FROM gl_period_statuses

18418: p_invoice_lines_rec.org_id);
18419: /* Bug 15835723
18420: SELECT period_name
18421: INTO l_period_name
18422: FROM gl_period_statuses
18423: WHERE application_id = 200
18424: AND set_of_books_id = p_set_of_books_id
18425: AND trunc(p_invoice_lines_rec.def_acctg_start_date)
18426: between start_date and end_date