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_DATE_HANDLER_PKG dependencies on GL_DATE_PERIOD_MAP

Line 44: FROM gl_date_period_map map, gl_period_statuses ps

40: SELECT ps.period_name, ps.closing_status, ps.start_date, ps.end_date,
41: ps.period_num, ps.period_year
42: INTO x_active_period, period_status, x_per_start_date, x_per_end_date,
43: x_per_number, x_per_year
44: FROM gl_date_period_map map, gl_period_statuses ps
45: WHERE map.period_set_name = calendar
46: AND map.period_type = per_type
47: AND map.accounting_date = trunc(active_date)
48: AND ps.application_id = 101

Line 127: FROM gl_date_period_map map, gl_period_statuses ps

123: SELECT ps.period_name, ps.start_date, ps.end_date,
124: ps.period_num, ps.period_year
125: INTO x_active_period, x_per_start_date, x_per_end_date,
126: x_per_number, x_per_year
127: FROM gl_date_period_map map, gl_period_statuses ps
128: WHERE map.period_set_name = calendar
129: AND map.period_type = per_type
130: AND map.accounting_date = trunc(active_date)
131: AND ps.application_id = 101

Line 221: FROM gl_date_period_map map, gl_period_statuses ps

217: SELECT ps.period_name, ps.start_date, ps.end_date,
218: ps.period_num, ps.period_year
219: INTO x_active_period, x_per_start_date, x_per_end_date,
220: x_per_number, x_per_year
221: FROM gl_date_period_map map, gl_period_statuses ps
222: WHERE map.period_set_name = calendar
223: AND map.period_type = per_type
224: AND map.accounting_date = trunc(active_date)
225: AND ps.application_id = 101

Line 334: FROM gl_date_period_map map, gl_period_statuses ps

330: SELECT ps.period_name, ps.closing_status, ps.start_date, ps.end_date,
331: ps.period_year, ps.period_num
332: INTO x_period_name, period_status, period_start_date,
333: period_end_date, tmp_year, tmp_num
334: FROM gl_date_period_map map, gl_period_statuses ps
335: WHERE map.period_set_name = acct_cal_name
336: AND map.period_type = acc_period_type
337: AND map.accounting_date = initial_accounting_date
338: AND ps.application_id = 101

Line 539: FROM gl_date_period_map map, gl_period_statuses ps

535: SELECT ps.period_name, ps.closing_status, ps.start_date, ps.end_date,
536: ps.period_year, ps.period_num
537: INTO x_period_name, period_status, period_start_date,
538: period_end_date, tmp_year, tmp_num
539: FROM gl_date_period_map map, gl_period_statuses ps
540: WHERE map.period_set_name = acct_cal_name
541: AND map.period_type = acc_period_type
542: AND map.accounting_date = initial_accounting_date
543: AND ps.application_id = 101

Line 761: FROM gl_date_period_map map, gl_period_statuses ps

757: SELECT ps.period_name, ps.closing_status, ps.start_date, ps.end_date,
758: ps.period_num, ps.period_year
759: INTO x_from_period, period_status, x_per_start_date, x_per_end_date,
760: x_per_number, x_per_year
761: FROM gl_date_period_map map, gl_period_statuses ps
762: WHERE map.period_set_name = calendar
763: AND map.period_type = per_type
764: AND map.accounting_date = trunc(active_date)
765: AND ps.application_id = 101