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.JL_ZZ_GL_INFL_ADJ_PKG dependencies on GL_PERIODS

Line 165: FROM gl_periods a

161: a.period_type
162: INTO curr_period_num ,
163: curr_period_year,
164: curr_period_type
165: FROM gl_periods a
166: WHERE a.period_set_name = p_period_set_name
167: AND a.period_name = p_period_name;
168:
169:

Line 175: FROM gl_periods

171: current one - Bug #9720379 */
172:
173: SELECT count(period_num)
174: INTO period_counter
175: FROM gl_periods
176: WHERE period_set_name = p_period_set_name
177: AND period_year = curr_period_year
178: AND period_num < curr_period_num
179: AND period_type = curr_period_type

Line 188: FROM gl_periods

184: THEN
185:
186: SELECT period_name
187: INTO p_prev_period_name
188: FROM gl_periods
189: WHERE period_set_name = p_period_set_name
190: AND period_year = curr_period_year
191: AND period_type = curr_period_type
192: AND period_num = (SELECT max(period_num)

Line 193: FROM gl_periods

189: WHERE period_set_name = p_period_set_name
190: AND period_year = curr_period_year
191: AND period_type = curr_period_type
192: AND period_num = (SELECT max(period_num)
193: FROM gl_periods
194: WHERE period_set_name = p_period_set_name
195: AND period_year = curr_period_year
196: AND period_num < curr_period_num
197: AND period_type = curr_period_type

Line 204: FROM gl_periods

200:
201: ELSE
202: SELECT period_name
203: INTO p_prev_period_name
204: FROM gl_periods
205: WHERE period_set_name = p_period_set_name
206: AND period_year = curr_period_year - 1
207: AND period_type = curr_period_type
208: AND period_num = (SELECT max(period_num)

Line 209: FROM gl_periods

205: WHERE period_set_name = p_period_set_name
206: AND period_year = curr_period_year - 1
207: AND period_type = curr_period_type
208: AND period_num = (SELECT max(period_num)
209: FROM gl_periods
210: WHERE period_set_name = p_period_set_name
211: AND period_year = curr_period_year - 1
212: AND period_type = curr_period_type
213: AND adjustment_period_flag <> 'Y');

Line 411: , gl_periods gp

407:
408: SELECT price_index_value
409: INTO p_index_value
410: FROM fa_price_index_values fpiv
411: , gl_periods gp
412: WHERE fpiv.price_index_id = p_index_id
413: AND gp.period_name = ix_period_name
414: ANd gp.period_set_name = p_period_set_name
415: AND gp.end_date BETWEEN fpiv.from_date

Line 637: FROM gl_periods

633: BEGIN
634:
635: SELECT period_year, period_num
636: INTO p_period_year, p_period_num
637: FROM gl_periods
638: WHERE period_name = p_period_name
639: AND period_set_name = p_period_set_name;
640:
641: RETURN TRUE;