DBA Data[Home] [Help]

APPS.AR_ADJVALIDATE_PUB dependencies on GL_SETS_OF_BOOKS

Line 292: gl_sets_of_books b

288: CURSOR l_periods_csr IS
289: SELECT trunc(g.start_date) start_date,
290: trunc(g.end_date) end_date
291: FROM gl_period_statuses g,
292: gl_sets_of_books b
293: WHERE g.application_id = 222
294: AND g.set_of_books_id = l_set_of_books_id
295: AND g.set_of_books_id = b.set_of_books_id
296: AND g.period_type = b.accounted_period_type

Line 2210: gl_sets_of_books b

2206:
2207: SELECT count(*)
2208: INTO l_count
2209: FROM gl_period_statuses g,
2210: gl_sets_of_books b
2211: WHERE g.application_id = 222
2212: AND g.set_of_books_id = l_set_of_books_id
2213: AND g.set_of_books_id = b.set_of_books_id
2214: AND g.period_type = b.accounted_period_type