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 15388: FROM gl_period_statuses

15384: ELSE -- IF l_key not found in cache(l_ret_code other than 1) .. cache it
15385: BEGIN
15386: SELECT period_name
15387: INTO l_period_name
15388: FROM gl_period_statuses
15389: WHERE application_id = 200
15390: AND set_of_books_id = p_set_of_books_id
15391: AND trunc(nvl(l_accounting_date,AP_IMPORT_INVOICES_PKG.g_inv_sysdate))
15392: between start_date and END_date

Line 15464: FROM GL_PERIOD_STATUSES gps1,

15460: END IF;
15461:
15462: SELECT 'The period is NOT beyond latest encumbrance year'
15463: INTO l_DUMMY
15464: FROM GL_PERIOD_STATUSES gps1,
15465: GL_SETS_OF_BOOKS gsob
15466: WHERE gps1.period_year <= gsob.latest_encumbrance_year
15467: AND gsob.SET_OF_BOOKS_ID = p_set_of_books_id
15468: AND gps1.APPLICATION_ID = 200

Line 16825: FROM gl_period_statuses

16821: IF (p_invoice_lines_rec.def_acctg_start_date IS NOT NULL) THEN
16822: BEGIN
16823: SELECT period_name
16824: INTO l_period_name
16825: FROM gl_period_statuses
16826: WHERE application_id = 200
16827: AND set_of_books_id = p_set_of_books_id
16828: AND trunc(p_invoice_lines_rec.def_acctg_start_date)
16829: between start_date and end_date