186: gl.period_set_name,
187: -1,
188: SYSDATE
189: from cn_repositories r,
190: gl_sets_of_books gl
191: where gl.set_of_books_id = r.set_of_books_id
192: and not exists
193: ( select 1 from cn_period_sets where period_set_id = 0 );
194:
202: gl.accounted_period_type,
203: -1,
204: SYSDATE
205: from cn_repositories r,
206: gl_sets_of_books gl
207: where gl.set_of_books_id = r.set_of_books_id
208: and not exists
209: ( select 1 from cn_period_types where period_type_id = 0 );
210: