APPS.IGI_IAC_RECLASS_PKG dependencies on FA_BOOKS

Line 1494: /* To select the asset's deprn_expense from fa_books */

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
1497: SELECT deprn_amount
1498: FROM fa_deprn_summary

Line 2173: /* To select the asset's deprn_expense from fa_books */

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
2176: SELECT deprn_amount
2177: FROM fa_deprn_summary

Line 3005: CURSOR c_fa_books(p_asset_id fa_books.asset_id%TYPE) IS

3001: AND rul.asset_id = l_asset_hdr_rec.ASSET_ID
3002: order by revaluation_period;
3003:
3004: /* Cursor to get fully reserved, fully retired info for the asset from FA */
3005: CURSOR c_fa_books(p_asset_id fa_books.asset_id%TYPE) IS
3006: SELECT salvage_value,cost
3007: FROM fa_books
3008: WHERE book_type_code = p_book_type_code
3009: AND asset_id = p_asset_id

Line 3007: FROM fa_books

3003:
3004: /* Cursor to get fully reserved, fully retired info for the asset from FA */
3005: CURSOR c_fa_books(p_asset_id fa_books.asset_id%TYPE) IS
3006: SELECT salvage_value,cost
3007: FROM fa_books
3008: WHERE book_type_code = p_book_type_code
3009: AND asset_id = p_asset_id
3010: AND transactioN_header_id_out is NULL ;
3011:

Line 3247: OPEN c_fa_books(p_asset_id);

3243: END IF;
3244: /* Bug 2961656 vgadde 08-Jul-2003 End(2) */
3245: /*Salavge value correction*/
3246: -- resreve
3247: OPEN c_fa_books(p_asset_id);
3248: FETCH c_fa_books into l_salvage_value,
3249: l_cost;
3250: CLOSE c_fa_books;
3251: IF l_salvage_value <> 0 Then

Line 3248: FETCH c_fa_books into l_salvage_value,

3244: /* Bug 2961656 vgadde 08-Jul-2003 End(2) */
3245: /*Salavge value correction*/
3246: -- resreve
3247: OPEN c_fa_books(p_asset_id);
3248: FETCH c_fa_books into l_salvage_value,
3249: l_cost;
3250: CLOSE c_fa_books;
3251: IF l_salvage_value <> 0 Then
3252: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 3250: CLOSE c_fa_books;

3246: -- resreve
3247: OPEN c_fa_books(p_asset_id);
3248: FETCH c_fa_books into l_salvage_value,
3249: l_cost;
3250: CLOSE c_fa_books;
3251: IF l_salvage_value <> 0 Then
3252: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
3253: p_full_path => l_path_name,
3254: p_string => '+Salavge Value Correction deprn_amount_py before :' ||l_fa_deprn_amount_py);