APPS.IGI_IAC_RECLASS_PKG dependencies on FA_BOOKS

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

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
1464: SELECT deprn_amount
1465: FROM fa_deprn_summary

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

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
2143: SELECT deprn_amount
2144: FROM fa_deprn_summary

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

2968: AND rul.asset_id = l_asset_hdr_rec.ASSET_ID
2969: order by revaluation_period;
2970:
2971: /* Cursor to get fully reserved, fully retired info for the asset from FA */
2972: CURSOR c_fa_books(p_asset_id fa_books.asset_id%TYPE) IS
2973: SELECT salvage_value,cost
2974: FROM fa_books
2975: WHERE book_type_code = p_book_type_code
2976: AND asset_id = p_asset_id

Line 2974: FROM fa_books

2970:
2971: /* Cursor to get fully reserved, fully retired info for the asset from FA */
2972: CURSOR c_fa_books(p_asset_id fa_books.asset_id%TYPE) IS
2973: SELECT salvage_value,cost
2974: FROM fa_books
2975: WHERE book_type_code = p_book_type_code
2976: AND asset_id = p_asset_id
2977: AND transactioN_header_id_out is NULL ;
2978:

Line 3214: OPEN c_fa_books(p_asset_id);

3210: END IF;
3211: /* Bug 2961656 vgadde 08-Jul-2003 End(2) */
3212: /*Salavge value correction*/
3213: -- resreve
3214: OPEN c_fa_books(p_asset_id);
3215: FETCH c_fa_books into l_salvage_value,
3216: l_cost;
3217: CLOSE c_fa_books;
3218: IF l_salvage_value <> 0 Then

Line 3215: FETCH c_fa_books into l_salvage_value,

3211: /* Bug 2961656 vgadde 08-Jul-2003 End(2) */
3212: /*Salavge value correction*/
3213: -- resreve
3214: OPEN c_fa_books(p_asset_id);
3215: FETCH c_fa_books into l_salvage_value,
3216: l_cost;
3217: CLOSE c_fa_books;
3218: IF l_salvage_value <> 0 Then
3219: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 3217: CLOSE c_fa_books;

3213: -- resreve
3214: OPEN c_fa_books(p_asset_id);
3215: FETCH c_fa_books into l_salvage_value,
3216: l_cost;
3217: CLOSE c_fa_books;
3218: IF l_salvage_value <> 0 Then
3219: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
3220: p_full_path => l_path_name,
3221: p_string => '+Salavge Value Correction deprn_amount_py before :' ||l_fa_deprn_amount_py);