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

Line 200: FROM GL_PERIOD_STATUSES

196: 'pv_period_to=' || pv_period_to);
197: --Fetch start data and end date
198: SELECT start_date
199: INTO ld_start_date
200: FROM GL_PERIOD_STATUSES
201: WHERE ledger_id = pn_ledger_id
202: AND application_id = 101
203: AND period_name = pv_period_from
204: AND period_year = pv_accounting_year;

Line 208: FROM GL_PERIOD_STATUSES

204: AND period_year = pv_accounting_year;
205:
206: SELECT end_date
207: INTO ld_end_date
208: FROM GL_PERIOD_STATUSES
209: WHERE ledger_id = pn_ledger_id
210: AND application_id = 101
211: AND period_name = pv_period_to
212: AND period_year = pv_accounting_year;

Line 238: FROM gl_period_statuses gp

234: LOOP
235: ln_row_count := ln_row_count + 1;
236: SELECT period_num
237: INTO lv_period_name
238: FROM gl_period_statuses gp
239: WHERE period_year = pv_accounting_year
240: AND application_id = 101
241: AND ledger_id = pn_ledger_id
242: AND gp.adjustment_period_flag = 'N'