APPS.FA_FAS443_XMLP_PKG dependencies on FA_TRANSACTION_HEADERS

Line 204: l_ttcode fa_transaction_headers.transaction_type_code%TYPE;

200: l_new_gain_loss number;
201: l_new_ordinary_income number;
202: l_new_capital_gain number;
203: l_cost_retired number;
204: l_ttcode fa_transaction_headers.transaction_type_code%TYPE;
205: l_main_dpis date;
206: l_date_retired date;
207: l_date_retired_year number;
208: previous_y_end number;

Line 275: fa_transaction_headers th,

271: fa_methods mt,
272: fa_category_books cb,
273: fa_books bk,
274: fa_retirements ret,
275: fa_transaction_headers th,
276: fa_additions ad
277: WHERE cb.book_type_code = X_book
278: AND ad.asset_category_id = cb.category_id
279: AND ceilt.ceiling_name(+) = bk.ceiling_name

Line 309: fa_transaction_headers th

305: select deprn_reserve, ytd_deprn, bk.date_placed_in_service, bk.deprn_method_code
306: into dpr_in.deprn_rsv, dpr_in.ytd_deprn, l_main_dpis, l_method_code
307: from fa_deprn_summary ds,
308: fa_books bk,
309: fa_transaction_headers th
310: where ds.book_type_code = X_book
311: and ds.asset_id = X_asset_id
312: and ds.deprn_source_code = 'BOOKS'
313: and th.transaction_header_id = bk.transaction_header_id_in

Line 315: from fa_transaction_headers thsub

311: and ds.asset_id = X_asset_id
312: and ds.deprn_source_code = 'BOOKS'
313: and th.transaction_header_id = bk.transaction_header_id_in
314: and th.transaction_header_id in (select max(transaction_header_id)
315: from fa_transaction_headers thsub
316: where transaction_type_code like '%RETIREMENT'
317: and book_type_code = x_book
318: and asset_id = x_asset_id)
319: ;