1488: /* Cursor to select the adjustment_id from the sequence for a new record */
1489:
1490: CURSOR c_adj_id IS
1491: SELECT igi_iac_transaction_headers_s.nextval
1492: FROM dual;
1493:
1494: /* To select the asset's deprn_expense from fa_books */
1495:
1496: CURSOR c_deprn_expense(c_period_counter FA_DEPRN_SUMMARY.period_counter%TYPE) IS
2167: /* Cursor to select the adjustment_id from the sequence for a new record */
2168:
2169: CURSOR c_adj_id IS
2170: SELECT igi_iac_transaction_headers_s.nextval
2171: FROM dual;
2172:
2173: /* To select the asset's deprn_expense from fa_books */
2174:
2175: CURSOR c_deprn_expense(c_period_counter FA_DEPRN_SUMMARY.period_counter%type) IS
3374: IF (l_idx2 = l_idx1) THEN
3375: /* Last revaluation - Insert records into revaluation tables*/
3376: /* SELECT igi_iac_revaluations_s.nextval
3377: INTO l_revaluation_id
3378: FROM DUAL;
3379: Debug(0,'Last Revaluation - Inseting into igi_iac_revaluations');
3380: Debug(0,'Revaluation Id :'||to_char(l_revaluation_id));
3381:
3382: