APPS.FA_SORP_UPG_PKG dependencies on FA_MC_IMPAIRMENTS

Line 254: FA_MC_IMPAIRMENTS imp,

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
258: where itf.impairment_id = imp.impairment_id

Line 284: FA_MC_IMPAIRMENTS imp,

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
288: where itf.impairment_id = imp.impairment_id

Line 1838: FROM fa_additions_v a, FA_MC_IMPAIRMENTS i

1834: 'CEB','CEB',
1835: 'OTH'),
1836: 'OTH'
1837: ) impair_classification_type
1838: FROM fa_additions_v a, FA_MC_IMPAIRMENTS i
1839: WHERE a.asset_id = i.asset_id AND i.book_type_code = p_book;
1840:
1841: v_imp_asset_cur c_imp_asset_cur%ROWTYPE;
1842:

Line 1881: FROM fa_cash_gen_units a, FA_MC_IMPAIRMENTS i

1877: NVL (i.description, 'Others') imp_description,
1878: NVL (SUBSTR (i.description, 1, 3),
1879: 'OTH'
1880: ) impair_classification_type
1881: FROM fa_cash_gen_units a, FA_MC_IMPAIRMENTS i
1882: WHERE a.cash_generating_unit_id = i.cash_generating_unit_id
1883: AND i.book_type_code = p_book;
1884:
1885: v_imp_cash_cur c_imp_cash_cur%ROWTYPE;

Line 2209: UPDATE FA_MC_IMPAIRMENTS

2205:
2206: l_capital_amount := v_final_imp_asset_cur.imp_amount+nvl(v_imp_deprn_asset_cur.capital_adjustment,0);
2207: l_general_fund_amount := v_final_imp_asset_cur.imp_amount+nvl(v_imp_deprn_asset_cur.general_fund,0);
2208:
2209: UPDATE FA_MC_IMPAIRMENTS
2210: SET reason = v_final_imp_asset_cur.imp_description,
2211: impair_class = v_final_imp_asset_cur.imp_class_type,
2212: split_impair_flag = 'N'
2213: WHERE book_type_code = p_book

Line 2236: UPDATE FA_MC_IMPAIRMENTS

2232: INTO v_final_imp_cash_cur;
2233:
2234: EXIT WHEN c_final_imp_cash_cur%NOTFOUND;
2235:
2236: UPDATE FA_MC_IMPAIRMENTS
2237: SET reason = v_final_imp_cash_cur.imp_description,
2238: impair_class = v_final_imp_cash_cur.imp_class_type,
2239: split_impair_flag = 'N'
2240: WHERE book_type_code = p_book