eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_FAS445_XMLP_PKG dependencies on FA_RETIREMENTS

Line 169: l_stl_method_code fa_retirements.stl_method_code%TYPE;

165: l_new_gain_loss number;
166: l_new_ordinary_income number;
167: l_new_capital_gain number;
168: l_reserve_retired number;
169: l_stl_method_code fa_retirements.stl_method_code%TYPE;
170: l_stl_life_in_months fa_retirements.stl_life_in_months%TYPE;
171: l_stl_deprn_amount number;
172: l_diff_stl number;
173: l_stl_deprn_reserve_1962 number := 0;

Line 170: l_stl_life_in_months fa_retirements.stl_life_in_months%TYPE;

166: l_new_ordinary_income number;
167: l_new_capital_gain number;
168: l_reserve_retired number;
169: l_stl_method_code fa_retirements.stl_method_code%TYPE;
170: l_stl_life_in_months fa_retirements.stl_life_in_months%TYPE;
171: l_stl_deprn_amount number;
172: l_diff_stl number;
173: l_stl_deprn_reserve_1962 number := 0;
174: l_excess_deprn number;

Line 256: fa_retirements ret,

252: fa_methods mt,
253: fa_category_books cb,
254: fa_books bk,
255: fa_transaction_headers th,
256: fa_retirements ret,
257: fa_additions ad
258: WHERE cb.book_type_code = X_book
259: AND ad.asset_category_id = cb.category_id
260: AND ceilt.ceiling_name(+) = bk.ceiling_name

Line 657: l_stl_method_code fa_retirements.stl_method_code%TYPE;

653: l_new_ordinary_income number;
654: l_new_capital_gain number;
655: l_reserve_retired number;
656: l_stl_deprn_amount number := 0;
657: l_stl_method_code fa_retirements.stl_method_code%TYPE;
658: l_stl_life_in_months fa_retirements.stl_life_in_months%TYPE;
659: l_diff_stl number;
660: l_stl_deprn_reserve_1969 number := 0;
661: l_excess_deprn number;

Line 658: l_stl_life_in_months fa_retirements.stl_life_in_months%TYPE;

654: l_new_capital_gain number;
655: l_reserve_retired number;
656: l_stl_deprn_amount number := 0;
657: l_stl_method_code fa_retirements.stl_method_code%TYPE;
658: l_stl_life_in_months fa_retirements.stl_life_in_months%TYPE;
659: l_diff_stl number;
660: l_stl_deprn_reserve_1969 number := 0;
661: l_excess_deprn number;
662: l_recap_gain number;

Line 743: fa_retirements ret,

739: fa_methods mt,
740: fa_category_books cb,
741: fa_books bk,
742: fa_transaction_headers th,
743: fa_retirements ret,
744: fa_additions ad
745: WHERE cb.book_type_code = X_book
746: AND ad.asset_category_id = cb.category_id
747: AND ceilt.ceiling_name(+) = bk.ceiling_name

Line 758: test_stl_deprn_amount fa_retirements.stl_deprn_amount%TYPE;

754: AND ret.status = 'PROCESSED'
755: AND nvl (mt.life_in_months, -9999) =
756: nvl (bk.life_in_months, -9999)
757: AND ad.asset_id = bk.asset_id;
758: test_stl_deprn_amount fa_retirements.stl_deprn_amount%TYPE;
759: test_stl_method_code fa_retirements.stl_method_code%TYPE;
760: BEGIN
761: if print_debug = 'Y' then
762: /*srw.message(9999,'Starting D_EXCESS_1969');*/null;

Line 759: test_stl_method_code fa_retirements.stl_method_code%TYPE;

755: AND nvl (mt.life_in_months, -9999) =
756: nvl (bk.life_in_months, -9999)
757: AND ad.asset_id = bk.asset_id;
758: test_stl_deprn_amount fa_retirements.stl_deprn_amount%TYPE;
759: test_stl_method_code fa_retirements.stl_method_code%TYPE;
760: BEGIN
761: if print_debug = 'Y' then
762: /*srw.message(9999,'Starting D_EXCESS_1969');*/null;
763: /*srw.message(9999,book);*/null;

Line 776: fa_retirements ret,

772: into dpr_in.deprn_rsv, dpr_in.ytd_deprn, l_main_dpis,
773: l_method_code, test_stl_deprn_amount, test_stl_method_code
774: from fa_deprn_summary ds,
775: fa_books bk,
776: fa_retirements ret,
777: fa_transaction_headers th
778: where ds.book_type_code = X_book
779: and ds.asset_id = X_asset_id
780: and ds.deprn_source_code = 'BOOKS'