[Home] [Help]
196: l_start_date date;
197: l_fiscal_year_name varchar2(30);
198: cursor c_end is
199: select period_num, cp.start_date, fiscal_year_name
200: from fa_calendar_periods cp,
201: fa_book_controls bc
202: where calendar_type = bc.deprn_calendar
203: and bc.book_type_code = x_book
204: and start_date >= previous_end_date
374: if rakn = 1 then
375: dpr_in.y_begin := h_prorate_start_year;
376: select period_num
377: into dpr_in.p_cl_begin
378: from fa_calendar_periods cp,
379: fa_book_controls bc
380: where calendar_type = bc.deprn_calendar
381: and bc.book_type_code = x_book
382: and dpr_in.prorate_date
384: if l_date_retired > to_date('19611231','YYYYMMDD') then
385: dpr_in.y_end := 1961;
386: select period_num
387: into dpr_in.p_cl_end
388: from fa_calendar_periods cp,
389: fa_book_controls bc
390: where calendar_type = bc.deprn_calendar
391: and bc.book_type_code = x_book
392: and to_date('19611231','YYYYMMDD')
395: else
396: dpr_in.y_end := l_date_retired_year;
397: select period_num
398: into dpr_in.p_cl_end
399: from fa_calendar_periods cp,
400: fa_book_controls bc
401: where calendar_type = bc.deprn_calendar
402: and bc.book_type_code = x_book
403: and l_date_retired
425: if l_date_retired > to_date('19611231','YYYYMMDD') then
426: dpr_in.y_end := 1961;
427: select period_num
428: into dpr_in.p_cl_end
429: from fa_calendar_periods cp,
430: fa_book_controls bc
431: where calendar_type = bc.deprn_calendar
432: and bc.book_type_code = x_book
433: and to_date('19611231','YYYYMMDD')
436: else
437: dpr_in.y_end := l_date_retired_year;
438: select period_num
439: into dpr_in.p_cl_end
440: from fa_calendar_periods cp,
441: fa_book_controls bc
442: where calendar_type = bc.deprn_calendar
443: and bc.book_type_code = x_book
444: and l_date_retired
683: l_start_date date;
684: l_fiscal_year_name varchar2(30);
685: cursor c_end is
686: select period_num, cp.start_date, fiscal_year_name
687: from fa_calendar_periods cp,
688: fa_book_controls bc
689: where calendar_type = bc.deprn_calendar
690: and bc.book_type_code = x_book
691: and start_date >= previous_end_date
865: if rakn = 1 then
866: dpr_in.y_begin := h_prorate_start_year;
867: select period_num
868: into dpr_in.p_cl_begin
869: from fa_calendar_periods cp,
870: fa_book_controls bc
871: where calendar_type = bc.deprn_calendar
872: and bc.book_type_code = x_book
873: and dpr_in.prorate_date
875: if l_date_retired > to_date('19691231','YYYYMMDD') then
876: dpr_in.y_end := 1969;
877: select period_num
878: into dpr_in.p_cl_end
879: from fa_calendar_periods cp,
880: fa_book_controls bc
881: where calendar_type = bc.deprn_calendar
882: and bc.book_type_code = x_book
883: and to_date('19691231','YYYYMMDD')
886: else
887: dpr_in.y_end := l_date_retired_year;
888: select period_num
889: into dpr_in.p_cl_end
890: from fa_calendar_periods cp,
891: fa_book_controls bc
892: where calendar_type = bc.deprn_calendar
893: and bc.book_type_code = x_book
894: and l_date_retired
910: if l_date_retired > to_date('19691231','YYYYMMDD') then
911: dpr_in.y_end := 1969;
912: select period_num
913: into dpr_in.p_cl_end
914: from fa_calendar_periods cp,
915: fa_book_controls bc
916: where calendar_type = bc.deprn_calendar
917: and bc.book_type_code = x_book
918: and to_date('19691231','YYYYMMDD')
921: else
922: dpr_in.y_end := l_date_retired_year;
923: select period_num
924: into dpr_in.p_cl_end
925: from fa_calendar_periods cp,
926: fa_book_controls bc
927: where calendar_type = bc.deprn_calendar
928: and bc.book_type_code = x_book
929: and l_date_retired