[Home] [Help]
217: l_start_date date;
218: l_fiscal_year_name fa_fiscal_year.fiscal_year_name%type;
219: cursor c_end is
220: select period_num, cp.start_date, fiscal_year_name
221: from fa_calendar_periods cp,
222: fa_book_controls bc
223: where calendar_type = bc.deprn_calendar
224: and bc.book_type_code = x_book
225: and start_date >= previous_end_date
391: if rakn = 1 then
392: dpr_in.y_begin := h_prorate_start_year;
393: select period_num
394: into dpr_in.p_cl_begin
395: from fa_calendar_periods cp,
396: fa_book_controls bc
397: where calendar_type = bc.deprn_calendar
398: and bc.book_type_code = x_book
399: and dpr_in.prorate_date
408: else
409: dpr_in.y_end := l_date_retired_year;
410: select period_num
411: into dpr_in.p_cl_end
412: from fa_calendar_periods cp,
413: fa_book_controls bc
414: where calendar_type = bc.deprn_calendar
415: and bc.book_type_code = x_book
416: and l_date_retired
430: if l_date_retired > to_date('19611231','YYYYMMDD') then
431: dpr_in.y_end := 1961;
432: select period_num
433: into dpr_in.p_cl_end
434: from fa_calendar_periods cp,
435: fa_book_controls bc
436: where calendar_type = bc.deprn_calendar
437: and bc.book_type_code = x_book
438: and to_date('19611231','YYYYMMDD')
441: else
442: dpr_in.y_end := l_date_retired_year;
443: select period_num
444: into dpr_in.p_cl_end
445: from fa_calendar_periods cp,
446: fa_book_controls bc
447: where calendar_type = bc.deprn_calendar
448: and bc.book_type_code = x_book
449: and l_date_retired