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

Line 275: FROM GL_PERIOD_STATUSES

271: BEGIN
272: SELECT PERIOD_NAME
273: INTO lv_period_from
274: FROM (SELECT PERIOD_NAME
275: FROM GL_PERIOD_STATUSES
276: WHERE APPLICATION_ID = 101
277: AND LEDGER_ID = pn_ledger_id
278: AND PERIOD_YEAR = pv_accounting_year
279: AND CLOSING_STATUS <> 'N'

Line 294: FROM GL_PERIOD_STATUSES

290: BEGIN
291: SELECT PERIOD_NAME
292: INTO lv_period_to
293: FROM (SELECT PERIOD_NAME
294: FROM GL_PERIOD_STATUSES
295: WHERE APPLICATION_ID = 101
296: AND LEDGER_ID = pn_ledger_id
297: AND PERIOD_YEAR = pv_accounting_year
298: AND CLOSING_STATUS <> 'N'

Line 304: FROM GL_PERIOD_STATUSES

300: ORDER BY START_DATE DESC)
301: WHERE ROWNUM = 1;
302: SELECT TO_CHAR(END_DATE, 'YYYY/MM/DD HH:MM:SS')
303: INTO lv_accounting_date
304: FROM GL_PERIOD_STATUSES
305: WHERE APPLICATION_ID = 101
306: AND LEDGER_ID = pn_ledger_id
307: AND PERIOD_NAME = lv_period_to;
308: EXCEPTION