DBA Data[Home] [Help]

APPS.FA_IMPAIRMENT_DELETE_PVT dependencies on FA_IMPAIRMENTS

Line 68: from fa_impairments imp

64: fa_books
65: where transaction_header_id_out is null
66: and book_type_code = p_book_type_code
67: and asset_id in (select itf.asset_id
68: from fa_impairments imp
69: , fa_itf_impairments itf
70: where itf.impairment_id = imp.impairment_id
71: and itf.book_type_code = p_book_type_code
72: and itf.worker_id = p_worker_id

Line 198: from fa_impairments imp

194: delete from fa_books
195: where transaction_header_id_out is null
196: and book_type_code = p_book_type_code
197: and asset_id in (select itf.asset_id
198: from fa_impairments imp
199: , fa_itf_impairments itf
200: where itf.impairment_id = imp.impairment_id
201: and itf.book_type_code = p_book_type_code
202: and itf.worker_id = p_worker_id