APPS.FA_SORP_UPG_PKG dependencies on FA_ITF_IMPAIRMENTS

Line 139: fa_itf_impairments itf,

135: adj.adjustment_type,
136: nvl(decode(adj.debit_credit_flag,'DR',(-1*adj.adjustment_amount)),0) adjustment_amount,
137: det.distribution_id
138: from
139: fa_itf_impairments itf,
140: fa_impairments imp,
141: fa_transaction_headers th,
142: fa_adjustments adj,
143: fa_deprn_detail det

Line 168: fa_itf_impairments itf,

164: th.transaction_header_id,
165: adj.adjustment_type,
166: nvl(decode(adj.debit_credit_flag,'DR',(-1*adj.adjustment_amount)),0) adjustment_amount
167: from
168: fa_itf_impairments itf,
169: fa_impairments imp,
170: fa_transaction_headers th,
171: fa_adjustments adj,
172: fa_deprn_summary su

Line 2392: FROM fa_itf_impairments

2388:
2389: CURSOR c_imp_itf_asset_cur
2390: IS
2391: SELECT impairment_amount
2392: FROM fa_itf_impairments
2393: WHERE impairment_id = v_impairment_id
2394: AND asset_id = v_asset_id
2395: AND book_type_code = p_book;
2396:

Line 2436: FROM fa_itf_impairments

2432:
2433: CURSOR c_imp_itf_cash_cur
2434: IS
2435: SELECT impairment_amount
2436: FROM fa_itf_impairments
2437: WHERE impairment_id = v_impairment_id
2438: AND cash_generating_unit_id = v_cash_id
2439: AND book_type_code = p_book;
2440:

Line 2741: from fa_itf_impairments

2737: EXIT WHEN c_final_imp_asset_cur%NOTFOUND;
2738: /*Bug# 14596931 - For records not in status PREVIEWED/POSTED there won't be any data in itf table */
2739: begin
2740: select period_counter into l_counter
2741: from fa_itf_impairments
2742: where impairment_id = v_final_imp_asset_cur.impairment_id;
2743: exception
2744: when no_data_found then
2745: l_counter := 0;

Line 2764: UPDATE fa_itf_impairments

2760: WHERE book_type_code = p_book
2761: AND impairment_id = v_final_imp_asset_cur.impairment_id
2762: AND asset_id = v_final_imp_asset_cur.ID;
2763:
2764: UPDATE fa_itf_impairments
2765: SET capital_adjustment = l_capital_amount,
2766: general_fund = l_general_fund_amount,
2767: split_impair_flag = 'N'
2768: WHERE book_type_code = p_book

Line 2791: UPDATE fa_itf_impairments

2787: WHERE book_type_code = p_book
2788: AND impairment_id = v_final_imp_cash_cur.impairment_id
2789: AND cash_generating_unit_id = v_final_imp_cash_cur.ID;
2790:
2791: UPDATE fa_itf_impairments
2792: SET capital_adjustment = v_final_imp_cash_cur.imp_amount,
2793: general_fund = v_final_imp_cash_cur.imp_amount,
2794: split_impair_flag = 'N'
2795: WHERE book_type_code = p_book