APPS.CN_ACC_PERIODS_PVT dependencies on CN_PERIOD_TYPES

Line 232: l_period_type_id cn_period_types.period_type_id%TYPE;

228: l_set_of_books_id cn_repositories.set_of_books_id%TYPE;
229: l_repository_id cn_repositories.repository_id%TYPE;
230: l_calendar cn_period_sets.period_set_name%TYPE;
231: l_period_set_id cn_period_sets.period_set_id%TYPE;
232: l_period_type_id cn_period_types.period_type_id%TYPE;
233: l_period_type cn_period_types.period_type%TYPE;
234: l_quarter_num gl_period_statuses.quarter_num%TYPE;
235: l_period_num gl_period_statuses.period_num%TYPE;
236: l_object_version_number cn_period_statuses.object_version_number%TYPE;

Line 233: l_period_type cn_period_types.period_type%TYPE;

229: l_repository_id cn_repositories.repository_id%TYPE;
230: l_calendar cn_period_sets.period_set_name%TYPE;
231: l_period_set_id cn_period_sets.period_set_id%TYPE;
232: l_period_type_id cn_period_types.period_type_id%TYPE;
233: l_period_type cn_period_types.period_type%TYPE;
234: l_quarter_num gl_period_statuses.quarter_num%TYPE;
235: l_period_num gl_period_statuses.period_num%TYPE;
236: l_object_version_number cn_period_statuses.object_version_number%TYPE;
237: l_closing_status gl_period_statuses.closing_status%TYPE;

Line 261: cn_period_types pt

257: pt.period_type,
258: pt.period_type_id
259: FROM cn_repositories r,
260: cn_period_sets ps,
261: cn_period_types pt
262: WHERE r.repository_id > 0
263: AND r.application_type = 'CN'
264: AND r.period_set_id = ps.period_set_id
265: AND r.period_type_id = pt.period_type_id

Line 645: x_period_type OUT NOCOPY cn_period_types.period_type%TYPE,

641: PROCEDURE get_acc_periods
642: (p_year IN NUMBER,
643: x_system_status OUT NOCOPY cn_lookups.meaning%TYPE,
644: x_calendar OUT NOCOPY cn_period_sets.period_set_name%TYPE,
645: x_period_type OUT NOCOPY cn_period_types.period_type%TYPE,
646: x_acc_period_tbl OUT NOCOPY acc_period_tbl_type)
647: IS
648: l_set_of_books_id cn_repositories.set_of_books_id%TYPE;
649: l_period_set_id cn_repositories.period_set_id%TYPE;

Line 692: FROM cn_period_types

688: WHERE period_set_id = l_period_set_id;
689:
690: CURSOR period_type IS
691: SELECT period_type
692: FROM cn_period_types
693: WHERE period_type_id = l_period_type_id;
694:
695: -- Changed cursor fix bug#2804029
696: CURSOR periods IS