34: )
35: is
36: cursor c_reval is
37: select revaluation_id, book_type_code, revaluation_period
38: from igi_iac_revaluations
39: where revaluation_id = p_revaluation_id
40: ;
41: l_report_request_id number;
42: l_retcode number;
123: -- record is processed again.
124: */
125: cursor c_revaluations is
126: select iir.revaluation_id, iir.book_type_code
127: from igi_iac_revaluations iir
128: where iir.revaluation_id = fp_revaluation_id
129: and iir.book_type_code = fp_book_type_code
130: ;
131:
388: */
389: l_number number ;
390: cursor c_revaluations is
391: select iir.revaluation_id, iir.book_type_code
392: from igi_iac_revaluations iir
393: where iir.revaluation_id = fp_revaluation_id
394: and iir.book_type_code = fp_book_type_code
395: -- and upper(iir.status) = IGI_IAC_TYPES.gc_previewed_status
396: ;