APPS.FA_SORP_UPG_PKG dependencies on FA_MC_ITF_IMPAIRMENTS

Line 253: FA_MC_ITF_IMPAIRMENTS itf,

249: adj.adjustment_type,
250: nvl(decode(adj.debit_credit_flag,'DR',(-1*adj.adjustment_amount)),0) adjustment_amount,
251: det.distribution_id
252: from
253: FA_MC_ITF_IMPAIRMENTS itf,
254: FA_MC_IMPAIRMENTS imp,
255: fa_transaction_headers th,
256: fa_adjustments adj,
257: FA_MC_DEPRN_DETAIL det

Line 283: FA_MC_ITF_IMPAIRMENTS itf,

279: th.transaction_header_id,
280: adj.adjustment_type,
281: nvl(decode(adj.debit_credit_flag,'DR',(-1*adj.adjustment_amount)),0) adjustment_amount
282: from
283: FA_MC_ITF_IMPAIRMENTS itf,
284: FA_MC_IMPAIRMENTS imp,
285: fa_transaction_headers th,
286: fa_adjustments adj,
287: FA_MC_DEPRN_SUMMARY su

Line 1846: FROM FA_MC_ITF_IMPAIRMENTS

1842:
1843: CURSOR c_imp_itf_asset_cur
1844: IS
1845: SELECT impairment_amount
1846: FROM FA_MC_ITF_IMPAIRMENTS
1847: WHERE impairment_id = v_impairment_id
1848: AND asset_id = v_asset_id
1849: AND book_type_code = p_book;
1850:

Line 1890: FROM FA_MC_ITF_IMPAIRMENTS

1886:
1887: CURSOR c_imp_itf_cash_cur
1888: IS
1889: SELECT impairment_amount
1890: FROM FA_MC_ITF_IMPAIRMENTS
1891: WHERE impairment_id = v_impairment_id
1892: AND cash_generating_unit_id = v_cash_id
1893: AND book_type_code = p_book;
1894:

Line 2193: from fa_mc_itf_impairments

2189:
2190: /*Bug# 14596931 - For records not in status PREVIEWED/POSTED there won't be any data in itf table */
2191: begin
2192: select period_counter into l_counter
2193: from fa_mc_itf_impairments
2194: where impairment_id = v_final_imp_asset_cur.impairment_id;
2195: exception
2196: when no_data_found then
2197: l_counter := 0;

Line 2217: UPDATE FA_MC_ITF_IMPAIRMENTS

2213: WHERE book_type_code = p_book
2214: AND impairment_id = v_final_imp_asset_cur.impairment_id
2215: AND asset_id = v_final_imp_asset_cur.ID;
2216:
2217: UPDATE FA_MC_ITF_IMPAIRMENTS
2218: SET capital_adjustment = l_capital_amount,
2219: general_fund = l_general_fund_amount,
2220: split_impair_flag = 'N'
2221: WHERE book_type_code = p_book

Line 2244: UPDATE FA_MC_ITF_IMPAIRMENTS

2240: WHERE book_type_code = p_book
2241: AND impairment_id = v_final_imp_cash_cur.impairment_id
2242: AND cash_generating_unit_id = v_final_imp_cash_cur.ID;
2243:
2244: UPDATE FA_MC_ITF_IMPAIRMENTS
2245: SET capital_adjustment = v_final_imp_cash_cur.imp_amount,
2246: general_fund = v_final_imp_cash_cur.imp_amount,
2247: split_impair_flag = 'N'
2248: WHERE book_type_code = p_book