APPS.POA_BIS_ALERTS dependencies on GL_PERIODS

Line 174: FROM gl_periods per

170: p_period_type := l_period_type;
171:
172: SELECT per.period_name, per.start_date, per.end_date
173: INTO p_period_name, p_start_date, p_end_date
174: FROM gl_periods per
175: WHERE per.period_set_name = p_period_set_name
176: AND per.period_type = l_period_type
177: AND per.adjustment_period_flag = 'N'
178: AND per.start_date <= TRUNC(sysdate)

Line 205: FROM gl_periods per

201: p_period_type := l_period_type;
202:
203: SELECT per.period_name, per.start_date, per.end_date
204: INTO p_period_name, p_start_date, p_end_date
205: FROM gl_periods per
206: WHERE per.period_set_name = p_period_set_name
207: AND per.period_type = l_period_type
208: AND per.adjustment_period_flag = 'N'
209: AND per.end_date = (SELECT max(end_date)

Line 210: FROM gl_periods per2

206: WHERE per.period_set_name = p_period_set_name
207: AND per.period_type = l_period_type
208: AND per.adjustment_period_flag = 'N'
209: AND per.end_date = (SELECT max(end_date)
210: FROM gl_periods per2
211: WHERE per2.period_set_name = p_period_set_name
212: AND per2.period_type = l_period_type
213: AND per2.adjustment_period_flag = 'N'
214: AND per2.end_date < TRUNC(sysdate));