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.

[Home] [Help]

APPS.JL_ZZ_GL_INFL_ADJ_PKG dependencies on GL_PERIODS

Line 164: FROM gl_periods a

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

Line 173: FROM gl_periods

169: IF curr_period_num > 1 THEN
170:
171: SELECT period_name
172: INTO p_prev_period_name
173: FROM gl_periods
174: WHERE period_set_name = p_period_set_name
175: AND period_year = curr_period_year
176: AND period_type = curr_period_type
177: AND period_num = (SELECT max(period_num)

Line 178: FROM gl_periods

174: WHERE period_set_name = p_period_set_name
175: AND period_year = curr_period_year
176: AND period_type = curr_period_type
177: AND period_num = (SELECT max(period_num)
178: FROM gl_periods
179: WHERE period_set_name = p_period_set_name
180: AND period_year = curr_period_year
181: AND period_num < curr_period_num
182: AND period_type = curr_period_type

Line 189: FROM gl_periods

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

Line 194: FROM gl_periods

190: WHERE period_set_name = p_period_set_name
191: AND period_year = curr_period_year - 1
192: AND period_type = curr_period_type
193: AND period_num = (SELECT max(period_num)
194: FROM gl_periods
195: WHERE period_set_name = p_period_set_name
196: AND period_year = curr_period_year - 1
197: AND period_type = curr_period_type
198: AND adjustment_period_flag <> 'Y');

Line 396: , gl_periods gp

392:
393: SELECT price_index_value
394: INTO p_index_value
395: FROM fa_price_index_values fpiv
396: , gl_periods gp
397: WHERE fpiv.price_index_id = p_index_id
398: AND gp.period_name = ix_period_name
399: ANd gp.period_set_name = p_period_set_name
400: AND gp.end_date BETWEEN fpiv.from_date

Line 622: FROM gl_periods

618: BEGIN
619:
620: SELECT period_year, period_num
621: INTO p_period_year, p_period_num
622: FROM gl_periods
623: WHERE period_name = p_period_name
624: AND period_set_name = p_period_set_name;
625:
626: RETURN TRUE;