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_EXPORT_REPORT_PROG dependencies on GL_PERIOD_STATUSES

Line 254: FROM GL_PERIOD_STATUSES

250: BEGIN
251: SELECT PERIOD_NAME
252: INTO lv_period_from
253: FROM (SELECT PERIOD_NAME
254: FROM GL_PERIOD_STATUSES
255: WHERE APPLICATION_ID = 101
256: AND LEDGER_ID = pn_ledger_id
257: AND PERIOD_YEAR = pv_accounting_year
258: AND CLOSING_STATUS <> 'N'

Line 274: FROM GL_PERIOD_STATUSES

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

Line 285: FROM GL_PERIOD_STATUSES

281: WHERE ROWNUM = 1;
282: SELECT TO_CHAR(END_DATE,
283: 'YYYY/MM/DD HH:MM:SS')
284: INTO lv_accounting_date
285: FROM GL_PERIOD_STATUSES
286: WHERE APPLICATION_ID = 101
287: AND LEDGER_ID = pn_ledger_id
288: AND PERIOD_NAME = lv_period_to;
289: EXCEPTION