[Home] [Help]
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
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
2296: select cbd.percent_salvage_value
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
7255: fa_transaction_headers th,
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
7291: fa_book_controls bc,
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'