DBA Data[Home] [Help]

APPS.CN_SYSTEM_PARAMETERS_PVT dependencies on CN_PERIOD_TYPES

Line 196: insert into cn_period_types

192: and not exists
193: ( select 1 from cn_period_sets where period_set_id = 0 );
194:
195:
196: insert into cn_period_types
197: ( period_type_id,
198: period_type,
199: created_by,
200: creation_date )

Line 209: ( select 1 from cn_period_types where period_type_id = 0 );

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:
211: update cn_repositories
212: set period_set_id = 0 ,
213: period_type_id = 0

Line 216: update cn_period_types

212: set period_set_id = 0 ,
213: period_type_id = 0
214: where set_of_books_id is not null;
215:
216: update cn_period_types
217: set period_type = 'Period'
218: where period_type_id = -1000
219: and period_type = 'Month';
220: