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_RETIREMENT_PUB dependencies on FA_CATEGORY_BOOK_DEFAULTS

Line 234: l_ret_prorate_convention FA_CATEGORY_BOOK_DEFAULTS.prorate_convention_code%TYPE;

230:
231:
232: /**
233: -- used for category defaulting
234: l_ret_prorate_convention FA_CATEGORY_BOOK_DEFAULTS.prorate_convention_code%TYPE;
235: l_use_stl_retirements_flag FA_CATEGORY_BOOK_DEFAULTS.use_stl_retirements_flag%TYPE;
236: l_stl_method_code FA_CATEGORY_BOOK_DEFAULTS.stl_method_code%TYPE;
237: l_stl_life_in_months FA_CATEGORY_BOOK_DEFAULTS.stl_life_in_months%TYPE;
238: **/

Line 235: l_use_stl_retirements_flag FA_CATEGORY_BOOK_DEFAULTS.use_stl_retirements_flag%TYPE;

231:
232: /**
233: -- used for category defaulting
234: l_ret_prorate_convention FA_CATEGORY_BOOK_DEFAULTS.prorate_convention_code%TYPE;
235: l_use_stl_retirements_flag FA_CATEGORY_BOOK_DEFAULTS.use_stl_retirements_flag%TYPE;
236: l_stl_method_code FA_CATEGORY_BOOK_DEFAULTS.stl_method_code%TYPE;
237: l_stl_life_in_months FA_CATEGORY_BOOK_DEFAULTS.stl_life_in_months%TYPE;
238: **/
239:

Line 236: l_stl_method_code FA_CATEGORY_BOOK_DEFAULTS.stl_method_code%TYPE;

232: /**
233: -- used for category defaulting
234: l_ret_prorate_convention FA_CATEGORY_BOOK_DEFAULTS.prorate_convention_code%TYPE;
235: l_use_stl_retirements_flag FA_CATEGORY_BOOK_DEFAULTS.use_stl_retirements_flag%TYPE;
236: l_stl_method_code FA_CATEGORY_BOOK_DEFAULTS.stl_method_code%TYPE;
237: l_stl_life_in_months FA_CATEGORY_BOOK_DEFAULTS.stl_life_in_months%TYPE;
238: **/
239:
240: /*

Line 237: l_stl_life_in_months FA_CATEGORY_BOOK_DEFAULTS.stl_life_in_months%TYPE;

233: -- used for category defaulting
234: l_ret_prorate_convention FA_CATEGORY_BOOK_DEFAULTS.prorate_convention_code%TYPE;
235: l_use_stl_retirements_flag FA_CATEGORY_BOOK_DEFAULTS.use_stl_retirements_flag%TYPE;
236: l_stl_method_code FA_CATEGORY_BOOK_DEFAULTS.stl_method_code%TYPE;
237: l_stl_life_in_months FA_CATEGORY_BOOK_DEFAULTS.stl_life_in_months%TYPE;
238: **/
239:
240: /*
241: * Added for Group Asset uptake

Line 494: FROM fa_category_book_defaults, fa_additions_b a

490: l_ret_prorate_convention,
491: l_use_stl_retirements_flag,
492: l_stl_method_code,
493: l_stl_life_in_months
494: FROM fa_category_book_defaults, fa_additions_b a
495: WHERE book_type_code = l_asset_hdr_rec.book_type_code
496: and category_id = a.asset_category_id
497: and a.asset_id = l_asset_hdr_rec.asset_id
498: and l_asset_fin_rec.Date_Placed_In_Service between start_dpis and

Line 1093: l_ret_prorate_convention FA_CATEGORY_BOOK_DEFAULTS.prorate_convention_code%TYPE;

1089: l_prorate_calendar varchar2(15);
1090: l_fiscal_year_name varchar2(30);
1091:
1092: -- used for category defaulting
1093: l_ret_prorate_convention FA_CATEGORY_BOOK_DEFAULTS.prorate_convention_code%TYPE;
1094: l_use_stl_retirements_flag FA_CATEGORY_BOOK_DEFAULTS.use_stl_retirements_flag%TYPE;
1095: l_stl_method_code FA_CATEGORY_BOOK_DEFAULTS.stl_method_code%TYPE;
1096: l_stl_life_in_months FA_CATEGORY_BOOK_DEFAULTS.stl_life_in_months%TYPE;
1097:

Line 1094: l_use_stl_retirements_flag FA_CATEGORY_BOOK_DEFAULTS.use_stl_retirements_flag%TYPE;

1090: l_fiscal_year_name varchar2(30);
1091:
1092: -- used for category defaulting
1093: l_ret_prorate_convention FA_CATEGORY_BOOK_DEFAULTS.prorate_convention_code%TYPE;
1094: l_use_stl_retirements_flag FA_CATEGORY_BOOK_DEFAULTS.use_stl_retirements_flag%TYPE;
1095: l_stl_method_code FA_CATEGORY_BOOK_DEFAULTS.stl_method_code%TYPE;
1096: l_stl_life_in_months FA_CATEGORY_BOOK_DEFAULTS.stl_life_in_months%TYPE;
1097:
1098:

Line 1095: l_stl_method_code FA_CATEGORY_BOOK_DEFAULTS.stl_method_code%TYPE;

1091:
1092: -- used for category defaulting
1093: l_ret_prorate_convention FA_CATEGORY_BOOK_DEFAULTS.prorate_convention_code%TYPE;
1094: l_use_stl_retirements_flag FA_CATEGORY_BOOK_DEFAULTS.use_stl_retirements_flag%TYPE;
1095: l_stl_method_code FA_CATEGORY_BOOK_DEFAULTS.stl_method_code%TYPE;
1096: l_stl_life_in_months FA_CATEGORY_BOOK_DEFAULTS.stl_life_in_months%TYPE;
1097:
1098:
1099: -- added for bug 3684222

Line 1096: l_stl_life_in_months FA_CATEGORY_BOOK_DEFAULTS.stl_life_in_months%TYPE;

1092: -- used for category defaulting
1093: l_ret_prorate_convention FA_CATEGORY_BOOK_DEFAULTS.prorate_convention_code%TYPE;
1094: l_use_stl_retirements_flag FA_CATEGORY_BOOK_DEFAULTS.use_stl_retirements_flag%TYPE;
1095: l_stl_method_code FA_CATEGORY_BOOK_DEFAULTS.stl_method_code%TYPE;
1096: l_stl_life_in_months FA_CATEGORY_BOOK_DEFAULTS.stl_life_in_months%TYPE;
1097:
1098:
1099: -- added for bug 3684222
1100: l_latest_reval_date date;

Line 1295: FROM fa_category_book_defaults, fa_additions_b a

1291: l_ret_prorate_convention,
1292: l_use_stl_retirements_flag,
1293: l_stl_method_code,
1294: l_stl_life_in_months
1295: FROM fa_category_book_defaults, fa_additions_b a
1296: WHERE book_type_code = l_asset_hdr_rec.book_type_code
1297: and category_id = a.asset_category_id
1298: and a.asset_id = l_asset_hdr_rec.asset_id
1299: and l_asset_fin_rec.Date_Placed_In_Service between start_dpis and

Line 2081: ,fa_category_book_defaults cbd

2077: ,cbd.use_deprn_limits_flag
2078: ,cbd.allowed_deprn_limit
2079: ,cbd.special_deprn_limit_amount
2080: from fa_additions_b fad
2081: ,fa_category_book_defaults cbd
2082: where fad.asset_id = p_asset_id
2083: and cbd.category_id = fad.asset_category_id
2084: and cbd.book_type_code = p_book_type_code
2085: and p_dpis