190: previous_end_date date;
191: l_rate_source_rule varchar2(10);
192: cursor c_rsr is
193: select rate_source_rule
194: from fa_methods
195: where method_code = l_method_code;
196: l_start_date date;
197: l_fiscal_year_name varchar2(30);
198: cursor c_end is
248: ret.date_retired,
249: to_number(to_char(ret.date_retired,'YYYY')),
250: th.transaction_type_code
251: FROM fa_ceiling_types ceilt,
252: fa_methods mt,
253: fa_category_books cb,
254: fa_books bk,
255: fa_transaction_headers th,
256: fa_retirements ret,
677: previous_end_date date;
678: l_rate_source_rule varchar2(10);
679: cursor c_rsr is
680: select rate_source_rule
681: from fa_methods
682: where method_code = l_method_code;
683: l_start_date date;
684: l_fiscal_year_name varchar2(30);
685: cursor c_end is
735: ret.date_retired,
736: to_number(to_char(ret.date_retired,'YYYY')),
737: th.transaction_type_code
738: FROM fa_ceiling_types ceilt,
739: fa_methods mt,
740: fa_category_books cb,
741: fa_books bk,
742: fa_transaction_headers th,
743: fa_retirements ret,