APPS.OKI_DISCO_UTIL_PVT dependencies on GL_SETS_OF_BOOKS

Line 18: from gl_periods gp, gl_sets_of_books sob

14: begin
15: BEGIN
16: select count(1)
17: into l_num_periods
18: from gl_periods gp, gl_sets_of_books sob
19: where 1 = 1
20: and sob.set_of_books_id = p_sob_id
21: and gp.period_set_name = sob.period_set_name
22: and gp.period_type = sob.accounted_period_type

Line 148: from gl_periods gp, gl_sets_of_books sob

144:
145: /* get period start and end dates */
146: select trunc(gp.start_date), trunc(gp.end_date)
147: into l_period_start_date, l_period_end_date
148: from gl_periods gp, gl_sets_of_books sob
149: where 1 = 1
150: and sob.set_of_books_id = p_sob_id
151: and gp.period_set_name = sob.period_set_name
152: and gp.period_type = sob.accounted_period_type

Line 197: from gl_periods gp, gl_sets_of_books sob

193:
194: /* get period start and end dates */
195: select trunc(gp.start_date), trunc(gp.end_date)
196: into l_period_start_date, l_period_end_date
197: from gl_periods gp, gl_sets_of_books sob
198: where 1 = 1
199: and sob.set_of_books_id = p_sob_id
200: and gp.period_set_name = sob.period_set_name
201: and gp.period_type = sob.accounted_period_type