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

Line 196: FROM gl_period_statuses a, gl_period_statuses b

192: is
193: BEGIN
194: SELECT a.period_name
195: INTO tfirst_period
196: FROM gl_period_statuses a, gl_period_statuses b
197: WHERE a.application_id = 101
198: AND b.application_id = 101
199: AND a.ledger_id = tledger_id
200: AND b.ledger_id = tledger_id

Line 206: FROM gl_period_statuses c

202: AND a.period_year = b.period_year
203: AND b.period_name = tperiod_name
204: AND a.period_num =
205: (SELECT min(c.period_num)
206: FROM gl_period_statuses c
207: WHERE c.application_id = 101
208: AND c.ledger_id = tledger_id
209: AND c.period_year = a.period_year
210: AND c.period_type = a.period_type