DBA Data[Home] [Help]

APPS.IGI_IAC_RECLASS_PKG dependencies on DUAL

Line 1459: FROM dual;

1455: /* Cursor to select the adjustment_id from the sequence for a new record */
1456:
1457: CURSOR c_adj_id IS
1458: SELECT igi_iac_transaction_headers_s.nextval
1459: FROM dual;
1460:
1461: /* To select the asset's deprn_expense from fa_books */
1462:
1463: CURSOR c_deprn_expense(c_period_counter FA_DEPRN_SUMMARY.period_counter%TYPE) IS

Line 2138: FROM dual;

2134: /* Cursor to select the adjustment_id from the sequence for a new record */
2135:
2136: CURSOR c_adj_id IS
2137: SELECT igi_iac_transaction_headers_s.nextval
2138: FROM dual;
2139:
2140: /* To select the asset's deprn_expense from fa_books */
2141:
2142: CURSOR c_deprn_expense(c_period_counter FA_DEPRN_SUMMARY.period_counter%type) IS

Line 3345: FROM DUAL;

3341: IF (l_idx2 = l_idx1) THEN
3342: /* Last revaluation - Insert records into revaluation tables*/
3343: /* SELECT igi_iac_revaluations_s.nextval
3344: INTO l_revaluation_id
3345: FROM DUAL;
3346: Debug(0,'Last Revaluation - Inseting into igi_iac_revaluations');
3347: Debug(0,'Revaluation Id :'||to_char(l_revaluation_id));
3348:
3349: