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 236: l_ret_prorate_convention FA_CATEGORY_BOOK_DEFAULTS.prorate_convention_code%TYPE;

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

Line 237: l_use_stl_retirements_flag FA_CATEGORY_BOOK_DEFAULTS.use_stl_retirements_flag%TYPE;

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

Line 238: l_stl_method_code FA_CATEGORY_BOOK_DEFAULTS.stl_method_code%TYPE;

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

Line 239: l_stl_life_in_months FA_CATEGORY_BOOK_DEFAULTS.stl_life_in_months%TYPE;

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

Line 569: FROM fa_category_book_defaults, fa_additions_b a

565: l_ret_prorate_convention,
566: l_use_stl_retirements_flag,
567: l_stl_method_code,
568: l_stl_life_in_months
569: FROM fa_category_book_defaults, fa_additions_b a
570: WHERE book_type_code = l_asset_hdr_rec.book_type_code
571: and category_id = a.asset_category_id
572: and a.asset_id = l_asset_hdr_rec.asset_id
573: and l_asset_fin_rec.Date_Placed_In_Service between start_dpis and

Line 1251: l_ret_prorate_convention FA_CATEGORY_BOOK_DEFAULTS.prorate_convention_code%TYPE;

1247: l_fiscal_year_name varchar2(30);
1248:
1249:
1250: -- used for category defaulting
1251: l_ret_prorate_convention FA_CATEGORY_BOOK_DEFAULTS.prorate_convention_code%TYPE;
1252: l_use_stl_retirements_flag FA_CATEGORY_BOOK_DEFAULTS.use_stl_retirements_flag%TYPE;
1253: l_stl_method_code FA_CATEGORY_BOOK_DEFAULTS.stl_method_code%TYPE;
1254: l_stl_life_in_months FA_CATEGORY_BOOK_DEFAULTS.stl_life_in_months%TYPE;
1255:

Line 1252: l_use_stl_retirements_flag FA_CATEGORY_BOOK_DEFAULTS.use_stl_retirements_flag%TYPE;

1248:
1249:
1250: -- used for category defaulting
1251: l_ret_prorate_convention FA_CATEGORY_BOOK_DEFAULTS.prorate_convention_code%TYPE;
1252: l_use_stl_retirements_flag FA_CATEGORY_BOOK_DEFAULTS.use_stl_retirements_flag%TYPE;
1253: l_stl_method_code FA_CATEGORY_BOOK_DEFAULTS.stl_method_code%TYPE;
1254: l_stl_life_in_months FA_CATEGORY_BOOK_DEFAULTS.stl_life_in_months%TYPE;
1255:
1256:

Line 1253: l_stl_method_code FA_CATEGORY_BOOK_DEFAULTS.stl_method_code%TYPE;

1249:
1250: -- used for category defaulting
1251: l_ret_prorate_convention FA_CATEGORY_BOOK_DEFAULTS.prorate_convention_code%TYPE;
1252: l_use_stl_retirements_flag FA_CATEGORY_BOOK_DEFAULTS.use_stl_retirements_flag%TYPE;
1253: l_stl_method_code FA_CATEGORY_BOOK_DEFAULTS.stl_method_code%TYPE;
1254: l_stl_life_in_months FA_CATEGORY_BOOK_DEFAULTS.stl_life_in_months%TYPE;
1255:
1256:
1257: -- added for bug 3684222

Line 1254: l_stl_life_in_months FA_CATEGORY_BOOK_DEFAULTS.stl_life_in_months%TYPE;

1250: -- used for category defaulting
1251: l_ret_prorate_convention FA_CATEGORY_BOOK_DEFAULTS.prorate_convention_code%TYPE;
1252: l_use_stl_retirements_flag FA_CATEGORY_BOOK_DEFAULTS.use_stl_retirements_flag%TYPE;
1253: l_stl_method_code FA_CATEGORY_BOOK_DEFAULTS.stl_method_code%TYPE;
1254: l_stl_life_in_months FA_CATEGORY_BOOK_DEFAULTS.stl_life_in_months%TYPE;
1255:
1256:
1257: -- added for bug 3684222
1258: l_latest_reval_date date;

Line 1452: FROM fa_category_book_defaults, fa_additions_b a

1448: l_ret_prorate_convention,
1449: l_use_stl_retirements_flag,
1450: l_stl_method_code,
1451: l_stl_life_in_months
1452: FROM fa_category_book_defaults, fa_additions_b a
1453: WHERE book_type_code = l_asset_hdr_rec.book_type_code
1454: and category_id = a.asset_category_id
1455: and a.asset_id = l_asset_hdr_rec.asset_id
1456: and l_asset_fin_rec.Date_Placed_In_Service between start_dpis and

Line 2301: ,fa_category_book_defaults cbd

2297: ,cbd.use_deprn_limits_flag
2298: ,cbd.allowed_deprn_limit
2299: ,cbd.special_deprn_limit_amount
2300: from fa_additions_b fad
2301: ,fa_category_book_defaults cbd
2302: where fad.asset_id = p_asset_id
2303: and cbd.category_id = fad.asset_category_id
2304: and cbd.book_type_code = p_book_type_code
2305: and p_dpis

Line 7260: fa_category_book_defaults cbd

7256: fa_calendar_periods cp,
7257: fa_book_controls bc,
7258: fa_conventions con,
7259: fa_additions_b ad,
7260: fa_category_book_defaults cbd
7261: where th.book_type_code = l_asset_hdr_rec.book_type_code
7262: and th.asset_id = l_asset_hdr_rec.asset_id
7263: and ad.asset_id = l_asset_hdr_rec.asset_id
7264: and cbd.book_type_code = l_asset_hdr_rec.book_type_code

Line 7296: fa_category_book_defaults cbd

7292: fa_conventions con,
7293: fa_deprn_override ovr,
7294: fa_deprn_periods fadp,
7295: fa_additions_b ad,
7296: fa_category_book_defaults cbd
7297: where ovr.book_type_code = l_asset_hdr_rec.book_type_code
7298: and ovr.asset_id = l_asset_hdr_rec.asset_id
7299: and ovr.status = 'POSTED'
7300: and fadp.book_type_code = l_asset_hdr_rec.book_type_code