APPS.FA_FAS445_XMLP_PKG dependencies on FA_TRANSACTION_HEADERS

Line 255: fa_transaction_headers th,

251: FROM fa_ceiling_types ceilt,
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

Line 289: fa_transaction_headers th

285: into dpr_in.deprn_rsv, dpr_in.ytd_deprn, l_main_dpis,
286: l_method_code
287: from fa_deprn_summary ds,
288: fa_books bk,
289: fa_transaction_headers th
290: where ds.book_type_code = X_book
291: and ds.asset_id = X_asset_id
292: and ds.deprn_source_code = 'BOOKS'
293: and th.transaction_header_id = bk.transaction_header_id_in

Line 295: from fa_transaction_headers thsub

291: and ds.asset_id = X_asset_id
292: and ds.deprn_source_code = 'BOOKS'
293: and th.transaction_header_id = bk.transaction_header_id_in
294: and th.transaction_header_id in (select max(transaction_header_id)
295: from fa_transaction_headers thsub
296: where transaction_type_code like '%RETIREMENT'
297: and book_type_code = x_book
298: and asset_id = x_asset_id)
299: ;

Line 742: fa_transaction_headers th,

738: FROM fa_ceiling_types ceilt,
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

Line 777: fa_transaction_headers th

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'
781: and th.transaction_header_id = bk.transaction_header_id_in

Line 784: from fa_transaction_headers thsub

780: and ds.deprn_source_code = 'BOOKS'
781: and th.transaction_header_id = bk.transaction_header_id_in
782: and th.transaction_header_id = ret.transaction_header_id_in
783: and th.transaction_header_id in (select max(transaction_header_id)
784: from fa_transaction_headers thsub
785: where transaction_type_code like '%RETIREMENT'
786: and book_type_code = x_book
787: and asset_id = x_asset_id)
788: ;