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.AMS_DCF_DEFAULT_VALUES dependencies on GL_PERIODS_V

Line 211: select period_name into x_return_year from gl_periods_v g

207: x_return_qtr varchar2(80);
208:
209: BEGIN
210:
211: select period_name into x_return_year from gl_periods_v g
212: where trunc(SYSDATE) BETWEEN g.start_date AND g.end_date
213: AND g.period_set_name = def_period
214: AND g.period_type = def_year;
215:

Line 216: select period_name into x_return_qtr from gl_periods_v g

212: where trunc(SYSDATE) BETWEEN g.start_date AND g.end_date
213: AND g.period_set_name = def_period
214: AND g.period_type = def_year;
215:
216: select period_name into x_return_qtr from gl_periods_v g
217: where trunc(SYSDATE) BETWEEN g.start_date AND g.end_date
218: AND g.period_set_name = def_period
219: AND g.period_type = def_quarter;
220:

Line 237: select period_name into x_return_year from gl_periods_v g

233: x_return_qtr varchar2(80);
234:
235: BEGIN
236:
237: select period_name into x_return_year from gl_periods_v g
238: where trunc(SYSDATE) BETWEEN g.start_date AND g.end_date
239: AND g.period_set_name = def_period
240: AND g.period_type = def_year;
241:

Line 242: select period_name into x_return_qtr from gl_periods_v g

238: where trunc(SYSDATE) BETWEEN g.start_date AND g.end_date
239: AND g.period_set_name = def_period
240: AND g.period_type = def_year;
241:
242: select period_name into x_return_qtr from gl_periods_v g
243: where trunc(SYSDATE) BETWEEN g.start_date AND g.end_date
244: AND g.period_set_name = def_period
245: AND g.period_type = def_quarter;
246:

Line 264: select period_name into x_return_value from gl_periods_v g

260: x_return_value varchar2(80) ;
261:
262: BEGIN
263:
264: select period_name into x_return_value from gl_periods_v g
265: where trunc(SYSDATE) BETWEEN g.start_date AND g.end_date
266: AND g.period_set_name = def_period
267: AND g.period_type = def_quarter;
268:

Line 284: select period_name into x_return_value from gl_periods_v g

280: x_return_value varchar2(80) ;
281:
282: BEGIN
283:
284: select period_name into x_return_value from gl_periods_v g
285: where trunc(SYSDATE) BETWEEN g.start_date AND g.end_date
286: AND g.period_set_name = def_period
287: AND g.period_type = def_year;
288:

Line 304: select period_name into x_return_value from gl_periods_v g

300: x_return_value varchar2(80) ;
301:
302: BEGIN
303:
304: select period_name into x_return_value from gl_periods_v g
305: where trunc(SYSDATE) BETWEEN g.start_date AND g.end_date
306: AND g.period_set_name = def_period
307: AND g.period_type = def_quarter;
308: