APPS.FA_SORP_UPG_PKG dependencies on FA_IMPAIRMENTS

Line 140: fa_impairments imp,

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

Line 169: fa_impairments imp,

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

Line 2384: FROM fa_additions_v a, fa_impairments i

2380: 'CEB','CEB',
2381: 'OTH'),
2382: 'OTH'
2383: ) impair_classification_type
2384: FROM fa_additions_v a, fa_impairments i
2385: WHERE a.asset_id = i.asset_id AND i.book_type_code = p_book;
2386:
2387: v_imp_asset_cur c_imp_asset_cur%ROWTYPE;
2388:

Line 2427: FROM fa_cash_gen_units a, fa_impairments i

2423: NVL (i.description, 'Others') imp_description,
2424: NVL (SUBSTR (i.description, 1, 3),
2425: 'OTH'
2426: ) impair_classification_type
2427: FROM fa_cash_gen_units a, fa_impairments i
2428: WHERE a.cash_generating_unit_id = i.cash_generating_unit_id
2429: AND i.book_type_code = p_book;
2430:
2431: v_imp_cash_cur c_imp_cash_cur%ROWTYPE;

Line 2756: UPDATE fa_impairments

2752:
2753: l_capital_amount := v_final_imp_asset_cur.imp_amount+nvl(v_imp_deprn_asset_cur.capital_adjustment,0);
2754: l_general_fund_amount := v_final_imp_asset_cur.imp_amount+nvl(v_imp_deprn_asset_cur.general_fund,0);
2755:
2756: UPDATE fa_impairments
2757: SET reason = v_final_imp_asset_cur.imp_description,
2758: impair_class = v_final_imp_asset_cur.imp_class_type,
2759: split_impair_flag = 'N'
2760: WHERE book_type_code = p_book

Line 2783: UPDATE fa_impairments

2779: INTO v_final_imp_cash_cur;
2780:
2781: EXIT WHEN c_final_imp_cash_cur%NOTFOUND;
2782:
2783: UPDATE fa_impairments
2784: SET reason = v_final_imp_cash_cur.imp_description,
2785: impair_class = v_final_imp_cash_cur.imp_class_type,
2786: split_impair_flag = 'N'
2787: WHERE book_type_code = p_book