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

Line 255: FROM gl_period_statuses p

251:
252: CURSOR same_period IS
253: SELECT period_name,closing_status,start_date,end_date,
254: adjustment_period_flag
255: FROM gl_period_statuses p
256: WHERE p.application_id = 101
257: AND p.ledger_id = X_Ledger_Id
258: AND p.period_name = X_Je_Period_Name;
259:

Line 263: FROM gl_period_statuses p1

259:
260: CURSOR next_period IS
261: SELECT period_name, closing_status, start_date, end_date,
262: adjustment_period_flag
263: FROM gl_period_statuses p1
264: WHERE p1.application_id = 101
265: AND p1.ledger_id = X_Ledger_Id
266: AND p1.effective_period_num =
267: ( SELECT min(effective_period_num)

Line 268: FROM gl_period_statuses p1

264: WHERE p1.application_id = 101
265: AND p1.ledger_id = X_Ledger_Id
266: AND p1.effective_period_num =
267: ( SELECT min(effective_period_num)
268: FROM gl_period_statuses p1
269: WHERE p1.application_id = 101
270: AND p1.ledger_id = X_Ledger_Id
271: AND p1.effective_period_num >
272: ( SELECT effective_period_num

Line 273: FROM gl_period_statuses p2

269: WHERE p1.application_id = 101
270: AND p1.ledger_id = X_Ledger_Id
271: AND p1.effective_period_num >
272: ( SELECT effective_period_num
273: FROM gl_period_statuses p2
274: WHERE p2.application_id = 101
275: AND p2.ledger_id = X_Ledger_Id
276: AND p2.period_name = X_Je_Period_Name));
277:

Line 280: FROM gl_period_statuses p

276: AND p2.period_name = X_Je_Period_Name));
277:
278: CURSOR next_nonadj_period IS
279: SELECT period_name, closing_status, start_date, end_date
280: FROM gl_period_statuses p
281: WHERE p.application_id = 101
282: AND p.ledger_id = X_Ledger_Id
283: AND p.effective_period_num =
284: ( SELECT min(effective_period_num)

Line 285: FROM gl_period_statuses p1

281: WHERE p.application_id = 101
282: AND p.ledger_id = X_Ledger_Id
283: AND p.effective_period_num =
284: ( SELECT min(effective_period_num)
285: FROM gl_period_statuses p1
286: WHERE p1.application_id = 101
287: AND p1.ledger_id = X_Ledger_Id
288: AND adjustment_period_flag = 'N'
289: AND p1.effective_period_num >

Line 291: FROM gl_period_statuses p2

287: AND p1.ledger_id = X_Ledger_Id
288: AND adjustment_period_flag = 'N'
289: AND p1.effective_period_num >
290: ( SELECT effective_period_num
291: FROM gl_period_statuses p2
292: WHERE p2.application_id = 101
293: AND p2.ledger_id = X_Ledger_Id
294: AND p2.period_name = X_Je_Period_Name));
295:

Line 302: FROM gl_period_statuses p

298: -- reverse into the next adjusting period if the journal period is adj.
299: -- note: min() neccessary because there may be overlapping adj periods
300: CURSOR next_day_to_period IS
301: SELECT period_name, closing_status, start_date, end_date
302: FROM gl_period_statuses p
303: WHERE p.application_id = 101
304: AND p.ledger_id = X_Ledger_Id
305: AND p.effective_period_num =
306: ( SELECT min(effective_period_num)

Line 307: FROM gl_period_statuses p1

303: WHERE p.application_id = 101
304: AND p.ledger_id = X_Ledger_Id
305: AND p.effective_period_num =
306: ( SELECT min(effective_period_num)
307: FROM gl_period_statuses p1
308: WHERE p1.application_id = 101
309: AND p1.ledger_id = X_Ledger_Id
310: AND reversal_date between p1.start_date and p1.end_date
311: AND p1.adjustment_period_flag = adj_period_flag);