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

Line 14: from gl_period_statuses

10: BEGIN
11:
12: select start_date, end_date
13: into tstart_date, tend_date
14: from gl_period_statuses
15: where period_name = tperiod_name
16: and ledger_id = tledger_id
17: and application_id = 101;
18:

Line 138: FROM gl_period_statuses a, gl_period_statuses b

134: BEGIN
135:
136: SELECT a.period_name
137: INTO tfirst_period
138: FROM gl_period_statuses a, gl_period_statuses b
139: WHERE a.application_id = 101
140: AND b.application_id = 101
141: AND a.ledger_id =tledger_id
142: AND b.ledger_id = tledger_id

Line 148: FROM gl_period_statuses c

144: AND a.period_year = b.period_year
145: AND b.period_name = tperiod_name
146: AND a.period_num =
147: (SELECT min(c.period_num)
148: FROM gl_period_statuses c
149: WHERE c.application_id = 101
150: AND c.ledger_id =tledger_id
151: AND c.period_year = a.period_year
152: AND c.period_type = a.period_type

Line 179: FROM gl_period_statuses a, gl_period_statuses b

175: BEGIN
176:
177: SELECT a.period_name
178: INTO tfirst_period
179: FROM gl_period_statuses a, gl_period_statuses b
180: WHERE a.application_id = 101
181: AND b.application_id = 101
182: AND a.ledger_id =tledger_id
183: AND b.ledger_id = tledger_id

Line 190: FROM gl_period_statuses c

186: AND a.quarter_num = b.quarter_num
187: AND b.period_name = tperiod_name
188: AND a.period_num =
189: (SELECT min(c.period_num)
190: FROM gl_period_statuses c
191: WHERE c.application_id = 101
192: AND c.ledger_id = tledger_id
193: AND c.period_year = a.period_year
194: AND c.quarter_num = a.quarter_num