312: l_count := l_count + 1;
313:
314: select cp.period_name name
315: into l_name
316: from fa_book_controls bc
317: , fa_fiscal_year fy
318: , fa_calendar_types ct
319: , fa_calendar_periods cp
320: , fa_adjustments_t fat
371: , fy.fiscal_year*ct.number_per_fiscal_year + 1 pctr
372: into l_name
373: , l_pctr
374: from fa_books bks
375: , fa_book_controls bc
376: , fa_fiscal_year fy
377: , fa_calendar_types ct
378: , fa_calendar_periods cp
379: where bc.book_type_code = i.book