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

Line 164: FROM GL_PERIOD_STATUSES

160:
161: --Fetch start data and end date
162: SELECT start_date
163: INTO ld_start_date
164: FROM GL_PERIOD_STATUSES
165: WHERE ledger_id = pn_ledger_id
166: AND application_id = 101
167: AND period_name = pv_period_from
168: AND period_year = pv_accounting_year;

Line 172: FROM GL_PERIOD_STATUSES

168: AND period_year = pv_accounting_year;
169:
170: SELECT end_date
171: INTO ld_end_date
172: FROM GL_PERIOD_STATUSES
173: WHERE ledger_id = pn_ledger_id
174: AND application_id = 101
175: AND period_name = pv_period_to
176: AND period_year = pv_accounting_year;

Line 203: FROM gl_period_statuses gp

199: ln_row_count := ln_row_count + 1;
200:
201: SELECT period_num
202: INTO lv_period_name
203: FROM gl_period_statuses gp
204: WHERE
205: --period_year = pv_accounting_year fixed #bug 10365688
206: --AND
207: application_id = 101